Welcome to Read: 14a
Database Normalization
In this Read: 14a, I will talk about this topic:
- Database Normalization.
Database Normalization
Database normalization is a process used to organize a database into tables and columns. The main idea with this is that a table should be about a specific topic and only supporting topics included.
-
Reasons for Database Normalization
- There are three main reasons to normalize a database. The first is to minimize duplicate data, the second is to minimize or avoid data modification issues, and the third is to simplify queries.
- There are three main reasons to normalize a database. The first is to minimize duplicate data, the second is to minimize or avoid data modification issues, and the third is to simplify queries.
-
Data Duplication and Modification Anomalies
- Notice that for each SalesPerson we have listed both the SalesOffice and OfficeNumber. There are duplicate salesperson data. Duplicated information presents two problems:
- It increases storage and decrease performance.
- It becomes more difficult to maintain data changes. </span>
- It increases storage and decrease performance.
- Notice that for each SalesPerson we have listed both the SalesOffice and OfficeNumber. There are duplicate salesperson data. Duplicated information presents two problems:
-
Search and Sort Issues
- The last reason we’ll consider is making it easier to search and sort your data.
- The last reason we’ll consider is making it easier to search and sort your data.
-
Definition of Database Normalization
- There are three common forms of database normalization: 1st, 2nd, and 3rd normal form. They are also abbreviated as 1NF, 2NF, and 3NF respectively. There are several additional forms, such as BCNF, but I consider those advanced, and not too necessary to learn in the beginning.
The forms are progressive, meaning that to qualify for 3rd normal form a table must first satisfy the rules for 2nd normal form, and 2nd normal form must adhere to those for 1st normal form. Before we discuss the various forms and rules in detail, let’s summarize the various forms:
- First Normal Form – The information is stored in a relational table with each column containing atomic values. There are no repeating groups of columns.
- Second Normal Form – The table is in first normal form and all the columns depend on the table’s primary key.
- Third Normal Form – the table is in second normal form and all of its columns are not transitively dependent on the primary key
</span>
- First Normal Form – The information is stored in a relational table with each column containing atomic values. There are no repeating groups of columns.
- There are three common forms of database normalization: 1st, 2nd, and 3rd normal form. They are also abbreviated as 1NF, 2NF, and 3NF respectively. There are several additional forms, such as BCNF, but I consider those advanced, and not too necessary to learn in the beginning.
For further infromation please click here.
| Read | Title | ToGo |
|---|---|---|
| Read: 01 | SMACSS and Responsive Web Design |  |
| Read: 02 | jQuery, Events, and The DOM | |
| Read: 03 | Flexbox and Templating | |
| Read: 04 | Responsive Web Design and Regular Expressions | |
| Read: 05 | Heroku Deployment | |
| Read: 06 | Node, Express, and APIs | |
| Read: 07 | APIs continued | |
| Read: 08 | SQL | |
| Read: 09 | Refactoring | |
| Read: 10 | The Call Stack and Debugging | |
| Read: 11 | EJS | |
| Read: 12 | Components | |
| Read: 13 | Update/Delete | |
| Read: 14a | DB Normalization | |
| Read: 15 | Diversity and Inclusion | |