jQuery in Action, 2nd edition*
The moose likes JDBC 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
Bookmark "First Normal Form" Watch "First Normal Form" New topic
Author

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

http://support.microsoft.com/default.aspx?scid=kb;en-us;283878
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
http://www.databasejournal.com/sqletc/article.php/26861_1474411_4

� 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
Greenhorn

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.

Cheers
Jeff Albertson
Ranch Hand

Joined: Sep 16, 2005
Posts: 1780
What, Microsoft is wrong?!
 
wood burning stoves
 
subject: First Normal Form
 
Similar Threads
Constructor Problem
Search pages shows only limited no. of rows
Nested while loop inside do...while loop?
Encrypt Passwords readObject error
technical exams