Arnold's Corner Store ERD Modeling Case (10 points) Arnold has a corner grocery store. His store...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Arnold's Corner Store ERD Modeling Case (10 points) Arnold has a corner grocery store. His store is a great place for the local neighbors to shop for their favorite foods and basic essentials. He carries produce, pre-packaged food, and fresh deli and bakery items. He also carries important paper goods and cleaning supplies such as napkins, dish soap, and paper towels. As a small store, Arnold likes to get to know his customers. He records the customer's name, email address, and date they first visited the store. On the anniversary of their first visit, customers receive a coupon for a free bakery item. He has a point of sale (POS) system that captures check out transactions for every purchase made. After items are checked out and the customer has paid, the POS will print a receipt for the sale that lists all items purchased. A different receipt is printed for each purchase made, even if the customer returns later in the day to make another purchase. The receipt should print a thank you note using the customer's first name at the bottom. ERD Modeling and Submission Instructions Create an ERD using LucidChart to show the entities/tables, fields, field types, keys, and relationships. Use Crow's Foot notation. Indicate cardinality, optionality, and strong/weak relationships in the model. Entity Name PK Primary Key Attribute Name FK Related Key Type Type Type When complete, upload a .pdf (scaled to a single page) to the D2L Assignment Dropbox folder. (A.pdf can be created by expanding the File menu and choosing Export, then pdf.) Grading Criteria: 2 pts - Entities align with case description 2 pts - Attributes align with case description 4 pts - Relationship use Crow's Foot notation and show cardinality, optionality, and relationship strength. Must be in 3NF. 2 pts - Key values are well chosen and properly identified. Arnold's Corner Store ERD Modeling Case (10 points) Arnold has a corner grocery store. His store is a great place for the local neighbors to shop for their favorite foods and basic essentials. He carries produce, pre-packaged food, and fresh deli and bakery items. He also carries important paper goods and cleaning supplies such as napkins, dish soap, and paper towels. As a small store, Arnold likes to get to know his customers. He records the customer's name, email address, and date they first visited the store. On the anniversary of their first visit, customers receive a coupon for a free bakery item. He has a point of sale (POS) system that captures check out transactions for every purchase made. After items are checked out and the customer has paid, the POS will print a receipt for the sale that lists all items purchased. A different receipt is printed for each purchase made, even if the customer returns later in the day to make another purchase. The receipt should print a thank you note using the customer's first name at the bottom. ERD Modeling and Submission Instructions Create an ERD using LucidChart to show the entities/tables, fields, field types, keys, and relationships. Use Crow's Foot notation. Indicate cardinality, optionality, and strong/weak relationships in the model. Entity Name PK Primary Key Attribute Name FK Related Key Type Type Type When complete, upload a .pdf (scaled to a single page) to the D2L Assignment Dropbox folder. (A.pdf can be created by expanding the File menu and choosing Export, then pdf.) Grading Criteria: 2 pts - Entities align with case description 2 pts - Attributes align with case description 4 pts - Relationship use Crow's Foot notation and show cardinality, optionality, and relationship strength. Must be in 3NF. 2 pts - Key values are well chosen and properly identified.
Expert Answer:
Related Book For
Auditing Assurance Services and Ethics in Australia an Integrated Approach
ISBN: 978-1442539365
9th edition
Authors: Alvin A Arens, Peter J. Best, Greg Shailer, Brenton Fiedler
Posted Date:
Students also viewed these programming questions
-
A grocery store purchases fresh fish every day from its supplier. It has ordered 100 pounds of fish each day, but the weight actually received varies from day to day with an average range of 6...
-
Great Foods Grocery reported the following comparative income statement for the years ended June 30, 2012 and 2011: During 2012, Great Foods discovered that ending 2011 inventory was overstated by...
-
Favorite Foods Corp. sold its food to stores and distributors. It established a quantity discount scale that was publicly published and made available to all buyers. The top of the scale gave the...
-
Debate on Causes of Unemployment Two economists are debating the cause of a high unemployment rate. One economist argues that there is not enough government spending. The other says high unemployment...
-
MiniScribe Case (based on "Cooking the Books," The Wall Street Journal, September 11, 1989; and "MiniScribe's Investigators Determine That 'Massive Fraud Was Perpetrated," The Wall Street Journal,...
-
Cylinders A and B have equal heights. Cylinder A is filled with helium gas at 1.0 atm pressure and 0C. The diameter of cylinder B is half that of cylinder A, and cylinder B is filled with glycerin....
-
The balance sheet of Creative Communications, Inc., reported the following: Preferred dividends are in arrears for three years including the current year. On the balance sheet date, the market value...
-
1. In the case, Judge Kaplan dismissed Parmalats lawsuit against Deloitte stating that Parmalat did not show that poor auditing of Parmalat USA was equivalent to fraud. Comment on the judges decision...
-
Budgeting and Variances Assume Bene Petit is in its third year of operations and is on track to report a small profit during Year 3 after barely breaking even in Year 2. For this assignment, you will...
-
What is the subject matter of each of the following TAM? a. TAM 200703019 b. TAM 201734007 c. TAM 9853001
-
Q#1(a) Discuss briefly the chief experimental systematies which led to the shell model description for nuclear states. Give several examples of nuclei which correspond to closed shells and indicate...
-
On July 9, Mifflin Company receives an $8,700, 120-day, 6% note from customer Payton Summers as payment on account. Compute the amount due at maturity for the note and interest. (Use 360 days a year.)
-
13-40. Cycle-1 is a fast-growing start-up firm that manufactures bicycles. The following income statement is available for October: Sales revenue (300 units @ $600 per unit) Less Manufacturing costs...
-
AF Entity, as well as all of AF Entity's suppliers, are registered as VAT vendors in accordance with the VAT-Act. AF Entity uses the periodic inventory system. The following balances, amongst others,...
-
If you invest $750 every four month at 16% compounded quarterly, how much would you accumulate at the end of 5 years?
-
Kendall, who earned $124,200 during 2021, is paid on a monthly basis, is married, (spouse does not work) and claims two dependents who are under the age of 17. Use the Percentage Method Tables for...
-
Consider the following simplified financial statements for Turnbull Inc. - assuming no income taxes. The company has predicted a sales increase of 15 percent. Assume that Turnbull Inc. pays out half...
-
Does log 81 (2401) = log 3 (7)? Verify the claim algebraically.
-
Hardware Manufacturing Company Pty Ltd, a small private company, has operated since 20X2 but hasn't had its financial statements audited. The company now plans to issue additional shares to be sold...
-
Explain why it is unacceptable for an auditor to assume that an independent computer service centre is providing reliable accounting information to a client. What can the auditor do to test the...
-
Audit procedures differ from, but are related to, types of evidence. The following questions relate to types of evidence and audit procedures. a. What is an audit procedure? b. Why should audit...
-
A company is scheduling temporary differences for the purpose of computing deferred taxes. The company compared tax basis assets and liabilities with book basis assets and liabilities and accumulated...
-
A company is scheduling its temporary differences for the purpose of computing deferred taxes. The company compared tax basis assets and liabilities with book basis assets and liabilities and...
-
Derive the look-up table for the tangent function in increments of 1 degree. Be sure to take advantage of symmetry.
Study smarter with the SolutionInn App