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