| 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 |
|---|---|---|---|
| (→ Calendar.Date) | |||
| 1 | Phone | 2023-01-07 | 1 |
| 2 | Keys | 2023-01-08 | 0 |
| 3 | Passport | 2023-01-09 | 1 |
| 4 | Wallet | 2023-01-06 | 0 |
| ComplaintID | Description | Severity | Resolved | SubmissionDate | CustomerId | FlightNumber |
|---|---|---|---|---|---|---|
| (→ Calendar.Date) | (→ Customers.CustomerID) | (→ Flights.FlightNumber) | ||||
| 1 | Delayed baggage | 2 | 0 | 2023-01-05 | 1 | 1 |
| 2 | Rude staff | 3 | 1 | 2023-01-06 | 2 | 2 |
| 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 |