wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes First Normal Form Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "First Normal Form" Watch "First Normal Form" New topic

First Normal Form

Sameer Jamal
Ranch Hand

Joined: Feb 16, 2001
Posts: 1870
I am little bit confused about the first normal form well lets see what is the definition

According to Microsoft website

First Normal Form
� Eliminate repeating groups in individual tables.
� Create a separate table for each set of related data.
� Identify each set of related data with a primary key.

According to Databsae journal

� there are no repeating groups
� all the key attributes are defined
� all attributes are dependent on the primary key

Now suppose there is some data

So according to microsoft's definition the database will be in first normal form if we have following tables

Remember Create a separate table for each set of related data.
Identify each set of related data with a primary key.

But according to Databse journal's definition a database will be in First normal form if we have following single table.

Please clear me which is the first normal form.
[ February 22, 2006: Message edited by: Sameer Jamal ]
luceene works

Joined: Feb 22, 2006
Posts: 2
The Definition of 1NF says
"A relation is said to be in First Normal Form (1NF) if and only if each attribute of the relation is atomic. More simply, to be in 1NF, each column must contain only a single value and each row must contain the same columns."

Hence there are no related set and in 1NF we don't split data into separate tables to remove data redunducy.

So the description given in the database journal is correct.

Jeff Albertson
Ranch Hand

Joined: Sep 16, 2005
Posts: 1780
What, Microsoft is wrong?!
I agree. Here's the link: http://aspose.com/file-tools
subject: First Normal Form
It's not a secret anymore!