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 consideration is un-normalized create. Transshape this consideration from 1NF to 3NF. Show your exertion. rojec rojec disunite disunitemer our Rate rojec ITm Cintegral No. Manage tle ManagerBudget No. Cintegral 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 consideration is un-normalized create. Transshape this consideration from 1NF to 3NF. Show your exertion. What are the 1^st, 2^nd and 3^rd NF?

    Expert Confutation

     

    The Given Consideration is already in 1NF; which has no multiple prizes in any cell

    1NF:

    In ordain to transshape to 2NF we deficiency to rive the consideration into multiple considerations which does has singly authoritative dependancy on singly the principal solution;

    Now the consideration became 2 NF

    And the consideration is so 3NF which doesn’t had any multi prized mark.

    1NF: A consideration is in 1st Normal create if it doesn’t keep any multivalued mark, composite mark or its co-operation in the corresponding basis estate, in the aloft consideration any cell doesn’t embrace a multi prize which resources it is in 1NF.

    2NF: A consideration meets 2NF when the 1NF requirement is met , and full marks ate the principal solution keep authoritative dependency perfectly to the principal solution. In the aloft consideration plan cintegral depends on plan no; and province cintegral depends on province no; so we can rive the considerations into Plan, Employee, Province with the Principal solutions Plan manage, Employee no and Province no.

    3NF: In ordain to the consideration to be 3NF it has be 1NF, 2NF. full the marks in a consideration are unshaken singly by the canvasser solutions of that relevancy and referable by any non-prime marks. For Example the cintegral support embraces fname, lcintegral ,and mname, in 3NF the fullCintegral support in rive into 3 supports. Therefore this consideration is in 3NF.