Normal Form

Back to: DATA PROCESSING SS 2

 

Welcome to class! 

In today’s class, we will be talking about normal form. Enjoy the class!

Normal Form

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 using 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)

The normal form (NF) of relational database theory provide critical for determining a table’s degree of vulnerability to logical inconsistencies and anomalies. The higher the normal form applicable to a table, the less vulnerable it is. Each table has a “Highest Normal Form” (HNF): by definition, a table always meets the requirements of its HNF and all normal forms lower than its HNF; also by definition, a table fails to meet the requirement of any normal form higher than its HNF.

Normal form theory deal with how to reduce the amount of redundancy of data within a given table. Each normal form represents a level. To satisfy each the requirements for a certain level, the requirements for the previous level must be met. To reach the optimal normal form for the tables within a database, the creator starts with a large list of all the data that is to be held in the database and then works through the normal forms until he can no longer break the data down into the smaller table.

 Evaluation

1. Define Normalization.
2. Define Database Management System.

General evaluation

1. Explain Normal Form.
2. State the two goals of the normalization process.

Weekend assignment

Instruction: Choose the correct option from the ones lettered A to D

1. ____ is a collection of computer software that enables users to define, create and maintain a database. (a) Database Management System (b) Normalization(c) Data Model (d) Normal Form
2. ____ is the logical design method which minimizes duplicate or redundant data and design flaws. (a) Database  (b) Normalization   (c) Form   (d) Data Model
3. One of the goals of the normalization process is ____ (a) Eliminate redundant data (b) Ensure data independencies (c) Allow Update, insertion and deletion (d) Create tables
4. The primary purpose of normalization is to ____ (a) Eliminate redundant data (b) Ensure data dependencies (c) Allow Update, insertion and deletion (d) Create tables
5. ____ is the process of efficiently organizing data in a database. (a) Database (b) Normalization   (c) Form   (d) Model

 

In our next class, we will be talking more about Normal Form.  We hope you enjoyed the class.

Should you have any further question, feel free to ask in the comment section below and trust us to respond as soon as possible.

For more class notes, homework help, exam practice, download our App HERE

Join ClassNotes.ng Telegram Community for exclusive content and support HERE