Second Normal Form (2NF)
Second normal form is only concerned with tables with composite keys, so our Customers table is already in 2NF. The aim of this stage of normalisation is to ensure all partial dependencies are removed.
The way we remove the partial dependencies we have in the Bookings table is to go through every attribute and question is dependency on the composite key. For example, if we consider the flightDestination field, this is dependent on the flightNo and not the CustNo and therefore needs to be removed into its own table.
We can also identify that the membership related fields are dependent on the custNo, so these will be added to the Customer table.
It is not possible for every field in our Bookings table to depend on just the one primary key so these will remain where they are. For example, bookingDate is dependent on the composite ...