[Solved]Mysql Query Create Table Appropriate Attributes Data Types Together Primary Keys Foreign K Q37201154

MYSQL query you to create thetable with appropriate attributes and data types together withprimary keys, foreign keys, relationships and constraints. Eachtable must contain a minimum of 3 records.

Then,

1. A query that is based on two tables and includes both anarithmetic and a special operator in the conditionalexpression.
2. A query that is based on more than two tables and includes bothan arithmetic and a special operator in the conditional expression.Both the arithmetic and the special operator must be different fromthe ones used in part a.
3. A query that includes a sub-query.
4. A query that contains the GROUP BY clause, one of the aggregatefunctions, the WHERE statement, and the HAVING operator.
5. Two additional complex queries designed by you that aredifferent from the above. A complex query is based on two or moretables and includes either several conditions or a subquery (orboth).

Cafe Barista Sabeel Ahmed Café ERD Cafe ID PK Barista_ID 1,M Order_ID Item ID Cahshier_iID 1,M 1,1 Order 1,1 Cashier Order ID PK 1,1 Cashier ID M,1 1,M Order ID Barista ID 1,M 1,1 Payment Customer PK Customer ID 1,1 Profit Cashier ID FK Cost Tips Type_of_Payment Show transcribed image text Cafe Barista Sabeel Ahmed Café ERD Cafe ID PK Barista_ID 1,M Order_ID Item ID Cahshier_iID 1,M 1,1 Order 1,1 Cashier Order ID PK 1,1 Cashier ID M,1 1,M Order ID Barista ID 1,M 1,1 Payment Customer PK Customer ID 1,1 Profit Cashier ID FK Cost Tips Type_of_Payment

Expert Answer

---

Answer to MYSQL query you to create the table with appropriate attributes and data types together with primary keys, foreign keys,… . . .