Describe about first three Normal forms.

Answer Posted / arun anoop m

1)1NF
->it has a primary key.
->Each column is atomic.
2)2NF
->It is in 1NF
-> Every non-key column is fully functinally dependend on
primary key.
3)3NF
->It is in 2NF
->Every non-key column is functinally dependend only on
primary key.
->non-key column cant be dependend on another non-key colum.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are transactions in sql?

558


How to download and install microsoft .net framework version 2.0?

556


Explain about Views?

609


How many types of cursor type are there?

593


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1534






Explain the phases a transaction has to undergo?

560


what is a join and explain different types of joins? : Sql server database administration

544


What are number line correlation administrators will use while working with a subquery?

631


Explain Geometry datatype in sql server 2008 with example

596


How to check status of stored procedure in sql server?

454


What is the default fill factor value?

592


What are the restrictions that views have to follow? : SQL Server Architecture

540


How can a database be repaired?

572


What are the system database in sql server 2008?

584


how can you attach more than 20 ldf files in sql server

1577