Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started