-- violation2.txt

1NF is followed throughout the schema.

There are many possible places where 2NF is not followed:

-The same reasoning about STATE and ZIP may be applied to CITY and ZIP, AREA_CODE and ZIP, and so on; so long as a person can determine the CITY, AREA_CODE, or other 
attribute value given just the ZIP. This appears in the PERSON, STORE, and VENDOR tables.

-SALES_TAX_RATE in the STORE table may also be a violation of 2NF, if it can be determined solely from the address.
-
There may be others...

3NF is also not followed in many places:

- 2NF is required for 3NF, so any place that does not follow 2NF also does not follow 3NF.
- The ACCOUNT table has addresses that do not include a ZIP attribute. In this case, it follows 2NF, but does not follow 3NF ? multiple accounts can refer to the same shipping address, but the shipping address will be duplicated in the table.
- There may be others...
