Normalization for an Efficient Database

Apr 30th, 2015
Studypool Tutor
Strayer University
Course: Information Technologies
Price: $10 USD

Tutor description

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.

Word Count: 724
Showing Page: 1/5
Normalization for an Efficient DatabaseByStrayer UniversityAugust 12, 2012Database 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

Review from student

Studypool Student
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1828 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors