Database Normalization means that we are going to create a database table of fixed columns and changeable rows for a single purposes.
Therefore, there is no need to build up a single table with multiple purposes which it will end up really hard to insert, select, delete or even update any certain rows.
Lets take a look for this following table which includes a salesperson information and their customers.
As you can see the figures above, the table has three purposes where we can separate them into three tables as follows:
- Information of salesperson.
| EmployeeID# | SalesPerson | SalesOffice | Customers |
|---|---|---|---|
| 1 | Abdulrahman | Amman | Mersedes |
- The offices location and contact info.
| ID# | Location | ContactOffice |
|---|---|---|
| 1 | Amman | 065554444 |
- 3The customer and their contacts info.
| ID# | Customers | ContactOffice |
|---|---|---|
| 1 | Mersedes | 065554433 |
The reference of this markdown from the following link.