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. 

• 1500202849-Screen Shot 2017-06-24 at 9.37.45 PM.png

APlusGrades

Not Rated (0)

Status NEW Posted 16 Jul 2017 10:07 AM My Price 8.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer