FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES Table name: TRUCK Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE...

Transcribed Image Text:

FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES Table name: TRUCK Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE TRUCK NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_SERIAL_NUM 1001 32123.5 AA-322-12212-WW11 1002 1003 1004 76984.3 AC-342-22134-Q23 12346.6 AC-445-78656-Z99 2894.3 WVQ-112-23144-T34 45673.1 FR-998-32245-W12 193245.7 AD-456-00845-R45 32012.3 AA-341-96573-Z84 1005 1006 1007 1008 44213.6 DR-559-22189-D33 10932.9 DE-887-98456-E94 1009 501 502 501 503 501 502 502 503 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE CODE BASE_CITY 1 1 Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE_CODE 2 1 2 2 3 3 2 BASE STATE BASE_AREA_CODE BASE PHONE TN 501 Murfreesboro 123-4567 502 Lexington KY 234-5678 503 Cape Girardeau MO 345-6789 504 Dalton GA 456-7890 TYPE DESCRIPTION 1 Single box, double-axle 2 Single box, single-axle 3 Tandem trailer, single-axle 615 568 456 901 Database name: Ch03_TransCo BASE MANAGER Andrea D. Gallager George H. Delarosa Maria J. Talindo Peter F. McAvee Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 18. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 20. Identify the TRUCK table's candidate key(s). 21. For each table, identify a superkey and a secondary key. 22. Create the ERD for this database. 23. Create the relational diagram for this database. 19. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES Table name: TRUCK Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE TRUCK NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_SERIAL_NUM 1001 32123.5 AA-322-12212-WW11 1002 1003 1004 76984.3 AC-342-22134-Q23 12346.6 AC-445-78656-Z99 2894.3 WVQ-112-23144-T34 45673.1 FR-998-32245-W12 193245.7 AD-456-00845-R45 32012.3 AA-341-96573-Z84 1005 1006 1007 1008 44213.6 DR-559-22189-D33 10932.9 DE-887-98456-E94 1009 501 502 501 503 501 502 502 503 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE CODE BASE_CITY 1 1 Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE_CODE 2 1 2 2 3 3 2 BASE STATE BASE_AREA_CODE BASE PHONE TN 501 Murfreesboro 123-4567 502 Lexington KY 234-5678 503 Cape Girardeau MO 345-6789 504 Dalton GA 456-7890 TYPE DESCRIPTION 1 Single box, double-axle 2 Single box, single-axle 3 Tandem trailer, single-axle 615 568 456 901 Database name: Ch03_TransCo BASE MANAGER Andrea D. Gallager George H. Delarosa Maria J. Talindo Peter F. McAvee Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 18. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 20. Identify the TRUCK table's candidate key(s). 21. For each table, identify a superkey and a secondary key. 22. Create the ERD for this database. 23. Create the relational diagram for this database. 19. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.

Answer rating: 100% (QA)

17 Identify the primary key and foreign keys for each table TRUCK Primary key TRUCKNUM Foreign keys BASECODE references the BASECODE primary key in th... View the full answer