Add a Job to the Repair Shop Database

Repair Shop | Display Jobs

Step 1) Select a Customer's Information:

Select a Customer:




The sql for the customer selection
SELECT * from Car WHERE customer_ID=''

Step 2) Add the Job Information:

Car ID:
Mechanic ID:
Estimate ID:
Date Began:

Is The Job In Progress?
Date Completed:




The sql for the insert
INSERT INTO Job (car_ID, mechanic_ID, estimate_ID, date_began, date_completed) VALUES ('', '', '', '', '')