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
What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

How Relational Calculus is different from Relational Algebra? What do understand by TRC queries and DRC queries?  Ans: Relational calculus contain two calculi, the tuple relati

What is meant by buffer blocks and disk buffer   The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t

List and also explain the dissimilar stages of DDLC ?

What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de

Describe Graphical User Interface? Graphical User Interfaces (GUIs) - A GUI typically displays a schema to the user in diagrammatic form. The user can then specify a query th

Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additi

a publishing company produce scientific books on various subjects. the books are written by authors who specialize in one particular subject. the company employs editors who, not n

Report writing help on database mgmt Project Description: Use of Harvard referencing, critical analysis is required. Skills required: Academic Writing, Technical Writin

Design an algorithm to implement operations  Each and every operation specified in the functional model could be formulated as an algorithm. The algorithm indicates how operat