Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Databases questions

Question

Why did accountants develop the expression soft number?

Answered: 1 week ago

Question

=+b. Repeat part (a) for position players.

Answered: 1 week ago