First Normal Form (1NF)

Below is a simple 1NF Database.

FirstName	LastName	Middle Initial	Street	City	State	ZipCode	Prof	Dept
Joe	Momma	Y	123 Foo Lane	Columbus	Ohio	43235	Joe Torre	CS

Below is a similar example, but this being of 0NF; or that of an Exel spreadsheet. This is the kind of nonsense that I had to work with once I began my Web Development career.

FirstName	LastName	MiddleName	FullName	Street	City	State	ZipCode	Address	Prof	Dept
Joe	Momma	Y	Joe Yo Momma	123 Foo Lane	Columbus	Ohio	43235	123 Foo Lane Columbus, Ohio 43235	Joe Torre	CS

Updated: Dec. 24, 2004; Joe Gakenheimer