What tables can be linked to the airport check-in desk?

Question

Database

In general, there is a topic on the course - "Check-in of passengers at the airport." The requirement is a minimum of 20 tables.
Everything would be fine, but I absolutely do not catch up with what 20 tables can be associated with the front desk. For me, this whole topic with airports (in general) is a dead topic.
I count on you very much. I ask you to help me with the names of the tables, as well as their (if possible) PK and FK.
Many thanks in advance.

Answer 1

Well the silly requirement about 20 tables, of course. Walking like walking :)
- Name
- ICAO code 2.
- Airport (FK) -
Full name
- Position - Airport - Employee - Hours of work - Type - ... _ _ - Departure time - Arrival time
- Flight duration (slightly denormalized so as not to count each time)
- Full name
- Date of birth
- Passport data
- Name
- Discount amount in%
-in - Passenger (FK)
- Flight (FK)
- Desk ( FK)
- Discount (FK)
- Seat number
- Price
- Check-in (FK)
- Baggage number
- Weight
- Cost
At this point, my inspiration ran out. But you can inflate it in different directions:
- Types of aircraft (airplanes, helicopters)
- Maintenance, technicians involved in it
- Calculation of the salary of airport employees, including registrars at the counters
- Types of airlines (local, international)
- ...