Ordering of tuples, Database Management System

In a relation, tuples are not inserted in any definite order. Ordering of tuples is not defined as a part of a relation definition. Though, records may be structured later according to some attribute value in the storage systems. For instance, records in PERSON table may be structured according to PERSON_ID. Such organisation or data depends on the requirement of the underlying database application. Though, for the purpose of display we may get them displayed in the sorted order of age. The following table is sorted by age. It is also worth states here that relational model does not permit duplicate tuples

PERSON

PERSON_ID      NAME                                 AGE              ADDRESS

2                           Sharad Gupta                       33                  Pocket 2, Mayur Vihar.

1                           Sanjay Prasad                      35                  b-4,Modi Nagar

3                           Vibhu Datt                           36                  c-2, New Delhi

Super Keys, Candidate Keys and Primary Keys for the Relations

As discussed in the last section ordering of relations does not matter and all tuples in a relation are unique. Though, can we uniquely recognize a tuple in a relation? Let us talk about the concepts of keys that are primarily used for the purpose as above.

Posted Date: 3/6/2013 5:23:14 AM | Location : United States







Related Discussions:- Ordering of tuples, Assignment Help, Ask Question on Ordering of tuples, Get Answer, Expert's Help, Ordering of tuples Discussions

Write discussion on Ordering of tuples
Your posts are moderated
Related Questions
Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co

The figure below depicts the conceptual diagram of a banking system. (a) Describe one example relevant to the system in figure, for each of the 4 types of enterprise appl

Differance between Unordered and ordered file ? Unordered file do no has any sequence although ordered file has arranged in a few sequence and data are assigned in ordered form

Question: a) There are three concurrency problems, i.e. three types of potential mistake which could occur if concurrency control is not properly enforced in the database syst

Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol

What are the types of storage devices? Primary storage Secondary storage Tertiary storage Volatile storage Nonvolatile storage

A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

Data Independence This brings us to our next topic: data independence. It is the property of the database which tries to make sure that if we make any change in any level of sc

Have database built but having problems with some questions that go with the database