Question
Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality
Based on the narratives, draw the following ERDs. Make sure you add the Primary Keys, Foreign Keys, verbs that represent the relationship, and mark cardinality (both lower and upper bounds) for each diagram. Apply all 4 ERD rules. A new technology store is opening that specializes in smartphones. The owner wants to create her own database to track each smartphone she sells. Currently, she doesnt plan to sell anything other than smartphones. For now, the owner only needs to keep track of each smartphones IMEI number, model, screen size, and price. She only keeps track of the customers first name, last name, and email address. She only keeps track of an orders date. Create the entity-relationship diagram (ERD) that represents smartphones, customers, and orders.
Step by Step Solution
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