Normalization - Solved exercise
Consider a relation Movies_Screened with attributes Theatre, Movie, Day, Time, and Certificate. Sample tuples are as follows:
- THEATRE cannot determine any attributes as a theatre screens more than one movie, it screens on different days, different timings, and different certification movies.
- MOVIE can determine the CERTIFICATE value as a movie will be given only one certificate. Hence, we can include MOVIE → CERTIFICATE.
- Likewise, DAY, TIME and CERTIFICATE cannot determine the other attributes uniquely.
Go back to Normalization – solved exercises page.
Go to How to find closure page
Go to 2NF, 3NF and BCNF
normalize the table, normalize a relation to second normal form, third normal form, boyce-codd normal form