Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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 DATEEMPLOYEDStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started