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
This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

What is the use of sub queries? A sub query is a select-from-where expression that is nested with in another query. A common use of sub queries is to do tests for set membershi

What is the aim of object design The aim of object design is to identify object which the system   contains and the interactions among them. The system implements specification

What are the three classes of SQL expression? SQL expression consists of three clauses:  Select  From  Where

Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro

Whenever the LIMIT clause will be used? LIMIT is used for the following kinds of problems: 1) Answering questions about first or last and largest or smallest 2) Splitting

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Explain Network Model in DBMS? Network Model - It was formalised within the late year of 1960s through the Database Task Group of the Conference on Data System Language (DBTG

Define blocks? The database system resides eternally on non-volatile storage, and is into fixed-length storage units known as blocks.

Explain weak and strong entity sets? Weak and Strong entity sets: A physically powerful entity set has a primary key. All tuples in the group are distinguishable through that k