Database In-class Assignment Normalization
For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF.
|
Movie
|
Rating
|
Showtime
|
Theater
|
|
The SpongeBob Movie
|
PG
|
4:00
|
1
|
|
The SpongeBob Movie
|
PG
|
7:00
|
1,2
|
|
Focus
|
R
|
4:00
|
3,4
|
|
Focus
|
R
|
7:00
|
3,4,5
|
|
Focus
|
R
|
10:00
|
1
|
|
Kingsman: The Secret Service
|
R
|
7:00
|
6
|
|
Kingsman: The Secret Service
|
R
|
10:00
|
6
|
|
McFarland, USA
|
PG
|
3:00
|
7
|
|
McFarland, USA
|
PG
|
7:00
|
7,8
|
|
McFarland, USA
|
PG
|
7:30
|
9
|
|
Hot Tub Time Machine 2
|
R
|
7:00
|
11
|
|
Hot Tub Time Machine 2
|
R
|
9:00
|
2
|
|
Jupiter Ascending
|
PG-13
|
7:00
|
12
|
Hints: In this case, it might be best to first check in the table is in 1NF, and then put the table into 1NF before trying to list the functional dependencies. To find the functional dependencies, ask yourself, if I know a value in this column (or these columns) do I logically know the values in the other columns (examples: If I know the movie, would I always know the rating? If I knew the Theater and the Movie would I know the Showtime?, etc.). There are two functional dependencies.
You may complete this assignment in Word, Excel, PowerPoint, or on Paper and email a picture of the completed assignment (as long as it is a standard, readable file format).