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. Transmute this board from 1NF to 3NF. Show your fruit. rojec rojec deal-out deal-outmer our Rate rojec ITm Designate No. Code tle ManagerBudget No. Designate 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. Transmute this board from 1NF to 3NF. Show your fruit. What are the 1^st, 2^nd and 3^rd NF?

    Expert Confutation

     

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

    1NF:

    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.