The Skill_Id is a number that is unique for each skill, but the skill name is not.

The Student_Email is also unique for each student.

Students taking computing modules may come from outside courses such as Business. This information along with the course director responsible is also recorded. There is a single course director for each course, but a member of staff can be course director for several courses.

Each programming skill that a student has been tested on is recorded with the date that the test took place and the skill level reached. The test may be repeated, but only the latest result is to be stored.

1. Identify all functional dependencies among attributes. If you decide that the information given is not sufficient for determining all functional dependencies, make whatever assumptions you think are necessary but state them clearly.
2. Decompose the above example into 3NF, taking care to identify primary and foreign keys in all relations.
3. Describe, the problems that may occur when insertions deletions and modifications are made.

Student_Email Name Address Course Course_Director Skill_ld Skill_Name Skill_Date Skill_Level D96abc Jones 6 Old Manor Computing Paul 23 Prolog 2/4/17 6 D96abc Jones 6 Old Manor Computing Paul 23 Java 1/3/17 5 D96abd Stewart 4 Coach Rd Business Thompson 33 Prolog 3/5/17 8 D96xyz Rodgers 1 New Road Business Thompson 16 Pascal 1/3/17 4 Student_Email Name Address Course Course_Director Skill_ld Skill_Name Skill_Date Skill_Level D96abc Jones 6 Old Manor Computing Paul 23 Prolog 2/4/17 6 D96abc Jones 6 Old Manor Computing Paul 23 Java 1/3/17 5 D96abd Stewart 4 Coach Rd Business Thompson 33 Prolog 3/5/17 8 D96xyz Rodgers 1 New Road Business Thompson 16 Pascal 1/3/17 4