The Importance of Database Design and Normalization Process

Database management systems are major tools which provide management of or­ganizations’ operational data via computers. However their efficient usage de­pends on how well database tables are organized. When undesigned data is sto-red in the database there probably occur some problems such as data re...

Full description

Saved in:
Bibliographic Details
Main Author: Tülay Fenerci
Format: Article
Language:English
Published: Türk Kütüphaneciler Derneği (Turkish Librarians' Association) 2014-05-01
Series:Türk Kütüphaneciliği
Subjects:
Online Access:http://tk.org.tr/index.php/TK/article/view/666
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Database management systems are major tools which provide management of or­ganizations’ operational data via computers. However their efficient usage de­pends on how well database tables are organized. When undesigned data is sto-red in the database there probably occur some problems such as data repeating and waste of storage space. In order to prevent such problems a normalization process is applied to tables.Normalization is a process of refining relations where relations are formed by gathering attributes. Hence problems such as repeating of data, dependency and combined relationships are solved with normalized base tables.Therefore database design is an important fact in efficiency of database ma­nagement systems.
ISSN:1300-0039
2147-9682