This assignment will allow you to apply the knowledge you have learned about Entity Relationship Diagrams...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This assignment will allow you to apply the knowledge you have learned about Entity Relationship Diagrams in this class. Before attempting this assignment, make sure you have read and understood how to draw a basic Entity-Relationship diagram on pp 179- 186 in your textbook, and also read the content I generated which is included in this week's submodule, CP: Some NOTES On Entity. Relationship Diagrams. Please draw an Entity Relationship Diagrams as described in the problem below, and submit the diagram in electronic form in CANVAS in a standard image form (jpg, gif, etc.) or pdf. You may create the diagram by hand or using a standard drawing software (e.g. MS Word, Powerpoint). NOTE: Please make sure to follow the drawing methods described in the book and in this week's module. If you use another drawing method, you will not receive credit. If you have any questions, please let me know and I will be most happy to assist you. I hope you enjoy this activity! PROBLEM: You are asked to design a data model for Burma Grotto, a new restaurant featuring Burmese cuisine, including delicious versions of Tea Leaf Salad, Samusas, and other traditional Burmese dishes. Burma Grotto has a "rewards card" program where customers can get 10% off every 5th time they eat at the restaurant. To signup for the rewards program, customers must fill out an online application that collects key information about the customer. You want to keep track of four entities: (1) the menu items that the restaurant sells, (2) customers who place the orders, (3) the orders that are placed, and (4) the servers who take the orders and serve the food. Draw an ERD diagram and use the following information to help guide your drawing: The database should keep track of all menu items that the restaurant offers for sale The database should keep track of all customers who have joined the rewards card program The database should keep track of all restaurant orders the database should keep track of all servers employed by the restaurant Each order may have at most one rewards card program customer associated with it Each order must have one server associated with it On slow days servers may serve no customers, and on busy days servers may serve many customers An order must consist of at least one menu item, and may consist of multiple menu item Popular menu items can be ordered a lot, and unpopular menu items may not be ordered at all Each entity must have a unique identifier within its table. This is the Entity's/table's Primary Key. Each entity needs to keep track of specific attributes. The attributes are listed below, but you must determine which entity they belong to: Popular menu items can be ordered a lot, and unpopular menu items may not be ordered at all Each entity must have a unique identifier within its table. This is the Entity's/table's Primary Key. Each entity needs to keep track of specific attributes. The attributes are listed below, but you must determine which entity they belong to: o You want to keep track of the cost of the menu item to the restaurant, and the price that the restaurant sells that menu item to the customer o You want to be able to contact customers via phone and email address o You want to be able to send a digital birthday card to your customers on their birthday. o You want to keep track of the number of visits that a rewards program customer has visited the restaurant so that you can give them the appropriate discount. o You want to keep track of the date that each order occurred, as well as the subtotal, tax, and total dollar amount of the order Your drawing should include the following: 1. The entities you wish to model 2. The required/important attributes for each entity (refer to the instructions above for guidance on what is required/important) 3. The relationships between the entities 4. The correct MAX and MIN Cardinalities for each relationship (remember for each relationship, or line, there are MAX/MIN cardinalities on each side of the relationship) 5. One-to-Many and Many-to-Many relationships, graphically represented in ERDs as a line between entities, can also be represented using Primary and Foreign Keys, i.e. listing a Primary Key from one table and including it as an attribute in a table that you wish to connect to. Choose a One-to-Many relationship in your diagram (a line that connects two entities), and represent that relationship, using a Primary and Foreign Key to do so. Clearly label the "1:N" relationship you are doing this for. Do NOT attempt this for any Many-to-Many relationships you may have in your diagram. Please let me know if you have any questions or need any assistance. Happy Drawing! This assignment will allow you to apply the knowledge you have learned about Entity Relationship Diagrams in this class. Before attempting this assignment, make sure you have read and understood how to draw a basic Entity-Relationship diagram on pp 179- 186 in your textbook, and also read the content I generated which is included in this week's submodule, CP: Some NOTES On Entity. Relationship Diagrams. Please draw an Entity Relationship Diagrams as described in the problem below, and submit the diagram in electronic form in CANVAS in a standard image form (jpg, gif, etc.) or pdf. You may create the diagram by hand or using a standard drawing software (e.g. MS Word, Powerpoint). NOTE: Please make sure to follow the drawing methods described in the book and in this week's module. If you use another drawing method, you will not receive credit. If you have any questions, please let me know and I will be most happy to assist you. I hope you enjoy this activity! PROBLEM: You are asked to design a data model for Burma Grotto, a new restaurant featuring Burmese cuisine, including delicious versions of Tea Leaf Salad, Samusas, and other traditional Burmese dishes. Burma Grotto has a "rewards card" program where customers can get 10% off every 5th time they eat at the restaurant. To signup for the rewards program, customers must fill out an online application that collects key information about the customer. You want to keep track of four entities: (1) the menu items that the restaurant sells, (2) customers who place the orders, (3) the orders that are placed, and (4) the servers who take the orders and serve the food. Draw an ERD diagram and use the following information to help guide your drawing: The database should keep track of all menu items that the restaurant offers for sale The database should keep track of all customers who have joined the rewards card program The database should keep track of all restaurant orders the database should keep track of all servers employed by the restaurant Each order may have at most one rewards card program customer associated with it Each order must have one server associated with it On slow days servers may serve no customers, and on busy days servers may serve many customers An order must consist of at least one menu item, and may consist of multiple menu item Popular menu items can be ordered a lot, and unpopular menu items may not be ordered at all Each entity must have a unique identifier within its table. This is the Entity's/table's Primary Key. Each entity needs to keep track of specific attributes. The attributes are listed below, but you must determine which entity they belong to: This assignment will allow you to apply the knowledge you have learned about Entity Relationship Diagrams in this class. Before attempting this assignment, make sure you have read and understood how to draw a basic Entity-Relationship diagram on pp 179- 186 in your textbook, and also read the content I generated which is included in this week's submodule, CP: Some NOTES On Entity. Relationship Diagrams. Please draw an Entity Relationship Diagrams as described in the problem below, and submit the diagram in electronic form in CANVAS in a standard image form (jpg, gif, etc.) or pdf. You may create the diagram by hand or using a standard drawing software (e.g. MS Word, Powerpoint). NOTE: Please make sure to follow the drawing methods described in the book and in this week's module. If you use another drawing method, you will not receive credit. If you have any questions, please let me know and I will be most happy to assist you. I hope you enjoy this activity! PROBLEM: You are asked to design a data model for Burma Grotto, a new restaurant featuring Burmese cuisine, including delicious versions of Tea Leaf Salad, Samusas, and other traditional Burmese dishes. Burma Grotto has a "rewards card" program where customers can get 10% off every 5th time they eat at the restaurant. To signup for the rewards program, customers must fill out an online application that collects key information about the customer. You want to keep track of four entities: (1) the menu items that the restaurant sells, (2) customers who place the orders, (3) the orders that are placed, and (4) the servers who take the orders and serve the food. Draw an ERD diagram and use the following information to help guide your drawing: The database should keep track of all menu items that the restaurant offers for sale The database should keep track of all customers who have joined the rewards card program The database should keep track of all restaurant orders the database should keep track of all servers employed by the restaurant Each order may have at most one rewards card program customer associated with it Each order must have one server associated with it On slow days servers may serve no customers, and on busy days servers may serve many customers An order must consist of at least one menu item, and may consist of multiple menu item Popular menu items can be ordered a lot, and unpopular menu items may not be ordered at all Each entity must have a unique identifier within its table. This is the Entity's/table's Primary Key. Each entity needs to keep track of specific attributes. The attributes are listed below, but you must determine which entity they belong to: Popular menu items can be ordered a lot, and unpopular menu items may not be ordered at all Each entity must have a unique identifier within its table. This is the Entity's/table's Primary Key. Each entity needs to keep track of specific attributes. The attributes are listed below, but you must determine which entity they belong to: o You want to keep track of the cost of the menu item to the restaurant, and the price that the restaurant sells that menu item to the customer o You want to be able to contact customers via phone and email address o You want to be able to send a digital birthday card to your customers on their birthday. o You want to keep track of the number of visits that a rewards program customer has visited the restaurant so that you can give them the appropriate discount. o You want to keep track of the date that each order occurred, as well as the subtotal, tax, and total dollar amount of the order Your drawing should include the following: 1. The entities you wish to model 2. The required/important attributes for each entity (refer to the instructions above for guidance on what is required/important) 3. The relationships between the entities 4. The correct MAX and MIN Cardinalities for each relationship (remember for each relationship, or line, there are MAX/MIN cardinalities on each side of the relationship) 5. One-to-Many and Many-to-Many relationships, graphically represented in ERDs as a line between entities, can also be represented using Primary and Foreign Keys, i.e. listing a Primary Key from one table and including it as an attribute in a table that you wish to connect to. Choose a One-to-Many relationship in your diagram (a line that connects two entities), and represent that relationship, using a Primary and Foreign Key to do so. Clearly label the "1:N" relationship you are doing this for. Do NOT attempt this for any Many-to-Many relationships you may have in your diagram. Please let me know if you have any questions or need any assistance. Happy Drawing! Popular menu items can be ordered a lot, and unpopular menu items may not be ordered at all Each entity must have a unique identifier within its table. This is the Entity's/table's Primary Key. Each entity needs to keep track of specific attributes. The attributes are listed below, but you must determine which entity they belong to: o You want to keep track of the cost of the menu item to the restaurant, and the price that the restaurant sells that menu item to the customer o You want to be able to contact customers via phone and email address o You want to be able to send a digital birthday card to your customers on their birthday. o You want to keep track of the number of visits that a rewards program customer has visited the restaurant so that you can give them the appropriate discount. o You want to keep track of the date that each order occurred, as well as the subtotal, tax, and total dollar amount of the order Your drawing should include the following: 1. The entities you wish to model 2. The required/important attributes for each entity (refer to the instructions above for guidance on what is required/important) 3. The relationships between the entities 4. The correct MAX and MIN Cardinalities for each relationship (remember for each relationship, or line, there are MAX/MIN cardinalities on each side of the relationship) 5. One-to-Many and Many-to-Many relationships, graphically represented in ERDs as a line between entities, can also be represented using Primary and Foreign Keys, i.e. listing a Primary Key from one table and including it as an attribute in a table that you wish to connect to. Choose a One-to-Many relationship in your diagram (a line that connects two entities), and represent that relationship, using a Primary and Foreign Key to do so. Clearly label the "1:N" relationship you are doing this for. Do NOT attempt this for any Many-to-Many relationships you may have in your diagram. Please let me know if you have any questions or need any assistance. Happy Drawing!
Expert Answer:
Answer rating: 100% (QA)
Based on the problem description we can identify the following entities and their attributes 1 Menu ... View the full answer
Related Book For
Human Resource Management
ISBN: 9781292261645
11th Edition
Authors: Derek Torrington, Laura Hall, Stephen Taylor, Carol Atkinson
Posted Date:
Students also viewed these accounting questions
-
(b) Jake has a current wealth of W. = 2000 and is considering two fair bets X and Y, with an equal chance of winning. Jake can bet any amount of money for either X or Y to win. His utility functions...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Write the C++ code for a function that receives an integer, a double number, and the address of a double variable from the calling statement. The function should multiply the integer by the double...
-
Russia is largely dependent on oil exports to drive its economy forward. Given the sharp fall in global oil prices that occurred in 2014 and 2015, what impact do you think this will have on FDI into...
-
Given k = 0.4 10-3 A>V 2 and I D(on) = 3 mA with V GS(on) = 4 V, determine V T .
-
The plaintiff, Thelma Agnes Smith, lived with the defendant out of wedlock for several years. When the relationship ended, she sued the defendant, seeking to enforce two written agreements with him...
-
(One Temporary Difference, Tracked for 4 Years, One Permanent Difference, Change in Rate) The pretax financial income of Truttman Company differs from its taxable income throughout each of 4 years as...
-
Are Suppliers Partners, Friends, or Enemies? Barbara Nellis and Sandy Watson have just given one another a high five. Close friends and neighbors for several years now, they each recently sent their...
-
The following data are available for Sellco for the fiscal year ended on January 31, 2023: Required: a. Calculate cost of goods sold and ending inventory under the following cost flow assumptions...
-
Company Z is considering two mutually exclusive projects: Project A and Project B. Project A requires an initial investment of $300,000 and is expected to generate cash inflows of $100,000 per year...
-
Three-Mile-Island is a fascinating topic for understanding flooding-related hazards & engineered critical facility structures. Provide an essay description of the flooding hazard for Three Mile...
-
Which course of action will you recommend? You suggest Angel choose the discounted special offer from the one cloud provider. You suggest Angel choose the best-of-breed services from multiple cloud...
-
Annotated Bibliography in Order An annotated bibliography is typically organized alphabetically, but for this project, we're going to combine it with a paper outline. This exercise will assist you in...
-
You are a paid intern at Bearkat Marketing, where you have worked for two years designing promotional materials for local events. You often end up working after hours on weekends to ensure your...
-
What are the key challenges in designing fault-tolerant operating systems capable of providing seamless continuity of service in the face of hardware failures, software errors, and malicious attacks,...
-
find the Thevenin equivalent circuit for the network external to the resistor R in fig 9.138 R. 20 2 A 3 FIG. 9.138 Problem 14.
-
Assessing simultaneous changes in CVP relationships Braun Corporation sells hammocks; variable costs are $75 each, and the hammocks are sold for $125 each. Braun incurs $240,000 of fixed operating...
-
Think of the performance appraisal or performance management system at your place of work or an organisation that you are familiar with. 1. To what extent does it focus on development and to what...
-
Do you think it is possible to identify best practice in payment policy? What elements would you consider should make up any such package?
-
Falcon Day Care was established in 2016 to offer day-care services for adults. Its owners had had long social services careers, but limited experience of running a business. Within 18 months, it was...
-
In the case considered in the question (14), show what the trajectory corresponds to in case the magnitude of acceleration is \(a=2 k \sqrt{1+\frac{t}{T}}\), where \(T=\) cost. Question 14 A particle...
-
The position vector along a trajectory expressed in terms of the scalar distance \(s\) from the origin is given by the relation \(\mathbf{r}=\mathbf{a} s^{2}+\mathbf{b} s+\mathbf{c}\), with the...
-
A particle is constrained to move on a circular guideway of radius \(R=3.00 \mathrm{~m}\), on which it can slide without friction, according to the motion equation law \(s(t)=k t^{3}\), with \(k=2.0...
Study smarter with the SolutionInn App