This Thanksgiving, give a precious gift to your career by upgrading your skills. | Get Flat 15 - 20% OFF on All Courses | Save Today

[iqquestion id=18]

6 thoughts on “Database : Normalization Discussion 2

  • Pamela halbhavi

    Database normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like insertion, update and deletion anomalies. It is a multistep process that puts data into tabular form by removing duplicated data from the data table.
    Process of reducing tables to set of columns where all non key columns depend on the primary column

    Normalization is mainly used for
    • Eliminating Redundant (useless) data
    • Ensuring data dependencies make sense ie data is logically stored

  • Pamela halbhavi

    Sorry that was the answer for what is Normalization

  • nasir

    Tough quetsion

  • nasir

    This process of specifying and defining tables, columns, rows, and relationships in order to create an efficient database is called normalization. Normalization is part of successful database design. Without normalization, database systems can be inaccurate, slow, and inefficient and they might not produce the data we expect. The actual guidelines of normalization called forms: 1NF, 2NF, 3NF and BCNF.

  • Olubunmi Ogunsola

    Developers use normalization to design easily useable databases while maintaining integrity and eliminating redundancy. A normal form is a procedure used to keep integrity
    – Tomiwa

  • sivi ramesh

    Basically, normalization is the process of efficiently organising data in a database. BY arranging data into logical groups such that each group describes a small part of the whole and minimizing the amount of duplicated data stored in a database, it ensures data redunduncy.By ensuring data is recorded exactly as intended , data integrity is maintained.

Leave a Reply