Question
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
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.
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