Q3) Consider you have a database with the following tables: Truck_num Туре сode Truck_miles Truck_serial_num АА-332-W11 АС-342-Q23 Base_code 1001 501 1 32113.89 1002 502 1 76984.3 1003 501 12345.6...

Q3) Consider you have a database with the following tables:<br>Truck_num<br>Туре сode<br>Truck_miles<br>Truck_serial_num<br>АА-332-W11<br>АС-342-Q23<br>Base_code<br>1001<br>501<br>1<br>32113.89<br>1002<br>502<br>1<br>76984.3<br>1003<br>501<br>12345.6<br>АС-445-Z99<br>WQ-112-T34<br>FR-998-W12<br>1004<br>1<br>2894.3<br>1005<br>503<br>2<br>45673.1<br>Truck table<br>Base_code Base_city<br>Base_phone<br>Base_manger<br>Andrea.d<br>Base_state<br>Base_area_ code<br>501<br>Dalton<br>GA<br>615<br>123-4567<br>Lexington KY<br>Саре.С<br>Murfree<br>502<br>George.h<br>Maria.j.<br>Peter.f<br>566<br>234-5678<br>503<br>МО<br>456<br>345-6789<br>504<br>TN<br>901<br>456-7890<br>Base table<br>Туре сode<br>1<br>Type_description<br>Single box, double-axle<br>Single box, single-axle<br>Tandom trailer, single-axle<br>2<br>Type table<br>Answer the following:<br>1- write the schema that descibes each relation.<br>2- For each table, identify the primary key and the foreign key(s). If a table does not<br>have a foreign key, write None.<br>3- Design the schema diagram for the database.<br>

Extracted text: Q3) Consider you have a database with the following tables: Truck_num Туре сode Truck_miles Truck_serial_num АА-332-W11 АС-342-Q23 Base_code 1001 501 1 32113.89 1002 502 1 76984.3 1003 501 12345.6 АС-445-Z99 WQ-112-T34 FR-998-W12 1004 1 2894.3 1005 503 2 45673.1 Truck table Base_code Base_city Base_phone Base_manger Andrea.d Base_state Base_area_ code 501 Dalton GA 615 123-4567 Lexington KY Саре.С Murfree 502 George.h Maria.j. Peter.f 566 234-5678 503 МО 456 345-6789 504 TN 901 456-7890 Base table Туре сode 1 Type_description Single box, double-axle Single box, single-axle Tandom trailer, single-axle 2 Type table Answer the following: 1- write the schema that descibes each relation. 2- For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 3- Design the schema diagram for the database.

Jun 04, 2022

SOLUTION.PDF

Q3) Consider you have a database with the following tables: Truck_num Туре сode Truck_miles Truck_serial_num АА-332-W11 АС-342-Q23 Base_code 1001 501 1 32113.89 1002 502 1 76984.3 1003 501 12345.6...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment