Assignment: A video library maintains a database of movies rented out. Without a

Question

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

Explanation / Answer

Full name Physical address salutation Janet Jones First street plot No 4 Ms. Robert Phill 3rd Street 34 Mr. Robert Phill 5th Avenue Mr. Physical address Movies rented First street plot No 4 Pirates of the caribbean First street plot No 4 Clash of Titans 3rd Street 34 Forgetting Sarah Marshal 3rd Street 34 Daddy's Little Girls 5th Avenue Clash of Titans Movies rented catagory Pirates of the caribbean Action Clash of Titans Action Forgetting Sarah Marshal Romance Daddy's Little Girls Romance Clash of Titans Action

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.