Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Table nams: TRUCK Database name: Cho3_TransCo Primary key: TRUCK_NUM Foreigh hey: BASE CODE, TYPE CODE Table name: BASE Primary key: BASE_CODE Foreign kevi hone: Table
Table nams: TRUCK Database name: Cho3_TransCo Primary key: TRUCK_NUM Foreigh hey: BASE CODE, TYPE CODE Table name: BASE Primary key: BASE_CODE Foreign kevi hone: Table name: TYPE Primary key: TYPE CODE Foreign key? none 17. For each table, idencify the pirmary boey and the foreign keyisi. If a table does not hane a foreign laey, write None In the space provided. 18. Do the tables exhibit entity iriegrily? Ansaer yes or no, and theri explsin your answer. 19. Do the wbks exhlkt referential integnts? Ansuker ses or no, and then explain your arsake. White Na ofot Applicabiel if the table does not have a fereign keyi. 20. Identify the TRUCK table's cancidste besy(s) 21. For each table, icentity a superkey and a secondary key. 22. Create the ERD for this database. Table nams: TRUCK Database name: Cho3_TransCo Primary key: TRUCK_NUM Foreigh hey: BASE CODE, TYPE CODE Table name: BASE Primary key: BASE_CODE Foreign kevi hone: Table name: TYPE Primary key: TYPE CODE Foreign key? none 17. For each table, idencify the pirmary boey and the foreign keyisi. If a table does not hane a foreign laey, write None In the space provided. 18. Do the tables exhibit entity iriegrily? Ansaer yes or no, and theri explsin your answer. 19. Do the wbks exhlkt referential integnts? Ansuker ses or no, and then explain your arsake. White Na ofot Applicabiel if the table does not have a fereign keyi. 20. Identify the TRUCK table's cancidste besy(s) 21. For each table, icentity a superkey and a secondary key. 22. Create the ERD for this database
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