Naz Sdn. Bhd. involves in a car maintenance program. Listed below are the business rules for...

Transcribed Image Text:

Naz Sdn. Bhd. involves in a car maintenance program. Listed below are the business rules for the company. (1) (2) (3) (4) (5) (6) A customer can own many cars Some customers do not own cars. (a) (b) (c) A car may generate one or more maintenance records. Each maintenance record is generated by one car. Some cars have not (yet) generated a maintenance procedure. Each maintenance record can generate many maintenance lines. Each maintenance line is generated by only one maintenance record. Each part is in many maintenance lines. Each maintenance line is in a part. Each mechanic can write many maintenance records. Each maintenance record can be written by only one mechanic. All mechanics are employee. Not all employees are mechanics. REQUIRED: Based on the above business rules, draw an Entity Relationship Diagram for Naz Sdn. Bhd. using Crow's Foot model. The diagram should include: Entity Connectivity Cardinalities. (5 Marks) (3 Marks) (6 Marks) Naz Sdn. Bhd. involves in a car maintenance program. Listed below are the business rules for the company. (1) (2) (3) (4) (5) (6) A customer can own many cars Some customers do not own cars. (a) (b) (c) A car may generate one or more maintenance records. Each maintenance record is generated by one car. Some cars have not (yet) generated a maintenance procedure. Each maintenance record can generate many maintenance lines. Each maintenance line is generated by only one maintenance record. Each part is in many maintenance lines. Each maintenance line is in a part. Each mechanic can write many maintenance records. Each maintenance record can be written by only one mechanic. All mechanics are employee. Not all employees are mechanics. REQUIRED: Based on the above business rules, draw an Entity Relationship Diagram for Naz Sdn. Bhd. using Crow's Foot model. The diagram should include: Entity Connectivity Cardinalities. (5 Marks) (3 Marks) (6 Marks)

Answer rating: 100% (QA)

a Entities 1 Customer Represents individual customers of the company 2 Car Represents v... View the full answer