For this question, please refer to the high-level model for a sales company who would like...

 

Transcribed Image Text:

For this question, please refer to the high-level model for a sales company who would like to track staff, customers and what they have ordered from various online catalogue menus. Answer the questions (a, b, c) which are related to the model. Staff StaffID (P) Full Name LevelCode 1..1 Order OrderID (PI) Order Dale Order Time Total Cost Before Tax Total Tax is client representative for Places Customer CustomerID (PI) Full Name Salutation email primary phone number 1..1 1..1 has 0..1 Order Item OrderitemID (PI) Quantity Ordered the price TotalDiscountAmount Subtotal 1.1 Belongs to Menu MenuID (PI) ActiveFromDate Active ToDate Menu Name Menu Description 0..* Ordered In 1..1 Menu Item MenuitemID (PI) Name Description Item Price Questions: (a) 5 marks - in the above model, is it possible to allocate more than one order item per order? If yes, provide an example of how (what data would go where). If no, briefly describe what would need to be changed in the model to enable this to occur. (b) 5 marks- Describe the concept of referential integrity. In your answer, include your own example data for the Menu Item table from the above model to help describe the concept. (c) 10 marks - We now want to be able to track which store (brand) is responsible for which menu items. It is possible to have a menu that has items from different stores. Suggest how this could be added to the model and what the updated part of the model would look like. What needs to link with what? What are the multiplicities and constraints? Why did you choose to represent it that way in the model? For this question, please refer to the high-level model for a sales company who would like to track staff, customers and what they have ordered from various online catalogue menus. Answer the questions (a, b, c) which are related to the model. Staff StaffID (P) Full Name LevelCode 1..1 Order OrderID (PI) Order Dale Order Time Total Cost Before Tax Total Tax is client representative for Places Customer CustomerID (PI) Full Name Salutation email primary phone number 1..1 1..1 has 0..1 Order Item OrderitemID (PI) Quantity Ordered the price TotalDiscountAmount Subtotal 1.1 Belongs to Menu MenuID (PI) ActiveFromDate Active ToDate Menu Name Menu Description 0..* Ordered In 1..1 Menu Item MenuitemID (PI) Name Description Item Price Questions: (a) 5 marks - in the above model, is it possible to allocate more than one order item per order? If yes, provide an example of how (what data would go where). If no, briefly describe what would need to be changed in the model to enable this to occur. (b) 5 marks- Describe the concept of referential integrity. In your answer, include your own example data for the Menu Item table from the above model to help describe the concept. (c) 10 marks - We now want to be able to track which store (brand) is responsible for which menu items. It is possible to have a menu that has items from different stores. Suggest how this could be added to the model and what the updated part of the model would look like. What needs to link with what? What are the multiplicities and constraints? Why did you choose to represent it that way in the model?