The hotel group has already collected a lot of data in a spreadsheet (an extract from...

Transcribed Image Text:

The hotel group has already collected a lot of data in a spreadsheet (an extract from the spreadsheet is shown below). The data has been normalized to the first normal form already - underlined column names indicate composite primary key columns. Hotel Hotel Name ID 1 1 1 2 3 4 Hotel Hotel Type Room Type Description Type ID ID Parktonian Parktonian Parktonian 1 1 1 2 Holiday-Inn Lakeview 3 Johannesburg 2 Luxury Luxury Luxury Budget Self- catering Budget 1 2 3 2 4 2 Room Type Number Description of Rooms Suite Double Single Double Self- catering Double 20 50 10 10 3 500 Note: Number of rooms refers to the number of a specific type of room located in the hotel. Normalize the above data to the second normal form (2NF). Show all steps as well as the final answer in the form of dependency diagrams and not table format (20 marks). The hotel group has already collected a lot of data in a spreadsheet (an extract from the spreadsheet is shown below). The data has been normalized to the first normal form already - underlined column names indicate composite primary key columns. Hotel Hotel Name ID 1 1 1 2 3 4 Hotel Hotel Type Room Type Description Type ID ID Parktonian Parktonian Parktonian 1 1 1 2 Holiday-Inn Lakeview 3 Johannesburg 2 Luxury Luxury Luxury Budget Self- catering Budget 1 2 3 2 4 2 Room Type Number Description of Rooms Suite Double Single Double Self- catering Double 20 50 10 10 3 500 Note: Number of rooms refers to the number of a specific type of room located in the hotel. Normalize the above data to the second normal form (2NF). Show all steps as well as the final answer in the form of dependency diagrams and not table format (20 marks).