MYSQL WORK. Provide screenshots of the answers when you write the statements plus the resulting data
Apply the ERD diagram to create tables and statements using MySQL and answer the questions. Use your own made up data
Provide screenshots of the answers when you write the statements
1.Write SQL statements that create the tables according to the given ER diagram. Your code should include constraints that enforce primary key, foreign key,
and deletion rule constraints.
2.Write SQL statements that populate the tables according to the data mentioned in the description or your own made up data. (Don’t populate too much
data, just enough so you can do the questions below). Use your own made up data
3.Write SQL statements that show the average rating of each cafe/restaurant place, sort them by their ID.
4.Write SQL statements that show the highest and lowest rating cafe/dining place.
5.Write SQL statements that show all the cafe/dining places that are open on a specific time (Your choice depends on the data you’ve populated).
5.Write SQL statements that show the total number of reviews a cafe/dining place has.
7.Write SQL statements that show all the tags that a cafe/dining place has.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
