Question: 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

1 Expert Approved Answer

Step: 1 Unlock

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

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

A study was designed to evaluate treatments for hypertension. The researchers were concerned that whether the patient smoked might impact the effectiveness of the treatments, so they also recorded...

. A vertical pole that is 2 meters tall casts a shadow that is 1.5 meters long. Nearby, at the same time, another vertical pole casts a shadow that is 6.5 meters long. How tall is this pole? a. Make...

(Transactions, Financial StatementsService Company) Listed below are the transactions of Isao Aoki, D.D.S., for the month of September. Sept. 1 Isao Aoki begins practice as a dentist and invests...

Listed below are the transactions of Yasunari Kawabata, D.D.S., for the month of September. Sept. 1 Kawabata begins practice as a dentist and invests $20,000 cash. 2 Purchases dental equipment on...

A manufacturing company employs 14 project managers, 48 supervisors, and 377 laborers. In an effort to keep informed about any possible sources of employee discontent, management wants to conduct job...

Renegade Clothing is struggling to meet analysts forecasts. Its early December 2015, and the year-end projections are in. Listed below are the projections for the year ended 2015 and the comparable...

Based on the tons handled in a year, the ports listed below are the 25 busiest ports in the United States (The 2013 World Almanac). a. What is the largest number of tons handled? What is the smallest...

Listed below are the lengths of time (in years) it took for a random sample of college students to earn bachelors degrees (based on data from the National Center for Education Statistics). Based on...

Listed below are the lead concentrations (in mg/g) measured in different Ayurveda medicines. Ayurveda is a traditional medical system commonly used in India. The lead concentrations listed here are...

Contribution MarginandContribution Margin Ratio For a recent year, McDonald's company-owned restaurants had the following sales and expenses (in millions): Assume that thevariable costsconsist of...

According to the activity network below. Which one is a critical activity? START END Activ

(1 point) Find the derivative of f(x) = 6x+2x using the definition of the derivative. State the domain of f and the domain of f'. Derivative is Domain of f is Domain of f' is (Enter the domains using...

1. Two insulated tanks are connected through an insulated pipe and valve assembly. One tank holds 2 moles of nitrogen at 3 bar and 25C. The other tank has a 3 moles of hydrogen at 0.5 bar, 70C. The...

How travel providers such as airlines, hotels, and car rental agencies can use special pricing to fill unused capacity, and earn revenue at the same time?

The part shown is loaded at point C with 290 N in the positive x direction and at point E with 190 N in the positive y direction. The diameter of the bar ABD is 10 mm. Evaluate the likelihood of...

Pierce & Company provides the following information concerning the work in process at its plant: Beginning inventory was partially complete (materials are 100 percent complete; conversion costs are...

Draw and label the E and Z isomers for each of the following compounds: 1. CH3CH2CH==CHCH3 2. 3. 4. CH,CH2C CHCH2CH Cl CH3CH2CH2CH2 CH CH2CCCH2CI CHCH3 CH3 HOCH CH CCC CH O-CH C(CH

How can flowcharts be used in process reengineering?

Describe the activities undertaken at the die shop, when they implemented lean.

What are the job scheduling activities and objectives for assembly lines?

2.6. Give an example of a variable that is (a) categorical, (b) quantitative, (c) ordinal scale, (d) nominal scale, (e) discrete, (f) continuous, (g) quantitative and discrete.

1.17. In a recent survey by Eurobarometer ofEuropeans about energy issues and global warming,1 one question asked, "Would you be willing to pay more for energy produced from renewable sources than...

2.3. Which scale of measurement (nominal, ordinal, or interval) is most appropriate for (a) Attitude toward legalization of marijuana (favor, neutral, oppose) (b) Gender (male, female) (c) Number of...