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
Explain the θ-join and equijoin Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but sh

What is system catalog or catalog relation? How is better known as? A RDBMS maintains a explanation of all the data that it contains, information about every relation and index

Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1

Question 1 Discuss on transmission impairments Question 2 What is framing? Question 3 Write a note on 10Base2 10Base- T Question 4 Explain the rev

Data Fragmentation "Fragmentation includes decomposing the data in relation to non-overlapping component relations". Why do we require fragmenting a relation?

Fourth Normal Form (4NF) When attributes in a relation have multi-valued dependency, further Normalization to 4NF and 5NF are needed. Let us first find out what multi-valued d

Query Processor The query language processor is responsible for taking query language statements or shifting them from the English-like syntax of the query language to a form

how to implement hyrise in C plus plus

What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

Explain different categories of failures that occur in Oracle database? Categories of Failures - In Oracle database subsequent types of failures can occurred: Statement Failu