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
Which file organization provides very fast access to any arbitrary record of a file? Hashed file organization provides very fast access to any arbitrary record of a file.

Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem

Describe the static hash file with buckets and chaining and show how insertion, deletion and modification of a record can be performed. In static hash file organization, the wo

What are the different approaches for database design? There are two basic approaches for database design which are as follows: Attribute driven: It compiles a list of att

want a idea for final year project

Explain the Deferred Update The deferred update methods do not physically update the database on disk till after a transaction reaches its commit point; after that the updates

Explain the term- Periodic recomputation Periodic recomputation:  Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p

Define about the Stored Procedure - It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks. - When you essentiall

Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file

Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,