First Normal Form (1NF)

A table is said to be in the 1 NF when each cell of the table contains precisely one valid.

Consider the following table PROJECT.

PROJECT

untitled

The data in the table is not normalized because the cells in PRJCODE and HOURS have more than one value.

By applying the 1NF definition to the PROJECT table, you arrive at the following table :

PROJECT

untitled 1

This entry was posted in Computer and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>