Question: The high-level conceptual data modelling should be done for the following scenario. That is, you need to provide High-level (using ER diagram) data modelling with

 The high-level conceptual data modelling should be done for the following scenario. That is, you need to provide High-level (using ER diagram) data modelling with all attributes and keys. Although we provide detailed information for the scenario, there might be cases that you need to assume certain details and/or constraints. Discuss any assumptions you make. Scenario: Design a database to keep track of information for restaurants. Assume that the following requirements were collected: • Each restaurant has a name, city and phone number. • Each restaurant is owned by exactly one owner. We need to keep track of the owner's SSN, name, city, address, and phone number. • Each restaurant serves many different foods. Each food has a name, type of food, country of food, and spice level. • Each customer may like many different foods. Each customer has his/her SSN, name, birth year, and gender.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!