MYSQL WORK. THFOR YOUR HELP. Write SQL statements that create the tables accordi

Question

MYSQL WORK. THFOR YOUR HELP.

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.

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

Write SQL statements that show the average rating of each cafe/restaurant place, sort them by their ID.

Write SQL statements that show the highest and lowest ratingcafe/dining place.

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).

Write SQL statements that show the total number of reviews acafe/dining place has.

Write SQL statements that show all the tags that a cafe/diningplace has.

ERD DIAGRAM

Completed ER Diagram Picture PicturelD BusinessID FK Picture User BusinessHasTag BusinessID PK FK UserlD PK Business BusinessID PK BusinessName BusinessDetail BusinessTell TagID PK FK Review ReviewID UserlD ModeratorID FK BusinessID FK ReviewText ReviewRating ReviewStatus Tag sinessURL Street City ZipCode TagID TagText PK UserHasRole UserlD PK FK RolelD PK FK FK tatelD asWifi State HasParking StatelD StateCode StateName Schedule SchedulelD PK BusinessID FK Day FromHour EndHour Role RolelD RoleTitle PK

Explanation / Answer

1) Table Creation Commands:-

Above are the commands which can create tables in the MySql database.

As per the chegg policy I am allowed to answer only one question. kindly understand and post the remaining as new post.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.