Normalize Database

University:
American Baptist College
Course:
CSCI 1534 | Data Analysis and Visualization
Academic year:

2024
Views:

324

Pages:

1
Author:

Venesia A.

Normalize Database Database normalization or database normalization is the process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity. Normalization helps a database designer optimally distribute attributes into tables. The technique eliminates the following: 1. Attributes with multiple values. 2. Doubled or repeated attributes. 3. Non-descriptive attributes. 4. Attributes with redundant information. 5. Attributes created from other features. A. 1NF The first normal form requires that a table satisfies the following conditions: 1) Rows are not ordered 2) Columns are not ordered 3) There is duplicated data 4) Row-and-column intersections always have a unique value 5) All columns are “regular” with no hidden values B. 2NF The second normal form requires that a table satisfies the following conditions: 1) The table must be already in 1 NF and all non-key columns of the tables must depend on the PRIMARY KEY 2) The partial dependencies are removed and placed in a separate table C. 3NF The third normal form requires that a table satisfies the following conditions: 1) A Table is already in 2NF 2) Non-Primary key columns shouldn’t depend on the other non-Primary key columns 3) There is no transitive functional dependency