1.Convert 2NF to 3NF

a. Rule 1- Be in 2NF

b. Rule 2- Has no transitive functional dependencies

Assignment: A video library maintains a database of movies rented out. Without any normalization, all information is stored in one table as shown below Full Names Physical Address First Street PlotPirates of the Movies rented Salutation Category anet Jones Ms. Action, Action Caribbean Clash of the Titans Forgetting Sarah Marshal, Daddy's Little Girls Clash of the Titans Robert Phil 3rd Street 34 Mr. Romance, Romance Robert Phil 5th Avenue Mr. Action