Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

imageimage

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.

Step by Step Solution

3.44 Rating (144 Votes )

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

Auditing Assurance Services and Ethics in Australia an Integrated Approach

Authors: Alvin A Arens, Peter J. Best, Greg Shailer, Brenton Fiedler

9th edition

978-1442539365, 1442539364

More Books

Students also viewed these Programming questions

Question

What is the when-issued market?

Answered: 1 week ago

Question

Does log 81 (2401) = log 3 (7)? Verify the claim algebraically.

Answered: 1 week ago

Question

What are some key differences between leaders and managers?

Answered: 1 week ago