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...
-
Refer to the Real Estate data, which report information on the homes sold in the Goodyear, Arizona, area last year. a. At the .02 significance level, is there a difference in the variability of the...
-
Given the following functions F(s), find f(t) F(s) = s(s + 6) / (s + 3) (s2 + 6s + 18) F(s) = (s + 4) (s + 8) / s (s2 + 8s + 32)
-
As a gambling facility, MGM Desert Inn, Inc., regularly holds and executes negotiable instruments. During a period of two months, patron William E. Shack Jr. entered MGM and delivered eight checks to...
-
Jean-Marie Bourjollys restaurant has the following inventory items that it orders on a weekly basis: (a) Which is the most expensive item, using annual dollar volume? (b) Which are C items? (c) What...
-
The security professional needs to be aware of the important security concepts that apply during software development and in the production environment. Which command in data control language...
-
A manufacturing services provider of complex optical and electromechanical components seeks to gain efficiency in its jobshop scheduling decision because the current shopfloor operations suffer from...
-
13. List the networking devices in this lab that operate at OSI layer 1: 14. List the networking devices in this lab that operate at OSI layer 2: 15. List the devices in this lab that operate at OSI...
-
The inlet contraction and test section of a laboratory wind tunnel are shown. The air speed in the test section is U=50 m/s. A total-head tube pointed upstream indicates that the stagnation pressure...
-
34. SEMO Vases produces the following standard cost to make a clay vase: Direct Materials: 2 pounds @ $4.00 per pound Direct Labor 3 hours @ $9.00 per hour FOH applied at 60% of Direct Labor After...
-
On September 1 of the current year, Scots Company experienced a flood that destroyed the company's entire inventory. Because the company had not completed its month end reporting for August, it must...
-
6) Johnnycake Restaurant uses a periodic inventory system and the gross method of accounting for purchases. Prepare general journal entries to record the following transactions for Johnnycake: Aug....
-
What are the quantifiable dimensions of social existence, distinct from individual experience, that are amenable to measurement?
-
Southeast Health Systems stock paid a dividend of $ 3. 25 today. Analysts predict that Southeast's dividends will grow at a rate of 2% annually in the future. Southeast's stock has a beta of 1. 3 and...
-
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) An amount of substance equal to 2 kmols of an ideal gas at temperature \(T\) and pressure \(p\) is contained in a compartment. In an adjacent compartment is an amount of substance equal to \(1...
-
The exhaust gas from a two-stroke cycle compression-ignition engine is exhausted at an elevated pressure into a large chamber. The gas from the chamber is subsequently expanded in a turbine. If the...
-
The following data refer to an analysis of a dual combustion cycle with a gas having specific heats varying linearly with temperature: The pressure and temperature of the gas at the end of...
Study smarter with the SolutionInn App