Normalization with ERD Part #2

Choose the correct 1NF form from the Ticket entity

• 
• 
• 

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.

• 
• 
•