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.

 

Transcribed Image Text:

2. Movie Rental Scenario. A database is needed to track customer movie rentals. The following data is collected: Full Names Janet Jones Robert Phil Robert Phil Physical Address 3. Normalize to 3NF. First Street Plot No 4 3rd Street 34 5th Avenue Movies rented UNF Pirates of the Caribbean, Clash of the Titans What form is this table in? Identify at least 3 business rules (functional dependencies). 1. Full Names are 2. Salutation Ms. Forgetting Sarah Marshal, Daddy's Little Girls Clash of the Titans Mr. Mr. Category Action, Action Romance, Romance Action 2. Movie Rental Scenario. A database is needed to track customer movie rentals. The following data is collected: Full Names Janet Jones Robert Phil Robert Phil Physical Address 3. Normalize to 3NF. First Street Plot No 4 3rd Street 34 5th Avenue Movies rented UNF Pirates of the Caribbean, Clash of the Titans What form is this table in? Identify at least 3 business rules (functional dependencies). 1. Full Names are 2. Salutation Ms. Forgetting Sarah Marshal, Daddy's Little Girls Clash of the Titans Mr. Mr. Category Action, Action Romance, Romance Action

Answer rating: 100% (QA)

The table appears to be in Unnormalized Form UNF because you can see there are repeating groups or multivalued attributes as evident by the entries fo... View the full answer