Database normalisation - some issues

Question

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

Answer 1

It's entirely possible that a database that meets the criteria for 2nd Normal Form also meets the criteria for 3rd Normal Form. It looks like that is the case here.

Answer 2

Here are some questions for you...

• Can an actor also be a director?
• Can a film have more than one director?
• Can a user review a film more than once?
• Are the genres predefined?
• Can an actor play more than one role in a film?

Answer 3

You'll find here on Stack Overflow that people won't answer your homework for you.

However here's a link to a very good tutorial.

Normalisation Tutorial

You'll understand it much better if you work through it and complete it yourself, rather than copying and pasting the answer from here.