First Normal Form

According to first normal form table should contain only single values columns.But in the above mentioned un-normalized table see this:http://sqlserver-guide.blogspot.com/2009/04/normalization.html
the columns ProjNo and PName contain multiple values.

To make the table into first normal form we should have to split the multiple values into single values

EmpNo:11
ProjNo:p1
EName:----
PName:Pn1
Sal:----
Bud:-----
DeptNo:10
DName:--------
Loc:------
Share/Bookmark

No comments: