please solve this homework:

CECS 323 HOMEWORK: NORMALIZATION OBJECTIVE: Give you some first hand experience converting an existing data table into a normalized design. INTRODUCTION: You land a job with a small movie rental store. They have been managing their rental records by means of a small spreadsheet, but they realize that they have occasionally entered some conflicting information into their database. Just last week they had one record that claimed that the Movie Logan was a comedy and the rest of the records for that movie portrayed it as an action film. You ask them for some sample data, and they provide you with sample data here: Upon questioning the owner, you find: As small as this video store is, they still have customers like Robert Phil who are two different people, but just happen to have the same name. The video store computes the invoice cost when the customer turns in the videos. That cost depends on how long the customer has had the video. If you see no invoice cost, that means that the customer has not returned one or more of the videos. The store would like to be able to capture the date on which the customer returns each video. The Movies Rented and the Category columns parallel each other. For each movie in the Movies Rented column, the corresponding value in the Category column represents the type of movie. For instance, since the Hunt for Red October is the third entry in that value for Movies Rented, that means that it is an Action film, since it is the third value in the corresponding Category entry. PROCEDURE: Using the process that we talked about in class, normalize the above table structure one step at a time until you get it into 3d normal form. WHAT TO TURN IN: A UML model of what this data looks like in first normal form. A UML model of what this data looks like in 2nd normal form. A UML model of what this data looks like in 3rd normal form. The relation scheme of your 3rd normal form model. CECS 323 Homework Normalization Sample Data.xlsx - Excel tac File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Calibri ab V 11 General E. Conditional Formatting B 1 U- A Format as Table A $ % Paste A 6.0 .00 .00 .0 Cell Styles Clipboard Font Alignment Number Styles G9 X . A D E F H B Customer Physical Address Invoice Customer Name Rental Date Movies Rented Salutation Category Release Year Studio 1 Cost Janet Jones 1st St. Plot #4 5/15/2019 Pirates of the Caribbean: The Curse of the Black Ms. Pearl, Clash of the Titans Action, Action Disney Pictures, 2003, 2010 MGM 2 Robert Phil 3St. 34 6/22/2019 Forgetting Sarah Marshall Daddy's Little Girls/ The Mr. Hunt for Red October Romance, Romance, Action Universal Pictures, 2012, 2007, Lionsgate, $5.83 1990 Paramount Pictures 3 4. Robert Phil 28 5th Ave 8/12/2019 Clash of the Titans Mr. Action 2010 MGM $3.50 5 6 CECS 323 HOMEWORK: NORMALIZATION OBJECTIVE: Give you some first hand experience converting an existing data table into a normalized design. INTRODUCTION: You land a job with a small movie rental store. They have been managing their rental records by means of a small spreadsheet, but they realize that they have occasionally entered some conflicting information into their database. Just last week they had one record that claimed that the Movie Logan was a comedy and the rest of the records for that movie portrayed it as an action film. You ask them for some sample data, and they provide you with sample data here: Upon questioning the owner, you find: As small as this video store is, they still have customers like Robert Phil who are two different people, but just happen to have the same name. The video store computes the invoice cost when the customer turns in the videos. That cost depends on how long the customer has had the video. If you see no invoice cost, that means that the customer has not returned one or more of the videos. The store would like to be able to capture the date on which the customer returns each video. The Movies Rented and the Category columns parallel each other. For each movie in the Movies Rented column, the corresponding value in the Category column represents the type of movie. For instance, since the Hunt for Red October is the third entry in that value for Movies Rented, that means that it is an Action film, since it is the third value in the corresponding Category entry. PROCEDURE: Using the process that we talked about in class, normalize the above table structure one step at a time until you get it into 3d normal form. WHAT TO TURN IN: A UML model of what this data looks like in first normal form. A UML model of what this data looks like in 2nd normal form. A UML model of what this data looks like in 3rd normal form. The relation scheme of your 3rd normal form model. CECS 323 Homework Normalization Sample Data.xlsx - Excel tac File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Calibri ab V 11 General E. Conditional Formatting B 1 U- A Format as Table A $ % Paste A 6.0 .00 .00 .0 Cell Styles Clipboard Font Alignment Number Styles G9 X . A D E F H B Customer Physical Address Invoice Customer Name Rental Date Movies Rented Salutation Category Release Year Studio 1 Cost Janet Jones 1st St. Plot #4 5/15/2019 Pirates of the Caribbean: The Curse of the Black Ms. Pearl, Clash of the Titans Action, Action Disney Pictures, 2003, 2010 MGM 2 Robert Phil 3St. 34 6/22/2019 Forgetting Sarah Marshall Daddy's Little Girls/ The Mr. Hunt for Red October Romance, Romance, Action Universal Pictures, 2012, 2007, Lionsgate, $5.83 1990 Paramount Pictures 3 4. Robert Phil 28 5th Ave 8/12/2019 Clash of the Titans Mr. Action 2010 MGM $3.50 5 6