Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Practical Approach

Authors: Jeffrey Slater, Brian Zwicker

12th Canadian edition

133133230, 978-0133133233

More Books

Students also viewed these Databases questions