(Database assignment sql, plsql, procedure, Trigger)

1-answer the questions 2,3,4,5,6,7 using the sample tables and ERD

2-create a script that will complete each of the following requirements 2,3,4,5,6,7.

3- some of the requirements are dependent on each other

4-create an object (table, attribute, procedure, sequence) with the EXACT name that is given in question.

ERD of Chemical Tracking System CHEMICAL CARRIED PK Pk Carried Num Chern-Product Chem Name Chem Conce nitration Chem_Unit_Cost FKI Chem Num FK2 Drive Num Carried Outbound Carried Return EMPLOYEE Used Qty Used Charge FK2 Truck Num Drive Date Drive Status Emp IName Emp FName Emp DLNurn JOB TRUCK Job Date PK Truck Num Job City Job State ob Zip Truck VIN Truck Year T ruck Mileage FK Emp Num ob Charge Brief Description of Operations This system is required by the government for the tracking of dangerous chemicals that PEPS buys in large bulk quantities. The chemicals are stored in large feeder drums and a number of pounds of each chemical can be poured into safety containers to be carried to job sites based on what is expected to be needed that day. Only the use of these chemicals is tracked by this system even though the employees in the system perform many other tasks and jobs for PEPS. An EMPLOYEE is assigned to DRIVE a company TRUCK to go perform pool maintenance JOBs on a particular date. Each truck can CARRY one or more CHEMICALs that day. Which chemicals and in what quantities that went out on each truck each day is recorded in the system. The quantity of each chemical on the truck when it returns at the end of the day is also recorded when the truck returns. The system tracks the jobs done by each employee. The employee records which chemicals, if any, were USED at each job and in what quantity. All quantities and unit costs are based on 1 pound units. For example, if the quantity of a chemical used on a particular job shows 2, then 0.2 pounds of that chemical was used. The unit cost of the chemical is for I pound of that chemical