The question is in the image attached Data about the final marks that hairdressers achieved for the different skill exams has beencollected in a spreadsheet (an extract from the spreadsheet is shown below). The data has beennormalised to first normal form already – underlined column names indicate composite primarykey columns.SkillHairdresserSkill LevelFinalNameSurnameSkill IDSkill NameLevelIDDescriptionMarkID1JoeMahlasela1Styling1Basic751JoeMahlaselaShampooing1Basic671JoeMahlasela3Cutting2Intermediate981JoeMahlasela4ColouringIntermediate2MarthaLebusaStyling1Basic76MarthaLebusa2Shampooing1Basic512MarthaLebusa3Cutting2Intermediate54Normalise the above data to third normal form (3NF). Show all steps as well as the final answer inthe form of dependency diagrams.

Primary key for the relation = {Hairdresser ID, SkillID} The FDs on the relation are Hairdresser ID…

collected in a spreadsheet (an extract from the spreadsheet is shown below). The data has been normalised to first normal form already – underlined column names indicate composite primary key columns. Skill Hairdresser Skill Level Final Name Surname SkilI ID Skill Name Level ID Description Mark ID Joe Mahlasela 1 Styling 1 Basic 75 1 Joe Mahlasela 2 Shampooing 1 Basic 67 1 Joe Mahlasela 3 Cutting 2 Intermediate 98 1 Joe Mahlasela 4 Colouring 2 Intermediate 2 Martha Lebusa 1 Styling 1 Basic 76 2 Martha Lebusa 2 Shampooing 1 Basic 51 2 Martha Lebusa 3 Cutting 2 Intermediate 54 Normalise the above data to third normal form (3NF). Show all steps as well as the final answer in the form of dependency diagrams. HNN