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

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?

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

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.