This board is un-normalized frame. Alter this board from 1NF to 3NF. Show your effort. What are the 1^st, 2^nd and 3^rd NF?
The Given Board is already in 1NF; which has no multiple appreciates in any cell
In command to alter to 2NF we demand to sunder the board into multiple boards which does has merely negotiative dependancy on merely the leading solution;
Now the board became 2 NF
And the board is so 3NF which doesn’t had any multi appreciated mark.
1NF: A board is in 1st Normal frame if it doesn’t keep any multivalued mark, composite mark or its concert in the identical facts territory, in the aloft board any cell doesn’t comprise a multi appreciate which resources it is in 1NF.
2NF: A board meets 2NF when the 1NF modification is life , and complete marks bar the leading solution keep negotiative dependency perfectly to the leading solution. In the aloft board purpose indicate depends on purpose no; and portion indicate depends on portion no; so we can sunder the boards into Purpose, Employee, Portion with the Leading solutions Purpose principle, Employee no and Portion no.
3NF: In command to the board to be 3NF it has be 1NF, 2NF. complete the marks in a board are rooted merely by the applicant solutions of that kinsman and referable by any non-prime marks. For Example the indicate post comprises fname, lindicate ,and mname, in 3NF the fullIndicate post in sunder into 3 posts. Therefore this board is in 3NF.