Relational Schema Car Rental Key 544 F1

MGMT 54400
Fall 2013

Relational Schema

1. CUSTOMER (C_Name, C_Phone, Dr_Lic_No, C_Street, C_City, C_State, C_Zip)

2. CAR (Vehicle_ID, Lic_Plate_No, Make, Model, Price, Mileage, Car_Type, D_Name)

FK D_Name  DEALER

3. COMPACT_CAR (C_Vehicle_ID, No_of_Doors)

FK C_Vehicle_ID  CAR

4. LUXURY_CAR (L_Vehicle_ID, Headroom, Legroom, Premium)

FK L_Vehicle_ID  CAR

5. DEALER (D_Name, D_Phone, D_Street, D_City, D_State, D_Zip)

6. SERVICE_CO (Co_Name, Co_Phone, Co_Street, Co_City, Co_State, Co_Zip)

7. MAINTENANCE (Vehicle_ID, Serv_Date, Serv_Code, Co_Name)

FK Vehicle_ID  CAR
FK Co_Name  SERVICE_CO.

8. RESERVATION (Confirm_No, C_Name, C_Phone, Car_Type, Credit_Card_No, Daily_Rate, Mileage_Rate, Res_Pickupdate, Res_Returndate)

FK C_Name, C_Phone  CUSTOMER

9. RENTAL (Confirm_No, Vehicle_ID, Pickupmile, Returnmile, Ren_Pickupdate, Ren_Returndate)

FK Confirm_No  RESERVATION
FK Vehicle_ID  CAR

10. INVOICE (Inv_No, Confirm_No, Vehicle_ID, Inv_Date, Inv_Amount)

FK Confirm_No, Vehicle_ID  RENTAL

11. AUCTION (Vehicle_ID, Auct_Date, Auct_Price)

FK Vehicle_ID  CAR