Access over 20 million homework & study documents

Normalization for an Efficient Database

Content type
User Generated
Type
Note
Rating
Showing Page:
1/5
Running Head: NORMALIZATION FOR AN EFFICIENT DATABASE
1
Normalization for an Efficient Database
By
Strayer University
August 12, 2012

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5
Running Head: NORMALIZATION FOR AN EFFICIENT DATABASE
2
Database normalization is a process by which data is efficiently organized in a database. The
two most important goals of a normalization process are:
1> Eliminating redundancy: Eliminating redundant data as redundant or unnecessary data
takes more and more space and creates maintenance problem in the database. So if data
exists in more than one place in the database it must be changed as disk space is wasted.
While making these changes it must be ensured that the data is changed exactly the same
way in all locations of the table so that the database does not get corrupt.
2> Data dependency: A dependency occurs in a database when information stored in the
same table uniquely determines the other information in the table. It can also be described
as an attribute where knowing the value of one attribute is sufficient to determine the value
of another attribute. Data dependencies can make data easier to access and it is much easier
to find the path of data. Inconsistent dependencies cause a lot of problem in retrieving data
of a particular item.
The main benefits that the company will obtain of normalization are:
Database operations like sorting, searching and creating indexes are much faster.
Index searching is also faster as the indexes are shorter and narrower.
The number of tables increases allowing for better use of segments to control the
physical placement of data.
Faster data modification commands.
As redundant data is not there triggers execute faster.
Database is more compact as there are fewer null values and less redundant data.
The main disadvantages of normalization are:

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now
Unformatted Attachment Preview
 Normalization for an Efficient Database By Strayer University August 12, 2012 Database normalization is a process by which data is efficiently organized in a database. The two most important goals of a normalization process are: 1> Eliminating redundancy: Eliminating redundant data as redundant or unnecessary data takes more and more space and creates maintenance problem in the database. So if data exists in more than one place in the database it must be changed as disk space is wasted. While making these changes it must be ensured that the data is changed exactly the same way in all locations of the table so that the database does not get corrupt. 2> Data dependency: A dependency occurs in a database when information stored in the same table uniquely determines the other information in the table. It can also be described as an attribute where knowing the value of one attribute is sufficient to determine the value of another attribute. Data dependencies can make data easier to access and it is much easier to find the path of data. Inconsistent dependencies cause a lot of problem in retrieving data of a particular item. The main benefits that the company will obtain of normalization are: Database operations like sorting, searching and creating indexes are much faster. Index searching is also faster as the indexes are shorter and narrower. The number of tables increases allowing for better use of segments to control the physical placement of data. Faster data ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4