Define first normal form and second normal form, Database Management System

First Normal Form and second normal form

First Normal Form (1NF)

A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combination of values.

Second Normal Form (2NF)

A relation is said to be in 2NF f if it is already in 1NF and each attribute fully depends on the primary key of the relation. Speaking inversely, if a table has some attributes which is not dependant on the primary key of that table, and then it is not in 2NF.

 

Posted Date: 7/26/2013 6:37:55 AM | Location : United States







Related Discussions:- Define first normal form and second normal form, Assignment Help, Ask Question on Define first normal form and second normal form, Get Answer, Expert's Help, Define first normal form and second normal form Discussions

Write discussion on Define first normal form and second normal form
Your posts are moderated
Related Questions
why are older data models are being replaced by new data models

Briefly describe the different kinds of users of a DBMS.  Ans: Different sorts of DBMS users are: (a)  Software Engineers: These are the people accountable for developing ap

Explain the uses of deadlock It will lead to deadlock since this is the only place where incoming acknowledgements are processed. Without this code, sender will keep timing ou

Why were functional methods fashionable in early days? These are inspired directly by computer architecture and thus popular among computer scientist in early days. The divisio

Exclusive lock It is asked for by a transaction on a data item that it wants to update. No other transaction can put either a shared lock or an exclusive lock on a dat

How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul

construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six C. eigh

Explain the concept of deadlock Yes. It can direct to deadlock. Suppose that a batch of frames arrived correctly and were accepted. Then receiver will advance its window. Now s

Explain ODBC? ODBC - Open DataBase Connectivity (ODBC) enable the integration of SQL along with a general-reasons programming language.

Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on