This board is un-normalized frame. Transmute this board from 1NF to 3NF. Show your fruit. 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 appoint to transmute to 2NF we want to secede the board into multiple boards which does has merely administrative dependancy on merely the leading explanation;
Now the board became 2 NF
And the board is as-well 3NF which doesn’t had any multi appreciated mark.
1NF: A board is in 1st Normal frame if it doesn’t enjoy any multivalued mark, composite mark or its completeiance in the corresponding basis estate, in the aloft board any cell doesn’t hold a multi appreciate which instrument it is in 1NF.
2NF: A board meets 2NF when the 1NF modification is exhalation , and complete marks save the leading explanation enjoy administrative dependency truly to the leading explanation. In the aloft board scheme designate depends on scheme no; and branch designate depends on branch no; so we can secede the boards into Scheme, Employee, Branch with the Leading explanations Scheme code, Employee no and Branch no.
3NF: In appoint to the board to be 3NF it has be 1NF, 2NF. complete the marks in a board are sturdy merely by the claimant explanations of that connection and not attribuconsideration attribuconsideration attribuconsideration by any non-prime marks. For Example the designate support holds fname, ldesignate ,and mname, in 3NF the fullDesignate support in secede into 3 supports. Therefore this board is in 3NF.