Question: Primary key: TRUCK_NUM Database name: Ch03_TransCo Foreian kevs: RASE CODE. TYPE CODE Table name: BASE Primary key: BASE_CODE Foreign key: none Table name: TYPE Primary

Primary key: TRUCK_NUM Database name: Ch03_TransCo Foreian kevs: RASE CODE. TYPE CODE Table name: BASE Primary key: BASE_CODE Foreign key: none Table name: TYPE Primary key: TYPE_CODE Foreign key: none 1. Create a natural JOIN of table TRUCK and table TYPE and SELECT on TYPE_CODE =3 and PROJECT on TRUCK_NUM, TYPE_CODE and TYPE_DESCRIPTION 2. Write the answer of the above in a simple table, with three columns (for 3 attributes) 3. Paste the table in the space below that identifies the solution to the above
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
