Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please fast Consider the following set of requirements to maintain a Smart Buy store database: - A customer can own many cars. - Some customers
Please fast
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. [4 Marks] 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. [2 Marks]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