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
How can Redundant Associations be done It can be done by asking questions: i)  Is there a specific arrangement of network which would optimize critical aspects of completed


What are the uses of ODBC? Under what circumstances we use this technology? ODBC expose database capabilities within a standardized way to the application programmer by an ap

What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec

Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca

The cross-section of twisted pair The cross-section of each and every strand of the twisted pair is π/4 square mm. A 10-km length of this type of material, with two strands per

What is NULL? Simply NULL means not in value.

The Database administrator (DBA) uses the data dictionary in each phase of a database life cycle, beginning from the data gathering phase to the design, execution and maintenance p

What is Disadvantages Of DBMS ? 1. Cost of Software and Hardware and Migration - A important disadvantage of the DBMS system is cost. 2. Reduced Response and Throughpu

Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi