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. 13. 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. identifyr a superke;r and a secondary key. 22. Create the ERD for this database. 23. Create the relational diagram for this database. FIGURE P3.17 THE CH03_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-VV11 1002 502 76984.3 AC-342-22134-Q23 1003 501 12346.6 AC-445-78656-299 1004 2894.3 WQ-112-23144-T34 1005 503 45673.1 FR-998-32245-V12 GNN- 1006 501 193245.7 AD-456-00845-R45 1007 502 32012.3 AA-341-96573-784 1008 502 31 44213.8 DR-559-22189-D33 1009 503 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 Dalton 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