Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    Normalization

    Uploaded by

    G Guru
    Normalization is the process of organizing data in a database to minimize redundancy and dependency. It divides tables into smaller, linked tables and establishes relationships to eliminate anomalies like insertion, update, and deletion inconsistencies. Normalization results in a flexible, consistent database structure with advantages like reduced data redundancy and relational integrity, though it can degrade performance and require significant time.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Normalization

    Uploaded by

    G Guru
    18 views20 pages
    Normalization is the process of organizing data in a database to minimize redundancy and dependency. It divides tables into smaller, linked tables and establishes relationships to eliminate anomalies like insertion, update, and deletion inconsistencies. Normalization results in a flexible, consistent database structure with advantages like reduced data redundancy and relational integrity, though it can degrade performance and require significant time.

    Original Title

    Normalization (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Normalization is the process of organizing data in a database to minimize redundancy and dependency. It divides tables into smaller, linked tables and establishes relationships to eliminate anomalies like insertion, update, and deletion inconsistencies. Normalization results in a flexible, consistent database structure with advantages like reduced data redundancy and relational integrity, though it can degrade performance and require significant time.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    18 views20 pages

    Normalization

    Uploaded by

    G Guru
    Normalization is the process of organizing data in a database to minimize redundancy and dependency. It divides tables into smaller, linked tables and establishes relationships to eliminate anomalies like insertion, update, and deletion inconsistencies. Normalization results in a flexible, consistent database structure with advantages like reduced data redundancy and relational integrity, though it can degrade performance and require significant time.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 20

    Normalization

    • Normalization is the process of organizing the data in the database.


    • Normalization is used to minimize the redundancy from a relation or
    set of relations. It is also used to eliminate undesirable characteristics
    like Insertion, Update, and Deletion Anomalies.
    • Normalization divides the larger table into smaller and links them
    using relationships.
    • The normal form is used to reduce redundancy from the database
    table.
    • Why do we need Normalization?
    • The main reason for normalizing the relations is removing these
    anomalies. Failure to eliminate anomalies leads to data redundancy
    and can cause data integrity and other problems as the database grows.
    Normalization consists of a series of guidelines that helps to guide you
    in creating a good database structure.
    • Data modification anomalies can be categorized into three types:
    • Insertion Anomaly: Insertion Anomaly refers to when one cannot
    insert a new tuple into a relationship due to lack of data.
    • Deletion Anomaly: The delete anomaly refers to the situation where
    the deletion of data results in the unintended loss of some other
    important data.
    • Updatation Anomaly: The update anomaly is when an update of a
    single data value requires multiple rows of data to be updated.
    • Advantages of Normalization
    • Normalization helps to minimize data redundancy.
    • Greater overall database organization.
    • Data consistency within the database.
    • Much more flexible database design.
    • Enforces the concept of relational integrity.
    • Disadvantages of Normalization
    • You cannot start building the database before knowing what the user needs.
    • The performance degrades when normalizing the relations to higher normal
    forms, i.e., 4NF, 5NF.
    • It is very time-consuming and difficult to normalize relations of a higher
    degree.
    • Careless decomposition may lead to a bad database design, leading to
    serious problems.

    You might also like