(SOLVED)MCIS 5133 Full Names Physical Movies rented Salutation Category Address Janet Jones First Street Plot Pirates of the Ms. Action, Action No 4 Caribbean, Clash...

Question Answered step-by-step Assignment: A video library maintains a database of movies rented out. Without any normalization, all information is stored in one table as shown below. Image transcription text Full Names Physical Movies rented Salutation Category Address Janet Jones First Street Plot Pirates of the Ms. Action, Action No 4 Caribbean, Clash of the Titans Robert Phil 3'd Street 34 Forgetting Sarah Mr. Romance, Marshal, Romance Daddy's Little Girls Robert Phil 5th Avenue Clash of the Titans Mr. Action 1. Convert above table into 1NF: Each table cell should contain a single value. Each record needs to be unique. Convert 1NF to 2NF Rule1 - be in 1NF Rule 2- Single Column Primary Key Convert 2NF to 3NF Rule 1- Be in 2NF Rule 2- Has no transitive functional dependencies What to turn in: · A softcopy of your answers. · No handwritten answers are accepted.