[Solved] DATABASE QUESTION

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.