CustomerID | FirstName | LastName | EmailAddress |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Alice | Brown | alice.brown@example.com |
4 | Charlie | White | charlie.white@example.com |
5 | David | Black | david.black@example.com |
FlightNumber | DepartureAirport | ArrivalAirport | DepartureTime | EstimatedArrivalTime |
---|---|---|---|---|
1 | LAX | ORD | 2023-01-01 10:00:00 | 2023-01-01 18:00:00 |
2 | DFW | ATL | 2023-01-01 16:00:00 | 2023-01-02 09:00:00 |
3 | EWR | MIA | 2023-01-01 17:00:00 | 2023-01-03 08:00:00 |
4 | IAH | YYZ | 2023-01-01 20:00:00 | 2023-01-04 15:00:00 |
5 | MSP | SEA | 2023-01-01 22:00:00 | 2023-01-05 14:00:00 |
PropertyID | ItemDescription | DateOfLoss | Found |
---|---|---|---|
(→ PropertiesCalendar.Date) | |||
1 | Laptop | 2023-01-05 | 1 |
2 | Wallet | 2023-01-06 | 0 |
3 | Phone | 2023-01-07 | 1 |
4 | Keys | 2023-01-08 | 0 |
5 | Passport | 2023-01-09 | 1 |
ComplaintID | Description | Severity | Resolved | SubmissionDate | CustomerId | FlightNumber |
---|---|---|---|---|---|---|
(→ PropertiesCalendar.Date) | (→ Customers.CustomerID) | (→ Flights.FlightNumber) | ||||
1 | Delayed baggage | 2 | 0 | 2023-01-05 | 1 | 1 |
2 | Rude staff | 3 | 0 | 2023-01-06 | 2 | 2 |
3 | Food poisoning | 3 | 0 | 2023-01-07 | 3 | 3 |
4 | Seat comfort | 1 | 0 | 2023-01-08 | 4 | 4 |
5 | Noise | 2 | 0 | 2023-01-09 | 5 | 5 |
CalendarID | Year | Month | Day | Date |
---|---|---|---|---|
1 | 2023 | 1 | 5 | 2023-01-05 |
2 | 2023 | 1 | 6 | 2023-01-06 |
3 | 2023 | 1 | 7 | 2023-01-07 |
4 | 2023 | 1 | 8 | 2023-01-08 |
5 | 2023 | 1 | 9 | 2023-01-09 |