Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

1st Edition

1597496251, 978-1597496254

More Books

Students also viewed these Databases questions