Based on my ER diagram, edit it based on the feedback I received. 1. Clients: This table
Question:
Based on my ER diagram, edit it based on the feedback I received.
1. Clients: This table stores information about individual clients who have missed their flights. It includes a unique client ID, name, contact information, and booking history
2. Hotels: This table contains data about partner hotels, including their unique IDs, names, addresses, available room types, and pricing information
3. Flight Bookings: Records details of original flight bookings, including flight ID, departure and arrival destinations, departure time, and airline information
4. Hotel Bookings: Stores information about hotel bookings made for clients, including booking ID, check-in and check-out dates, room type, and associated client and hotel IDs
5. Transportation: Manages transportation options for clients who need to get to their accommodations. This table includes transportation service IDs, types (e.g., shuttle, taxi), departure and arrival locations, and associated client IDs
6. Staff: Maintains data about TravelConnect's employees, including employee ID, name, contact information, and department (i.e., customer service, reservations). Helps customers with bookings
These attributes are related to TravelConnect in the following ways:
- Clients are associated with their flight bookings and hotel bookings.
- Staff book hotel and flight bookings for clients.
- Hotel bookings are linked to specific hotels.
- Transportation services are linked to client bookings.
- Staff members are associated with various departments and may interact with clients.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill