The first normal form (1nf), Database Management System

The First Normal Form (1NF)

Let us first describe 1NF:

Definition: A relation (table) is in 1NF if

1.      There are no duplicate tuples or rows in the relation.

2.      Every data value stored in the relation is one-valued

3.      Entries in a column (attribute) are of the similar kind (type).

Please note that in a 1NF relation the order of the attributes (columns) and tuples (rows) does not matter.

The first necessity above means that the relation must have a key. The key may be one attribute or composite key. It may even, possibly, have all the columns. The first normal form describes only the basic structure of the relation and does not determine the anomalies.


Posted Date: 3/7/2013 1:55:03 AM | Location : United States

Related Discussions:- The first normal form (1nf), Assignment Help, Ask Question on The first normal form (1nf), Get Answer, Expert's Help, The first normal form (1nf) Discussions

Write discussion on The first normal form (1nf)
Your posts are moderated
Related Questions
List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements  c) Finding the loops  d) Finding error ro

The definition of the classes and operation can often be adjusted to increase the amount of inheritance". Justify the above statement.   Adjustment of Inheritance The def

#ques Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a p

Primary index A primary index is a file that has a sorted series of records having two columns: a block address for that key field in the data file; and the ordering key field.

under what condition log based recovery is feasible?

Can we delete data element, which is being used by table fields. No we cant delete data element.

Ask questioYou are the database administrator in a university. You have been tasked to come up with a new database for the University. Using the stages in Database Life Cycle come

State the Component Diagram A component diagram represents a set of component and relationships among them. In a dynamic model, component diagram is used to model physical com

For your chosen project, you need to identify the current problem that you wish your project to solve.  Produce a Problem Statement.  The Problem Statement should explain the purpo

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th