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
Data Base Management System 1. Draw the Architecture of MySQL and explain about its subsystems briefly. 2. Elaborate with the help of an example the concept of Primary key a

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

create an er diagram for production management in film industry

Explain concept of inheritance with support of suitable example. Inheritance Inheritance is one of milestone of object-oriented programming language as it allows a creati

Develop Database academic assignment Project Description: For a provided set of instructions in a case study design Entity Relationship Diagram. - Entity Relationship Diag

please give me introduction to full data in D B M S in a short assignment

Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following

I am going to develop a web site to present decision tree structure. For this, I want a web application with AJAX technology to connect the database and prepare the decision tree's


What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.