Write the sql statement to insert data for the following car

Assignment Help Database Management System

Reference no: EM132103990

Problem 1:

The Acme limo service company needs a simple database to track their cars and drivers.

They also want to track driver assignments. Write the SQL statements to create tables to store driver, car and assignment information.

Assume each driver is assigned only one car. Each car can be assigned to multiple drivers. The tables must capture the following information for each car and driver:

Driver: Name, SSN, DOB

Car: VIN, Make, Model, Color

Be sure to include the appropriate primary and foreign keys

Problem 2:

Write the SQL statement to insert data for the following cars, drivers and their assignments:

John Doe	123121234	11-11-2000
Jill Doe	321434532	07-03-1999
Jane Smith	432121234	03-08-1983
Mike Smith	321125634	04-06-1995

VIN1234	Porsche	Cayene	Black
VIN2134	Porsche	Panamera	Red
VIN2134	Hummer	H2	Black
VIN5432	Mercedes Benz	S500	Red
VIN6543	Mercedes Benz	E350	Blue
VIN7654	Audi	A8	White

Driver assignments

John is assigned the Hummer

Jill is assigned the Audi

Mike is assigned the Panamera

Problem 3:

Write the SQL statements (update statements) to change the driver assignments as follows

John is assigned to drive the Audi

Jill is assigned to drive the Hummer

Reference no: EM132103990

Questions Cloud

The difference between a conventional torus and folded torus : Explain the graph theoretic relationship among k-ary n-cube network and rings meshes tori binary n-cubes and omega networks.

What is the thickness is a single : What is the thickness is a single one dollar bill units must be in micrometers (µm)?

How much is performance improved : How much is performance improved when the conditional move instruction is used?

Meters per second convert : If a sprinter running at a speed of 10 meters per second could convert his/her kinetic energy into upward

Write the sql statement to insert data for the following car : Write the SQL statements (update statements) to change the driver assignments as follows

What diameter will you choose for your wire : You're given of copper and asked to make a wire, using all the metal, with a resistance of. Copper has a density of 8900 kg/m3.

How do you find the angle of incidence : How do you find the angle of incidence in this problem, I am having trouble solving this.

Implementation of two algorithms-merge sort and binary : Implementation of any two algorithms from the following algorithms: Merge Sort, Quicksort, Binary Search, Euclidean Algorithm(for Önding gcd).

Determine its minimum point using the matlab routine : Determine its minimum point using the Matlab routine ‘fminsearch'.

User Account

All Pages