DB2 11 - Normalization concept in DB2

DB2 11 - Normalization concept in DB2

23:21

Normalization : Arranging the data in the Database in an organized manner.  
  •      1 Normalization (1NF) 
  •      2 Normalization (2NF)  
  •      3 Normalization (3NF) 
1NF:
  •      Avoiding multiple values or set of values in one column.
2NF:
  • It is to avoid duplicate rows based on column, it can be eliminated by defining a primary key (PK).
  • A Primary Key is a uniquely identified row, doesn’t contain any Null Values and Duplicate Rows.
  • Primary key can consist of single (or) Multiple columns. Only one primary key should be created for one table and every table should be defined with primary key.
3NF:
  • It is to build relationship with two objects i.e. relationship can be build by defining a foreign key (FK), which is already a primary key of another table.
  •  Multiple foreign keys are defined on one table to have a relationship with multiple tables.
  •  FK can contain NULL/duplicate rows. 
  • FK can contain single/multiple columns.
                        

Next
« Prev Post
Previous
Next Post »
Subscribe to: Post Comments (Atom)