Case Study on Data Model Normalization by Surveying Project

Basic objective of this case study is to analyze Data Model Normalization by Surveying Project. Database normalization is the process of organizing the fields and tables of the relational database to attenuate redundancy. Normalization generally involves dividing significant tables into smaller sized tables and defining relationships between these individuals. The objective would be to isolate data to ensure additions, deletions, and modifications of the field can be generated in just one table after which it propagated through all of those other database using the particular defined relationships. Basic objectives are normalize a logical data model to remove impurities that can make a database unstable, inflexible, and nonscalable.