Question: 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
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 return 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 return only the CAB_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
