The first normal form simply says that each cell of a table should contain exactly one value.

As you see, a tuple represents a registration that is done for a date.

• No multiple values in intersection of each row and column,
• No repeatable groups in attributes (like columns Course_1, Course_2, Course_3, ...),
• Order of attributes and tuples are insignificant, and
• No duplicate tuples in the relation.

You can see that Course attribute has multiple value that violates the 1NF.

One way to handle it without decomposing the relation is to reorganize the tuples.

Since the relation has no multiple values in intersections and no repeatable groups, it is now a 1NF relation.

◀ Previous

Slide 15.3: A simple example of database normalization Slide 15.5: Functional dependencies (FDs) Home         Print version

▶ Next

“If I had to live my life again,           I’d make the same mistakes, only sooner.           — Tallulah Bankhead