Abstract
This chapter reveals that the description of tuning database model is incomplete without the description of normalization. Normalization is the sequence of steps by which a relational database model is both created and improved upon. The sequence of steps involved in the normalization process is called normal forms. Tuning of a database installation, and particularly, making SQL coding perform well, is heavily dependent on effective entity design. Relational database modeling eliminates what are called anomalies from occurring in a database. Anomalies can potentially occur during changes to a database. An anomaly is a bad thing because data can become logically corrupted. An anomaly, with respect to relational database design, is essentially an erroneous change to data, more specifically to a single record. Normalization is for the most part easy, and largely common sense, with some business knowledge experience thrown in. Application of the relational database model to a data set involves the removal of duplication, which is performed using a process called normalization. Normalization consists of a set of rules called Normal Forms. Normalization is applied to a set of data in a database to form entities.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
