Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Operations Management A Supply Chain Process Approach

Authors: Joel D. Wisner

1st edition

978-1506354187, 1506354181, 1483383067, 978-1483383064

More Books

Students also viewed these Accounting questions

Question

How can flowcharts be used in process reengineering?

Answered: 1 week ago