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
What is a Built-in A notation of identity is built-into the data model or programming language and no user-supplied identifier is needed. This form of identity is used in objec

To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.

Describe the nested-loop join and block-nested loop join.   Ans:   The block nested- loop join algorithm is as described below:     for every block B r of relation R do beg

Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela

Explain Instance and schemas? Instances and schemas: Databases changes over time as the information is deleted and inserted. The collection of information stored in database

Write the C++ program having class name studentinfo, that is used to store the VU student information: This class should store your VUID, campus id, name and father name in the fol

What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

Explain P command in the respect of QBE? P: It is the command in which is used to print (logically display) the value of the attribute in whose cell it is writ

Determine the rule that a value of a foreign key should appear as a value of some particular table is called a  Ans: Referential constraint.    The rule that a value of a fo

External failure : A failure can also result because of an external cause, such as earthquakes, fire, floods, etc. The database must be duly backed up to avoid troubles occurring d