Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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?
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