Databases Assignment Example | Topics and Well Written Essays - 500 words

Databases - Assignment Example The pitcher statistics are strikeouts, walks, saves, innings, pitched, earned runs, wins and losses. An entity is in the first normal form if it contains no repeating sets of data. Similarly the above attributes contain several repeating attributes. Walks for example are found within the pitcher and the hitter. This wastes a lot of space in the data base. To normalize the ERD into INF we eliminate the redundant data. In 2NF we further normalize the diagram and include foreign keys. These foreign keys are items that are used as primary key in other attributes. The awayteamID for example was used in 1NF as the primary key for the Awayteam. It is therefore introduced into the game attribute as a foreign key When we develop the 3NF we ensure that there is no redundancy. The relationship between player and batting is one to many. This means that a player can play for only one team at a time. The relationship between a team and a player is many to one meaning that many players can batt. Marston, T. (2004, September 30). The Relational Data Model, Normalisation and effective Database Design. Retrieved February 27, 2015, from Tony Marston: