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