Answered: SQL ER DIAGRAM DRAWING! Draw an…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

SQL ER DIAGRAM DRAWING! Draw an ER diagram based on the simplified description given below (with diagrams.net for example) The restaurant's cash register system supports data transfer between the restaurant hall and the kitchen, collects information about ordered products for invoices, and keeps track of product delivery times. In its database, we want to store information about menu items, table invoices (table-specific invoices), orders and waiters. Each product on the menu has an identifier, name and price, and possibly one or more phrases describing the product (e.g. "lactose-free" or "vegan"). Both the product identifier and the name are unique. When the table party arrives at the restaurant and makes the first order, a table bill is opened on the table, where all the orders of the table are collected. The table bill has a unique identifier, the physical table number of the restaurant hall, the time the bill was opened, the total price and the time of payment. Each table bill is always linked to one waiter who serves the entire table. A waiter can serve several tables and thus join several table bills. Each waiter has an identifier, first name and last name. The waiter's identifier is unique. There may be waiters in the database who have not served any tables yet. One table bill can include one or more orders. A specific order is always included in a specific table bill. Each order has the time of placing the order and a running order number inside its invoice. The order contains a certain amount of one or more items from the menu. When the ordered product is ready, the product is ready, information about its delivery time is added. It is assumed that if the same order includes several items of the same menu item, they will all be delivered at the same time. The same product can naturally be included in several orders. There may be products in the database that have not yet been ordered.

Expert Solution