Attributes and tuple, Database Management System

Before we talk about the relational model in more detail, let us first define some very basic terms used in this model.

Tuple

Every row in a table shows a record and is called a tuple. A table containing 'n' attributes in a record is called n-tuple.

Attribute

 The name of every column in a table is used to interpret its meaning and is known as an attribute. Every table is called a relation.

For instance, Figure shows a relation PERSON. The columns NAME, PERSON_ID, AGE and ADDRESS are the attributes of PERSON and every row in the table represents a separate tuple (record).

 

Relation Name:  PERSON

PERSON_ID

NAME

AGE

ADDRESS

TELEPHONE

1

Sanjay Prasad

35

b-4,Modi Nagar

011-25347527

2

Sharad Gupta

30

Pocket 2, Mayur Vihar.

023-12245678

3

Vibhu Datt

36

c-2, New Delhi

033-1601138

Figure: An extended PERSON relation

Posted Date: 3/6/2013 5:15:57 AM | Location : United States







Related Discussions:- Attributes and tuple, Assignment Help, Ask Question on Attributes and tuple, Get Answer, Expert's Help, Attributes and tuple Discussions

Write discussion on Attributes and tuple
Your posts are moderated
Related Questions
Question : Mr. Smith Harry has a car manufacturing company which has recently integrated management information system. He wishes to obtain more information on ethics and socia

Greater potential for bugs: Since the sites of a distributed system operate simultaneously, it is more complex to ensure the correctness of algorithms. The art of constructing dis

Consider the following database containing five transactions. Let min_sup = 60%. Mine all frequent itemsets using Apriori and FP-growth algorithm. Compare the efficiency of the t

What are the advantages of relational data model? Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer

What is Collation Collation is a kind of sort order. There are majorly 3 types of sort orders, namely: i.) Dictionary case insensitive ii.)Dictionary - case sensitive

What is Disadvantages Of DBMS ? 1. Cost of Software and Hardware and Migration - A important disadvantage of the DBMS system is cost. 2. Reduced Response and Throughpu


Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.

How can one distinguish among different kinds of parameters? Input parameters are used to pass data to subroutines. Output parameters are used to pass data from subrout

What is a checkpoint? List the operations to be performed by the system when a checkpoint is to be taken. What does the recovery system do if there is a crash? There is large n