What is level of normalization HR Oracle Sample Database?

104 views Asked by At

https://docs.oracle.com/cd/E11882_01/server.112/e40540/tablecls.htm#CNCPT88804

Is it third normal form or maybe fourth normal form ? I know that mostly database have only third normal form.

1

There are 1 answers

0
David Aldridge On

Based on the LOCATION having a STATE_REGION column in it, as well as a COUNTRY_ID, I'd say that it fails the test for second normal form because the same STATE_COUNTRY could be associated with multiple countries through an error in updating the table.