Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Exotic Bites Restaurant is a high-end dining establishment specialising in exotic cuisine worldwide. The restaurant has two main menus, the International Menu and

 

The Exotic Bites Restaurant is a high-end dining establishment specialising in exotic cuisine worldwide. The restaurant has two main menus, the International Menu and the Local Menu. Each menu has courses featuring unique and exotic dishes, including rare meats, seafood, and spices. There is only one Head Chef for each menu, and each course is managed by a sous chef who can manage courses from either of the two menus. From the customer's side, a customer can only order from one menu at a time, and the customer is expected to order all the menu courses to fully experience the diverse flavours and textures of the exotic dishes. Use the information above to attempt the following. Submit only a pdf document. 1. Use the information from above and your knowledge of databases to determine all the Exotic Bites Restaurant database entities. For each of the entities, summarise the information that the entity stores and all the attributes of the entity. 2. Determine the business rules of the database for Exotic Bites Restaurant. 3. Hence, draw an Entity Relationship Diagram of the system database. Write a summary of any assumptions you made in your design (where appropriate). Include any changes or modifications made to the requirements stated above. Justify those changes.

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

Step: 3

blur-text-image

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

Global Marketing management

Authors: Masaaki Kotabe, Kristiaan Helsen

5th edition

470505745, 978-0470505748

More Books

Students also viewed these Programming questions

Question

What are the possible drawbacks of 50-50 joint ventures?

Answered: 1 week ago