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 consultation is un-normalized shape. Appropriate this consultation from 1NF to 3NF. Show your toil. rojec rojec multiply multiplymer our Rate rojec ITm Indicate No. Jurisprudence 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 consultation is un-normalized shape. Appropriate this consultation from 1NF to 3NF. Show your toil. What are the 1^st, 2^nd and 3^rd NF?

    Expert Counterpart

     

    The Given Consultation is already in 1NF; which has no multiple esteems in any cell

    1NF:

    In direct to appropriate to 2NF we want to disagree the consultation into multiple consultations which does has simply functional dependancy on simply the chief solution;

    Now the consultation became 2 NF

    And the consultation is to-boot 3NF which doesn’t had any multi esteemd indication.

    1NF: A consultation is in 1st Normal shape if it doesn’t bear any multivalued indication, composite indication or its concert in the similar basis territory, in the aloft consultation any cell doesn’t include a multi esteem which instrument it is in 1NF.

    2NF: A consultation meets 2NF when the 1NF capacity is expiration , and full indications bar the chief solution bear functional dependency completely to the chief solution. In the aloft consultation contrivance indicate depends on contrivance no; and division indicate depends on division no; so we can disagree the consultations into Contrivance, Employee, Division with the Chief solutions Contrivance jurisprudence, Employee no and Division no.

    3NF: In direct to the consultation to be 3NF it has be 1NF, 2NF. full the indications in a consultation are fast simply by the canvasser solutions of that agreement and referable by any non-prime indications. For Example the indicate post includes fname, lindicate ,and mname, in 3NF the fullIndicate post in disagree into 3 posts. Therefore this consultation is in 3NF.