Hello,

I am completing some work for Uni and have a single table of data that i need to arrange into 1st,2nd and 3rd Normal Form, i have attempted to do so below but i have hit a brick wall with it.

I would appreciate any helpful input at all as my tutor is away on holiday and i don't want to start the rest of the work using the wrong tables/relations to start with.

Basically the system is supposed to allow users to add films, directors and actors. Allow multiple users to review films and categorise the films by genre.

UNF
filmID
title
directorID
categoryID
categoryName
notes
directorName
actorName
actorID
role
userID
userName
reviewDate
reviewText


1NF
filmID
title
notes

directorID
directorName

categoryID
categoryName

actorID
filmID*

actorName
role

userID
userName

filmID*
userID*

reviewDate
reviewText


2NF
filmID
title
notes

directorID
directorName

categoryID
categoryName

actorID
actorName

actorID
filmID*

role

userID
userName

filmID*
userID*

reviewDate
reviewText



Thanks in advance.