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 Movies rented Salutation Physical Address First Street Plot No 4 Category Ms. Pirates of the Caribbean, Clash of the Titans Forgetting SarahMr Marshal, Daddy's Little Girls Clash of the Titans Mr Janet Jones Action, Action Robert Phi 3td Street 34 Romance, Romance Robert Phil 5th Avenue Action .Convert 2NF to 3NF a. Rule 1-Be in 2NF b. Rule 2- Has no transitive functional dependencies