My business: Restaurant CIS110 List at least 10 data tables which would likely b

Question

My business: Restaurant CIS110 List at least 10 data tables which would likely be in your business' master database and identify what you think the primary key field should be in each. Please review the meaning of primary key in the text.

My business: Restaurant CIS110 List at least 10 data tables which would likely be in your business' master database and identify what you think the primary key field should be in each. Please review the meaning of primary key in the text.

My business: Restaurant CIS110 List at least 10 data tables which would likely be in your business' master database and identify what you think the primary key field should be in each. Please review the meaning of primary key in the text.

Explanation / Answer

For the business of Restaurant following data tables are required :

1.Employee : This data table maintains information of all Employees in a restaurant.The primary key for this is Emp_id.

2.Chef :This data table maintains the information of all chef in restaurant.It contains Emp_id as a foreign key.The primary key is Chef_id.

3.Manager :This data table maintains the information of all managers in restaurant.It contains Emp_id as a foreign key.The primary key is Manager_id.

4.Waiter :This data table maintains the information of all waiters in restaurant.It contains Emp_id as a foreign key.The primary key is Waiter_id.

5. Menu :This table maintains the information of all menus serve in the restaurant.It has Menu_id as a primary key.

6.Beverages :This table maintains information of all beverages serve in the restaurant. It has Bev_id as primary key.

7.Customer : This table contains information about customers.The primary key for this table is Customer_id.

8.Table :This table contains information about table in the restaurant it maintains the record of menus serverd on that table.It has Table_id as a primary key.

9.Mapping :This table maintains the mapping of table to waiter and manager .It contains Manager_id and Waiter_id as a foreign key.

10.Order :This table maintains the record of customer and its order with the table id.It has Table_id and Customer_id as a foreign key.Order_id is a primary key.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.