Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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

Understanding Oracle APEX 5 Application Development

Authors: Edward Sciore

2nd Edition

1484209893, 9781484209899

More Books

Students also viewed these Databases questions