As the Chief Information Officer, I am mandated with developing a summary of normalizing tables to be used in the upcoming training session.
Converting First Normal to Third Normal stepsNormalizing a database involve the process of organizing attributes in a database model to increase cohesion and reduce redundancy. Storing information in a database which are exhibited in more than one location is a challenging task. Thus, data is normalized so that each table contains a distinct set of data different from others. Normalization from 1NF, 2NF to 3NF is guided by rules. The first normal form is guided by three rules; eliminate repeating attributes in Continue reading...