MIS 560 Database Management Systems-Assignment

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. 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. 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. FIGURE P3.17 THE CHO3_TRANSCO DATABASE TABLES Table name: TRUCK Database name: Ch03_TransCo Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE TRUCK NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_SERIAL_NUM 1001 501 32123.5 AA-322-12212-W11 1002 502 76984.3 AC-342-22134-Q23 1003 501 12346.6 AC-445-78656-299 1004 2894.3 W@-112-23144-134 1005 503 UNN- N 45673.1 FR-998-32245-V12 1006 501 193245.7 AD-456-00845-R45 007 502 32012.3 AA-341-96573-284 1008 502 3 44213 8 DR-559-22189-D33 1009 503 2 10932.9 DE 887 98156 894 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE_CODE BASE_CITY BASE_STATE BASE AREA_CODE BASE_PHONE | BASE MANAGER 501 Murfreesboro TN 615 123-4567 Andrea D. Gallager 502 Lexington KY 568 234-5678 George H. Delarosa 503 Cape Girardeau MO 456 345-6789 Maria J. Talindo 504 Datton GA 901 456-7890 Peter F. McAvee Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE_CODE TYPE_DESCRIPTION 1 Single box, double-axle 2 Single box, single-axle 3 Tandem trailer, single-axle