MGT 4058 Tables - , Dest_D, Dest_A, Departure, Arrival,...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
MGT 4058 Tables Client (C_ID , F_Name, M_I, L_Name, Street, City, State, Zip, Phone, Email, CC) Agent (A_ID , A_Name, A_Phone, Salary, DOB, Com_rate) Vacation (V_ID , Start, End) Transaction (V_ID , C_ID , GrandTotal, TransactionDate) COMHotel (A_ID , HRes_ID ) COMFlight (A_ID , Flight_ID ) COMCruise (A_ID , Cruise_ID ) COMRentalCar (A_ID , Car_ID ) Hotel (Hotel_ID , H_Name, Street, City, State, Zip, Phone, Star_Rating, Room_Type, Price) Flight (Flight_ID, Departure, Arrival, Airline, Dest_D, Dest_A, Seat_Type, Price) Cruise (Cruise_ID
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: , Dest_D, Dest_A, Departure, Arrival, Cruiseline, Room_Type, Price) Rental (Rental_ID , Company, Rental_Type, Price, Pickup, Dropoff, Make, Model, Street, City, State, Zip, Phone) HotelRes ( HRes_ID , Hotel_ID , CI_Date, CO_Date, room_type, price, V_ID ) FlightRes ( FRes_ID , Flight_ID , Seat_Number, Price, Seat_type, V_ID ) CruiseRes (CRes_ID , Cruise_ID , room_type, room_number, price, V_ID ) RentalRes (RRes_ID , Rental_ID , rental_type, price, make, model, V_ID )...
View Full Document

This note was uploaded on 12/09/2011 for the course MGT 4459 taught by Professor Pawn during the Spring '11 term at Georgia Institute of Technology.

Ask a homework question - tutors are online