Interested to Buy Any Domain ? << Click Here >> for more details...
what is Normalization means..?
- 8 Answers
- 32542 Views
- AZTEC, Bank Of America, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / nitin bisht
NORMALIZATION: The process of structuring data to minimise
duplication and inconsistencies. The process usually
involves breaking down a single table into two or more
tables and defining relationships between those tables.
Normalisation is usually done in stages, with each stage
applying more rigourous rules to the types of information
which can be stored in a table. While full adherence to
normalisation principles increases the efficiency of a
particular database, the process can become so esoteric that
you need a professional to create and understand the table
design. Most people, when creating a database, don't need to
go beyond the third level of normalisation, called third
normal form. And there's no need to know the terminology:
simply applying the principles is sufficient.
The first three levels in normalising a database are:
First Normal Form (1NF): There should be no repeating groups
in a table.
For example, say you have a students table with the
following structure:
student ID
name
date of birth
advisor
advisor's telephone
student
course ID 1
course description 1
course instructor 1
course ID 2
course description 2
course instructor 2
The repeating course fields are in conflict with first
normal form.To fix the problems created by such repeating
fields, you should place the course information in a
separate course table, and then provide a linking field
(most likely student ID) between the students table and the
course table.
Second Normal Form (2NF): No non-key fields may depend on a
portion of the primary key.
For example, say we create a course table with the structure:
student ID
course ID
course description
course instructor
We can create a unique primary key by combining student ID +
course ID (student ID is not unique in itself, as one
student may take multiple courses; similarly, course ID is
not unique in itself as many students may take the same
course; however, each student will only be taking a
particular course once at any one time, so the combination
of student ID + course ID gives us a unique primary key).
Now, in 2NF, no non-key fields (course description, course
instructor) may depend on a portion of the primary key.
That, however, is exactly what we have here: the course
instructor and course description are the same for any
course, regardless of the student taking the course.
To fix this and put the database in second normal form, we
create a third table, so our database structure now looks
like this (with key fields in italics):
Student table
student ID
name
date of birth
advisor
advisor's telephone
Student courses table
student ID
course ID
Courses table
course ID
course description
course instructor
Third Normal From (3FN): No fields may depend on other
non-key fields. In other words, each field in a record
should contain information about the entity that is defined
by the primary key.
In our students table, for example, each field should
provide information about the particular student referred to
by the key field, student ID. That certainly applies to the
student's name and date of birth. But the advisor's name and
telephone doesn't change depending on the student. So, to
put this database in third normal form, we need to place the
advisor's information in a separate table:
Student table
student ID
name
date of birth
advisor ID
Student courses table
student ID
course ID
Courses table
course ID
course description
course instructor
Advisor table
advisor ID
advisor name
advisor telephone
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
What is aws documentdb?
What is odm database?
Should I store images in database?
What is meant by distributed system?
What are different types of blocks used in stored procedure?
how node connect with cpu?
What happens when shared and exclusive locks are applied on data item?
Can you tell any two advantages of stored procedures?
What is database schema name?
What is a database connection string?
what is the full procedure for using store procedure in informatica7.1?
How to produce such kind of file?
How much does it cost to build a database?
