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
Get step-by-step solutions from verified subject matter experts
