Help in normalization

1)Each flight number refers to ONE nonstop daily flight that goes between "from" city and "to" city. The table records its scheduled departure time and arrival time. Flight numbers are unique.

2)The actual departure and arrival time of a flight on a given day are recorded in the ActualFlightInfo table. A given flight number (say U556) is only flown once on any given day. FightDate is the date of departure.

3)On any actual flight (Say U556 on 2/10/2016), a crew serves on it.The database records the employeeNo and the role (e.g., captain, 1^st flight attendant) for each crewmember on each actual flight scheduled or flown on a particular date (e.g. Adam served as the captain on U556 on 2/10/2016).Each employee serves only one role on a given flight scheduled or flown.An employee may serve different roles on different flights. For example, Adam served as the caption of U556 on 2/10/2016 but he served as the co-pilot on U556 on 2/13/2016. Mike served as the first flight attendant on U556 on 2/10/2016 but he served as the second flight attendant on U556 on 2/13/2016.

4)On any actual flight (Say U556 on 2/10/2016), the plane flying the flight is recorded in the database. Obviously, there is only one plane flying for a given flight scheduled or flown, say U556 on 2/10/2016. However, U556 on 2/13/2016 can be flown with a different airplane. Airplane-seriesNo is unique to each airplane.

5)Number of remaining seats on each actual flight (say U556 on 9/20/2016) is recorded in the database.