Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 1: Enhanced Entity-Relationship Diagram Create an Enhanced Entity-Relationship Diagram, using crows-foot notation as shown in class, based on the following scenario. Narrative An automobile

Part 1: Enhanced Entity-Relationship Diagram Create an Enhanced Entity-Relationship Diagram, using crows-foot notation as shown in class, based on the following scenario. Narrative An automobile body repair shop needs to keep information about its operations. Customers initially bring their cars to the shop for an estimate of repairs. A mechanic looks at the car and estimates the cost and time required for the entire job. If the customer accepts the estimate, a job number is assigned and the customers name and contact information; the cars license plate number, make, model, and year; and a list of the repairs needed are recorded. The customer then makes an appointment to bring in the car on a specified date. When the car is brought in for repairs, the work begins. The shop keeps track of the charges for parts and labor as they accumulate. Only one mechanic works on the car for the entire job. A job might include several repairs (e.g., replacing the left fender, painting the passenger door). The time actually spent for each repair is recorded and used to calculate the cost of labor, using a fixed hourly rate. Draw a complete E-R diagram for this example. Assume the shop is expanding to perform mechanical repairs as well as body work. Body work can be done by a technician, but all mechanical repairs require a licensed mechanic. Jobs may require one technician to handle the body work (if any) and a licensed mechanic to do the mechanical repairs (if any). Part 2: Translation to Relational Given the EER diagram created in Part 1, convert the diagram to relations in a Word Document. The relations should denote all Primary and Foreign Keys. Use the following format, underlining the primary key fields, dashed underlining the foreign key fields, or a combination of the two (double-underlined is okay for fields that are a foreign key and also part of the primary key):

TableName ( PrimaryKeyField1, PrimaryKeyField2, Field1Name, Field2Name, Field3Name)

Primary Key: PrimaryKeyField1, PrimaryKeyField2

Foreign Keys: PrimaryKeyField2 to ForeignTable1 Field3Name to ForeignTable2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Structured Search For Big Data From Keywords To Key-objects

Authors: Mikhail Gilula

1st Edition

012804652X, 9780128046524

More Books

Students also viewed these Databases questions

Question

What about leadership lessons from particularly good or bad bosses?

Answered: 1 week ago