Oracle SQL

a) Create two new tables called Mechanic and MechanicBuses. These tables represent the fact that a there are mechanics working in the depots who are responsible for buses. A mechanic is based at a particular depot. A Mechanic is responsible for a number of buses and a bus will have one or more mechanics working on it. The attributes and types of Mechanic and MechanicBuses are given in the following table:- Table Mechanic attributes mNo mName mSalar dNo description mechanic emplovee number mechanic name mechanic sala depot number type size VC VC 5 20 N (6,2) VC MechanicBuses mechanic employee number Bus registration number mNo VC regNo VC 10 Key - VC - varchar N- number b) Modify your table definition using the Alter command to add an extra column to the Mechanic table called dateEmployed to represent the date that the mechanic started working for the company. Do a select *from Mechanic XX99- your table structure should look like:- MNO MNAME MSALARY DNO DATEEMPLOYED a) Create two new tables called Mechanic and MechanicBuses. These tables represent the fact that a there are mechanics working in the depots who are responsible for buses. A mechanic is based at a particular depot. A Mechanic is responsible for a number of buses and a bus will have one or more mechanics working on it. The attributes and types of Mechanic and MechanicBuses are given in the following table:- Table Mechanic attributes mNo mName mSalar dNo description mechanic emplovee number mechanic name mechanic sala depot number type size VC VC 5 20 N (6,2) VC MechanicBuses mechanic employee number Bus registration number mNo VC regNo VC 10 Key - VC - varchar N- number b) Modify your table definition using the Alter command to add an extra column to the Mechanic table called dateEmployed to represent the date that the mechanic started working for the company. Do a select *from Mechanic XX99- your table structure should look like:- MNO MNAME MSALARY DNO DATEEMPLOYED