Welcome to my Term Project Home Page!
List of Tables from Database
Mechanic
| mechanicID |
fName |
lName |
Experience |
| 1 |
Jimmy |
Simpson |
6 |
| 2 |
Kathy |
Nelson |
1 |
| 3 |
Jacob |
Johnson |
3 |
Parts
| partID |
name |
description |
cost |
| 1 |
Wrench |
Loosens Bolts |
4.59 |
| 2 |
Hammer |
Drives in Nails |
10.99 |
| 3 |
Oil |
Lubricates Engine |
24.99 |
RepairJob
| jobID |
vehicleID |
mechanicID |
laborHours |
jobComplete |
| 1 |
1 |
2 |
5 |
1 |
| 2 |
2 |
1 |
2 |
0 |
| 3 |
3 |
1 |
10 |
1 |
| 4 |
4 |
3 |
16 |
1 |
Repairparts
| repairPartsID |
partID |
jobID |
quantityUsed |
| 1 |
1 |
1 |
2 |
| 2 |
2 |
2 |
1 |
| 3 |
3 |
1 |
3 |
Vehicle
| vehicleID |
name |
color |
year |
| 1 |
S60 |
Black |
2024 |
| 2 |
Polestar |
Silver |
2016 |
| 3 |
XC90 |
White |
2008 |