1. Create an Excel spreadsheet. Analyze the following unnormalized table: Apply the rules of normalization to normalize the database to Third Normal Form (3NF). Use the following analysis results to perform the normalization: a. The school name is unique within the database. b. A city can have more than one school, but a school can be in only one city. c. Schools can have the same team name d. There is a need to select and sort on the number of wins and losses separately. e. It's important to know the order of the games. f. Each player on a team must have a unique uniform number, but multiple schools can use the same uniform numbers. On the spreadsheet, show the 3NF tables that result from your normalization process. Also, write text in the area below the tables describing your normalization process.

Utah High School Football Unnormalized ayer School Weber Weber Northridge Davis City North Ogden North Ogden Layton Kaysville Coach Corbridge Corbridge Thompson Bishop NumberPlayer NameTeam Name RecordGame 1 Date Game1 Score Game 2 Date Game 2 Score 42 18 6 42 Locke Reyes Austin Shepherd Warriors Warriors Knights Darts 3W 6L 08/20/11 3W 6L 08/20/11 9W 3L0 8W 2L 09/03/11 27-20 (W)09/17/11 6-14 (L) 31 (L) 3-7 (L08/27/11 0 31 (L) 08/20/11 21-14 (W)09 Utah High School Football Unnormalized ayer School Weber Weber Northridge Davis City North Ogden North Ogden Layton Kaysville Coach Corbridge Corbridge Thompson Bishop NumberPlayer NameTeam Name RecordGame 1 Date Game1 Score Game 2 Date Game 2 Score 42 18 6 42 Locke Reyes Austin Shepherd Warriors Warriors Knights Darts 3W 6L 08/20/11 3W 6L 08/20/11 9W 3L0 8W 2L 09/03/11 27-20 (W)09/17/11 6-14 (L) 31 (L) 3-7 (L08/27/11 0 31 (L) 08/20/11 21-14 (W)09