Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with 3.2, 3.3, and 3.4 CIS 3730 Database Management Systems 502 TRUCK_NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_BUY_DATETRUCK_SERIAL_NUM 1001 32123.5 23-Sep-07 A4-322-12212-W11 1002 1
I need help with 3.2, 3.3, and 3.4
CIS 3730 Database Management Systems 502 TRUCK_NUM BASE_CODE TYPE_CODE TRUCK_MILES TRUCK_BUY_DATETRUCK_SERIAL_NUM 1001 32123.5 23-Sep-07 A4-322-12212-W11 1002 1 76984.3 05-Feb-06 AC-342-22134-023 1003 501 12346.6 11-Nov-06 AC-445-78656-799 1004 2894.3 06-Jan-07 WQ-112-23144-T34 1005 503 45673.1 01-Mar-06 FR-998-32245-W12 1006 501 193245.7 15-Jul-03 AD-456-00845-R45 1007 32012.3 17-Oct-04 AA-341-96573-784 1008 502 44213.6 07-Aug-05 DR-559-22189-033 1009 503 10932.9 12-Feb-08 DE-887-98456-E94 Table name: TRUCK Primary Key: TRUCK_NUM Foreign Key: BASE_CODE, TYPE_CODE NNAN 502 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: BASE Primary Key: BASE_CODE Foreign Key: none TYPE_CODE TYPE_DESCRIPTION 1 Single box, double-axle 2 Single box, single-axle 3 Tandemn trailer, single-axle Table name: TYPE Primary Key: TYPE_CODE Foreign Key: none 3.2. Do those tables exhibit referential integrity? For each table, answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. (11 pts) 3.3. Using the same tables from above, identify the TRUCK table's candidate key(s). (11pts) 3.4. Using the same tables from above and for each table, identify a superkey and a secondary key. (11pts)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started