Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Database Design with Entity-Relationship Model E-R Diagram Show all entity sets, relationship sets, and attributes (including primary keys for entity sets) in the diagram. Then
Database Design with Entity-Relationship Model E-R Diagram
Show all entity sets, relationship sets, and attributes (including primary keys for entity sets) in the diagram. Then translate these diagrams into relational database schema.
Hot Restaurant Automation: Design a database containing the following information for the HOT RESTAURANT, whose all meals are hot:
- Every waiter had a name, telephone, and a salary. ( Also, waiters have to like hot spicy.)
- Tables have numbers and capacities, namely the number of chairs (There are hot peppers on the tables)
- There is no table unattended by waiters. A waiter can look at more than one table. The restaurant has at least one table and at least one waiter. There is no waiter who does not look at the table.
- Meals have name, type ('main course', 'dessert', ...), serving price, and serving calories.
- Food orders have date, time, table, waiter and ordered dishes. (Example: 2 portions of dried beans, 2 portions of rice, 1 bowl of yogurt, 1 bottle of water, etc.). The meal order includes at least one meal. A meal can be filled in many orders. Each order is charged 10 $ for bread even though it is not eaten, and 5 $ for water if it is not drunk. It is forbidden to sit at the table without ordering a meal. Hot pepper is rubbed into the mouths of those who do not order.
- An invoice is created for each order. Invoices have numbers and dates.
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