Normalization SQL

(b) A company wishes to store data on employee's holidays in a small database. The following table is proposed to meet their needs (keys underlined): holiday (ID, name, email, numHols, deptNo, deptName, deptManager, hID, hStartDate, hDuration) An employee has an associated unique ID (ID), a name (name) and an email address (email) and a number of day's holidays (numHols) per year. Each employee works in a particular department with an associated unique number (deptNo), a name (deptName) and a manager name (deptManager). A department has many employees but an employee can only work for one department. Each time an employee wishes to take some holidays, the details must be entered in advance detailing an ID (hID), the date the holiday begins (hStartDate) and the duration of the holiday in days (hDuration). Over the period of a year, an employee may have many entries in the table. A sample entry might be (12, 'June Doyle', j.doyle@eg.org. 20, 5, "HR. 'Sue Lydon", l #5/0 1 /20 1 6#, 3) This entry indicates that June Doyle, with staff number 12, and an email address of 'j.doyle@eg.org' has 20 days of holidays per year The employee works in the HR department which has department number 5 and manager Sue Lydon. The employee is taking 3 days holidays (with h ID=1) beginning on 5/01/2016