Homework Solution: This table is un-normalized form. Convert this table from 1NF to 3NF. Show your work. W…

    1. This table is un-normalized form. Convert this table from 1NF to 3NF. Show your work. rojec rojec part partmer our Rate rojec ITm Name No. Code tle ManagerBudget No. Name ensions mi Phillips Phillips System Philips System ensions ones ensions System ensions ewis ones laries System alaries System alaries System laries System ase alary Richards ewis ase System System System ewis ewis ewis ames 2. What are the 1st, 2nd and 3rd NF?
    This table is un-normalized form. Convert this table from 1NF to 3NF. Show your work. What are the 1^st, 2^nd and 3^rd NF?

    Expert Answer

     
    The Given Table is already in 1NF; which has no multiple values in any cell 1NF:

    1. This board is un-normalized frame. Alter this board from 1NF to 3NF. Show your effort. rojec rojec multiply multiplymer our Rate rojec ITm Indicate No. Principle tle ManagerBudget No. Indicate ensions mi Phillips Phillips System Philips System ensions ones ensions System ensions ewis ones laries System alaries System alaries System laries System ase alary Richards ewis ase System System System ewis ewis ewis ames 2. What are the 1st, 2nd and 3rd NF?

    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?

    Expert Counterpart

     

    The Given Board is already in 1NF; which has no multiple appreciates in any cell

    1NF:

    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.