| National Park Service System | Normalization Summary | Thurmond Burdette
4-14-2015
|

In this summary you will understand the importance of normalization for this project. Normalization is the process the team used to efficiently organize data within the database. The goal of this process is to remove repeated data such as storing the same data in more than one table, and ensuring data dependencies. The ultimate goals of the normalization process ensures that redundancy is reduced and that data is organized so that it is relatable, decreases database space allowing the data to be understood.
The NPS (National Park Service) has contracted with our organization to track data of visitation to all 51 of their parks which have recently experienced an increase in visitation. The data will reflect how work load demand and distribution affect funding and salary increases going forward. Presently utilizing Microsoft Access the NPS has used this relational database to keep data up to date and would like our analysts to create a “back-end” process for the system currently being used.
The Normalization Process streamlines the above process by using guidelines that begins with the lowest form up to the fifth normal form. The first and second normal form sets a framework for the data to be organized and addresses duplication of data. The data tables in these two steps are organized independently and clearly identifiable. The Second normal form expands the first form by getting rid of data, eliminating duplication and organizing rows of data along with relationship creation using the foreign keys. In the third normal form all of the above requirements have been met and the columns not depending on the primary keys will be removed.
In the Summary the team utilized steps that ensured the normalization phases were organized maximizing