If you have an address field listing the city,state,and ZIP together such as Paterson,NJ 07501,you have violated the first normal form.

Question

Quizplus · Accepted Answer

In the first normal form, each attribute must have atomic values, which means that a field combining multiple values violates this condition. In this case, the city, state, and ZIP code should be separate fields to comply with the first normal form.

If You Have an Address Field Listing the City,state,and ZIP