Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an ER Diagram for the following scenario We need to keep track of Mechanics. Some of the things we need to track are their

Create an ER Diagram for the following scenario

We need to keep track of Mechanics. Some of the things we need to track are their Names ( First and Last), Employee ID, Hire_date, Drivers License Number and State, and the procedures they can provide (Wheels and Tires, Oil Changes, Brakes, Electrical, and Transmission). They may be able to do multiple procedures. Mechanics are unique by their Employee ID. They can also be uniquely identified by the Driver's License Number and State of Issue. The garage has many different locations( Gladstone, Belton, Independence, etc ). Each location ID, an address composed of (street, city, state, and zip code), as well as how many mechanics work on that department ( derived ). A location must have mechanics assigned to it, but some mechanics wont be assigned to a specific location and will fill in where needed. A mechanic can only be assigned to one location if they have one. Locations are unique by Address, or by ID. Mechanics will clock into a location to begin work each day. Each mechanic have clocked into many locations ( although only one each day ), and each location can have man mechanics that clocked into it. Each location is managed by an Employee that also has an Employee ID, a Name ( First and Last), Address and Phone. A location must have at least 1 manager, but a manager can manage multiple locations. Employees are unique by ID

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_2

Step: 3

blur-text-image_3

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

Time Series Databases New Ways To Store And Access Data

Authors: Ted Dunning, Ellen Friedman

1st Edition

1491914726, 978-1491914724

More Books

Students also viewed these Databases questions