The data you are provided with is slightly modified from Baseball Reference, a website that provides a litany of data for baseball data junkies to work with. It includes a pitch by pitch account of essentially any baseball game you can think of in the major leagues.

The dataset includes 14 columns:

TB the top or bottom of the inning; in the top of an inning, the visiting team bats; the bottom of an inning brings the home team to bat

Inning the segment of the game. Each team gets 3 outs per inning.

At Bat # - the number of batters that have already batted in that half inning, including that batter

Score the score of the game when that player steps into the batters box

Out how many outs there are when the batter steps to the plate. This value can only be 0, 1, or 2 as a team ends their turn at bat with 3 outs

OutRecorded whether or not that batters time at bat results in an out of some sort

Runners on Base the status of the three bases when the batter comes to bat: --- means that no one is on base. The first character being 1 means there is a runner on first; the second character being 2 means there is a runner on second; the third character being 3 means there is a runner on third

Pitch Total the number of pitches that the batter will see during the at bat

Final Count the count on the last pitch of the at bat

Pitch Sequence the result of each pitch sequentially (each character means something) for the purposes of this exercise, the meaning of the individual symbols is immaterial

@Bat the team currently at bat

Batter the player who is coming to bat

Pitcher the player who is pitching to the batter

Eventual Result the result of the players time at bat. This includes everything that happens that involves a runner or the batter

***********************************************************************************************************************************************************

Your task is to determine what needs to be done to take this data set and convert it into 1^st, 2^nd, and 3^rd normal form successively. You do not need to actually present the data in that form, but rather identify what is wrong and what should be done about it.

Present:

The names of the columns in a particular table

What is the primary key of each table

What are any foreign keys in those tables

What did you fix from the prior form?

Why did you fix it?