Description
Please if you are not familiar with this assignment let others take it
See the attached file and answer those 4 questions......................................................................................................................................................................................................
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
The files below contain complete work of your assignment. Kindly check it and let me know if you need any clarification. Thank you.
/*QUESTION 1*/
DELIMITER $$
CREATE PROCEDURE uspListRepairs(IN First_Name VARCHAR(30), IN Last_Name
VARCHAR(30), IN FromDateTime TIMESTAMP, IN TomDateTime TIMESTAMP)
BEGIN
SELECT * FROM Car ca, `Car Repair` cr, CUSTOMER cu, `Repair` re,
Technician te
WHERE Cu.First_Name=First_Name AND Cu.Last_Name=Last_Name AND
cr.`DateTime` BETWEEN FromDateTime AND TomDateTime
AND cu.Customer_ID=ca.Customer_ID AND ca.VIN=cr.VIN AND
cr.Repair_Code=Re.Repair_Code AND cr.Employee_ID=te.Employee_ID
ORDER BY ca.VIN ASC;
END$$
CALL uspListRepairs('', '', '2008-01-01 00:00:01','2018-01-01 00:00:01');
/*QUESTION 2*/
DELIMITER $$
CREATE PROCEDURE uspCalculateTotalRepairCostByCar(IN First_Name VARCHAR(30), IN
Last_Name VARCHAR(30), IN VIN INT, OUT totalRepairCost DOUBLE)
BEGIN
SELECT SUM(cr.Total_Cost_Parts+cr.Total_Cost_Labor) INTO @totalRepairCost
FROM Car ca, `Car Repair` cr, CUSTOMER cu
WHERE Cu.First_Name=First_Name AND Cu.Last_Name=Last_Name AND ca.VIN=VIN
AND cu.Customer_ID=ca.Customer_ID AND ca.VIN=cr.VIN ;
Select @totalRepairCost into totalRepairCost;
END$$
/*QUESTION 3*/
DELIMITER $$
CREATE PROCEDURE uspAddCarRepair(IN inRepair_Code ...
Review
Review
