Question: DEPOT Table 5. Using the tables CAB, DEPOT, and DRIVER tables presented above, answer the following questions: A. For each table, identify the primary key

DEPOT Table 5. Using the tables CAB, DEPOT, and DRIVER tables presented above, answer the following questions: A. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. (5 points) B. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. ( 5 points) C. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write N/A (Not Applicable) if the table does not have a foreign key. ( 5 points) D. Write the relational algebra expression and create the table that would result from applying the SELECT and PROJECT relational operators to the CAB table to retum only the CAB_ID, CAB_MILEAGE, and CAB_REGISTRATION attributes for cabs flown by either driver 3 or driver 7 . 5 points) E. Write the relational algebra expression and create the table that would result from applying the SELECT and PROJECT relational operators to the CAB table to retum only the CA1 _ID, CAB_MILEAGE, and CAB_REGISTRATION attributes for cabs with a mileage of over 30000 miles. (5 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
