Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(1) This is an individual assignment. (2) Your final solution should be ONE Microsoft PowerPoint 2016 file (.pptx file) that is submitted via Blackboard.

image text in transcribed

(1) This is an individual assignment. (2) Your final solution should be ONE Microsoft PowerPoint 2016 file (.pptx file) that is submitted via Blackboard. No other file types are accepted. (3) Pay attention to details. Make sure you read the instruction word by word carefully. Otherwise, you might lose points for failing to fulfill any of the clearly specified requirements. (4) You may want to submit your solution at least 30 minutes before the deadline. Make sure you click "Submit" rather than "Save Draft" to actually submit. You are required to double- check your submission by downloading it and opening it to see if it is your final version. You will be responsible for any technical difficulty or mistake on your side that results in submitting the wrong work or your work not being submitted or being accepted as late. ERD - Mr. Crytzer's Pretzel Supply Company is preparing to break out of the Philadelphia market and go national. They have centralized the orders database so that orders may be centrally tracked. The system tracks customers. Customers have a name, address, and customer rewards level. The system also tracks pretzels. Pretzels have a time stamp, size (S/M/L), and up to three toppings: mustard, cheese, or sour cream (which is surprisingly good). Customers make orders in the system. Each order can have many pretzels, but a pretzel will be on only one order. Each customer can make many orders, but each order will be associated with only one customer. Finally, in order to ensure quality control, the system tracks dough suppliers. Supplier information includes: supplier name, supplier address, dough type, and a variable called tired (which indicates that the supplier is tired of being locked inside because of the pandemic... stupid pandemic). A supplier can supply many pretzels, but a pretzel can only be supplied by one supplier. A customer must make at least one order. A pretzel must be on at least one order. And a supplier must supply at least on pretzel. 1. Create the entities and properly name them 2. Indicate the attributes each entity has 3. Create the primary keys and label them as such 4. Indicate the relationships between the attributes and label the cardinality properly. 5. Migrate and label all foreign keys

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Foundations of Financial Management

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen

15th edition

77861612, 1259194078, 978-0077861612, 978-1259194078

Students also viewed these Accounting questions

Question

=+ Identify the ethical dilemma in this scenario.

Answered: 1 week ago