1.Show all the functional dependencies in the attached table.
2. Convert the relation to a set of relations in at least Third Normal Form (3NF).
3. Explain how your new design addresses the problems you identified in (a) and preserves all the information in the original design
Year: StudentNo: StudentName: Team: FirstMajor: Project: BroadArea: Client: Supervisor: Grade:
The year the project is run
Unique student number
The full name of the student
A name the team chooses for themselves The first (or only) major of the student
A descriptive name of the project
The general IT area the project is in
Name of the person/organisation who is client for the project
Name of the staff member who supervises the team
The final grade awarded to the student. It is possible for members of a team to receive different grades.
