Normal Forms
Tables need to follow a set of numbered rules known as “normal form.” (It's “normal” in the sense of “normalized” or conforming to a standard). First normal form says that all attributes must be atomic. That means there can be no lists of items in an attribute. You can't have an attribute that is “contents of a shopping cart,” because that could contain several items. Atomic means “only one, and it cannot be subdivided any further.”
Second normal norm
Second normal form says that it is in first normal form (atomic) and every non-key attribute depends fully on the key. The Person table has non-key attributes of “age” and “lives in” and both of these are completely dependent on the person we are identifying by the “name” attribute. ...
Get Just Java™ 2 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
