Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Students also viewed these Databases questions