Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 PlotPirates of the No 4 Category Janet 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 1. Convert above table into INF: Each table cell should contain a single value b. a. Each record needs to be unique 2. Convert INF to 2NF a. Rulel- be in INF b. Rule 2- Single Column Primary Key 3. Convert 2NF to 3NF a. Rule 1- Be in 2NF b. Rule 2- Has no transitive functional dependencies What to turn in A softcopy of your answers No handwritten answers are accepted
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started