test
wlwlli
normalization_homework.xlsxSheet1
| Normalization | ||||||||||||||
| Description | ||||||||||||||
| In this project you will normalize a table of data (shown below) using the techniques you have learned thus far. Allow sufficient time to complete this project completely by following all directions. | ||||||||||||||
| Consider the following table of data for this project. | ||||||||||||||
| Date Out | Last Name | First Name | Zip | Title | Video ID | Shipment ID | City | State | Total Rental | Wholesale Cost | Rental ID | Movie | Dist. | Cust. Acct. No. |
| Code | Fee | ID | ID | |||||||||||
| 7/23/00 | Smith | John | 20783 | Titanic | V127 | S076 | Adelphi | MD | $3.00 | $120.00 | R100 | M012 | D006 | C074 |
| 7/23/00 | Smith | John | 20783 | Bambi | V099 | S076 | Adelphi | MD | $1.25 | $100.00 | R101 | M177 | D006 | C074 |
| 7/23/00 | Jones | John | 21113 | Top Gun | V006 | S055 | Odenton | MD | $0.99 | $110.00 | R102 | M050 | D003 | C049 |
| 7/23/00 | Smith | Bill | 20783 | Titanic | V128 | S075 | Adelphi | MD | $3.00 | $125.00 | R103 | M012 | D004 | C202 |
| 7/23/00 | Jones | Bill | 21114 | Scream | V299 | S050 | Crofton | MD | $2.75 | $109.00 | R104 | M180 | D006 | C210 |
| 7/24/00 | Jones | Jill | 20783 | Scream | V300 | S049 | Adelphi | MD | $2.55 | $110.00 | R105 | M180 | D005 | C211 |
| 7/24/00 | Jones | John | 21113 | Scream | V301 | S049 | Odenton | MD | $2.55 | $110.00 | R106 | M180 | D005 | C049 |
| 7/24/00 | Smith | John | 20783 | Top Gun | V006 | S055 | Adelphi | MD | $0.99 | $110.00 | R107 | M050 | D003 | C074 |
| 7/25/00 | Jones | Jill | 20783 | Bambi | V099 | S076 | Adelphi | MD | $0.99 | $100.00 | R108 | M177 | D006 | C211 |
| 7/25/00 | Smith | Bill | 21114 | Titanic | V127 | S076 | Crofton | MD | $3.00 | $120.00 | R109 | M012 | D006 | C298 |
