FlightID DepartureAirport TargetAirport [CustomerName, DateOfDeparture CustomerMemberNr] XC587,PA897 LHR LAX John Taylor, 2231 10/4/2022 26/5/2022 TC487 IST...

 

Transcribed Image Text:

FlightID DepartureAirport TargetAirport [CustomerName, DateOfDeparture CustomerMemberNr] XC587,PA897 LHR LAX John Taylor, 2231 10/4/2022 26/5/2022 TC487 IST LHR Mustafa Ahmed, 14/5/2022 7723 NX223 DEL IST BU412 FRA IAH Pierce Brosnan, 7789 23/9/2021 John Malkovich, 16/8/2021 99655 (i) Explain what needs to be done to convert the data to 1NF. [2 marks] (11) Write down the 1NF of the data above. Introduce a new ID so that FlyingCool can identify each booking individually. Indicate any primary keys with an underline and any foreign keys by a*. [3 marks] (ii) Now produce a projection of this table so that the relation is in 2NF, indicating any primary keys with an underline and any foreign keys by a". [3 marks] FlightID DepartureAirport TargetAirport [CustomerName, DateOfDeparture CustomerMemberNr] XC587,PA897 LHR LAX John Taylor, 2231 10/4/2022 26/5/2022 TC487 IST LHR Mustafa Ahmed, 14/5/2022 7723 NX223 DEL IST BU412 FRA IAH Pierce Brosnan, 7789 23/9/2021 John Malkovich, 16/8/2021 99655 (i) Explain what needs to be done to convert the data to 1NF. [2 marks] (11) Write down the 1NF of the data above. Introduce a new ID so that FlyingCool can identify each booking individually. Indicate any primary keys with an underline and any foreign keys by a*. [3 marks] (ii) Now produce a projection of this table so that the relation is in 2NF, indicating any primary keys with an underline and any foreign keys by a". [3 marks]

Answer rating: 100% (QA)

1 To convert the data to 1NF each attribute should be atomic meaning there should be n... View the full answer