Question: Oracle, SQL, Programming I already asked this question, but nobody answered it. Question: A) Create two new tables called Mechanic and MechanicBuses. (1 bookmark Oracle

Oracle, SQL, Programming

I already asked this question, but nobody answered it.

Oracle, SQL, Programming I already asked this question, but nobody answered it.

Question: A) Create two new tables called Mechanic and MechanicBuses. (1 bookmark

Question: A) Create two new tables called Mechanic and MechanicBuses. (1 bookmark Oracle SQL a) Create two new tables called Mechanic and MechanicBuses. These tables represent the fact thata there are mechanics working in the depots who are responsible for buses. A mechanic is based ata 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 salar depot number type size VC VC 20 6,2 VC5 mNo VC 5 VC MechanicBuses mechanic employee number Bus registration number regNo 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!