Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Movie Rental Scenario. A database is needed to track customer movie rentals. The following data is collected: Full Names Movies rented Salutation Category Physical
2. Movie Rental Scenario. A database is needed to track customer movie rentals. The following data is collected: Full Names Movies rented Salutation Category Physical Address First Street Plot No 4 Janet Jones Ms. Action, Action Robert Phil 34 Street 34 Pirates of the Caribbean, Clash of the Titans Forgetting Sarah Marshal, Daddy's Little Girls Clash of the Titans Romance, Romance Robert Phil 5 Avenue Mr. Action What form is this table in? UNE Identify at least 3 business rules (functional dependencies). 1. Full Names are 1. 2. - 3. - ini mi Normalize to 3NF
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