In the 2NF form, particularly in the Passenger entity. What is the correct normalized attribute and data type for the passenger entity?

In the 2NF form, particularly in the Airport entity. What is the correct normalized attribute and data type for the Airport entity?

In the 2NF form, particularly in the Airline entity. What is the correct normalized attribute and data type for the Airline entity?

In the 2NF form, particularly in the Flight entity. What is the correct normalized attribute and data type for the Flight entity?

In the 2NF form, particularly in the Ticket entity. What is the correct normalized attribute and data type for the Ticket entity?

In the 2NF form, there is a relationship between the passenger and the ticket.

Each passenger can book multiple tickets, and each ticket is for one passenger.

In the 2NF form, there is a relationship between the ticket and the flight.

Each ticket is for one flight, but a flight can have multiple tickets

In the 2NF form, there is a relationship between the airport and the flight.

Each flight departs from and arrives at one airport, but an airport can serve multiple flights.

In the 2NF form, there is a relationship between the airport and the flight.

Each flight is operated by one airline, but an airline can operate multiple flights.

In the 2NF form, there is a relationship between the airport and the passengers.

Each passenger can prefer multiple airlines, and each airline can be preferred by multiple passengers