Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Naz Sdn. Bhd. involves in a car maintenance program. Listed below are the business rules for the company. (1) (2) (3) (4) (5) (6)
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)
Step by Step Solution
★★★★★
3.43 Rating (159 Votes )
There are 3 Steps involved in it
Step: 1
a Entities 1 Customer Represents individual customers of the company 2 Car Represents v...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