DATA PROCESSING SSS2 FIRST TERM           

WEEK 7

NORMAL FORM

Contents

A database management system is a collection of computer software that enables users to define, create and maintain a database. Defining a database involves specifying constraints for the data stored in the database, and normalization is a logical design method which minimizes duplicate, or redundant, data and design flaws. Normalization is the process of effectively organizing data in a database. The primary purpose of normalization is to allow the update, insert and delete operations to be performed on a single database table and propagated throughout the database by means of the defined relationship.

There are two goals of the normalization process:

1. Eliminating redundant data ( for example storing the same data in more than one table)

2. Ensuring data dependencies make sense (only storing related data in a table)

EVALUATION

1. Define Normalization.

View More