Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Probabilistic Databases

Authors: Dan Suciu, Dan Olteanu, Christopher Re, Christoph Koch

1st Edition

3031007514, 978-3031007514

More Books

Students also viewed these Databases questions

Question

Why is good supplier relations important?

Answered: 1 week ago