Question
Consider the following set of requirements to maintain a Smart Buy store database: A customer can own many cars. Some customers do not own cars.
Consider the following set of requirements to maintain a Smart Buy store database: A customer can own many cars. Some customers do not own cars. A car is owned by one and only one customer. A car may generate one or more maintenance records. Each maintenance record is generated by one and only one car. Some cars have not (yet) generated a maintenance procedure. Each maintenance procedure can use many parts. A part may be used in many maintenance records. Each maintenance procedure generates one or more maintenance lines. Each part may appear in many maintenance lines. According to the information above, answer the following questions: a) Indicate the name of entities, attributes, and relations. You must use uppercase to name your entities. b) Draw and then copy and paste the image of the ER-Diagram corresponding to the above case study. Clearly indicate the names for entities, attributes, and relations. Underline all primary keys and mention FK next to all foreign key attributes. [4 Marks] Note: Kindly Use Draw.io tool to draw ER Diagram. c) Clearly indicate participation and cardinalities between entities
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