Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the database shown above to answer Problems 1- For each table, identify the primary key and the foreign key(s). If a table does not
Use the database shown above to answer Problems
1- For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None.
2- Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer.
3- 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.
4- For each table, identify a superkey and a secondary key.
5- Create the ERD for this database
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 1002 1003 1004 1005 1006 1007 1008 1009 32123.5 AA-322-12212-W11 76984.3 AC-342-22134-Q23 12346.6 AC-445-78656-Z99 2894.3 WQ-112-23144-T34 45673.1 FR-998-32245-12 193245.7 AD-456-00845-R45 32012.3 AA-341-96573-284 44213.6 DR-559-22189-D33 0932.9 DE-887-98456-E94 501 501 503 501 2 503 Table name: BAS Primary key: BASE_CODE Foreign key: none BASE CODE BASE_CITY BASE_STATE BASE_AREA CODE BASE PHONE BASE MANAGER 501 Murfreesboro 502 Lexington 503 Cape Girardeau 504 Dalton TN KY MO GA 615 568 456 901 123-4567 234-5678 345-6789 456-7890 Andrea D. Gallager George H. Delarosa Maria J. Talindo Peter F. McAvee Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE_CODE TYPE _DESCRIPTION 1 Single box, double-axle 2 3 Tandem trailer, single-axle gle box, single-axle
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