Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started