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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!