FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLES Table name: TRUCK Primary key: TRUCK_NUM Foreign key: BASE_CODE, TYPE_CODE Database name: Ch03_TransCo TRUCK_NUM BASE_CODE TYPE_CODE TRUCK MILES TRUCK_BUY_DATE TRUCK SERIAL NUM 1001 501 1 32123.5 23-Sep-07 AA-322-12212-W11 1002 502 1 76984.3 05-Feb-06 AC-342-22134-023 1003 501 2 12346.6 11-Nov-06 AC-445-78656-Z99 1004 1 2894.3 1005 503 2 45673.1 06-Jan-07 WQ-112-23144-T34 01-Mar-06 FR-998-32245-W12 1006 501 2 193245.7 1007 502 3 32012.3 15-Jul-03 AD-456-00845-R45 17-Oct-04 AA-341-96573-Z84 1008 502 3 44213.6 1009 503 2 10932.9 07-Aug-05 DR-559-22189-D33 12-Feb-08 DE-887-98456-E94 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE_CODE BASE_CITY BASE_STATE BASE_AREA_CODE BASE_PHONE 501 Murfreesboro TN 615 123-4567 502 Lexington KY 568 234-5678 BASE_MANAGER Andrea D. Gallager 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 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.