Relation instance or relation state, Database Management System

A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time.

A relation state r of the relation schema R (A1,A2,..........AN), also denoted by r(R) is a set of n-tuples

r = {t1,t2,............tm}

Where each n-tuple is an ordered list of n values

t  =  1,v2,........, vn>

where every vi belongs to domain (Ai) or includes null values.

The relation schema is also known as  'intension' and relation state is also known as 'Extension'.

Posted Date: 3/6/2013 5:17:29 AM | Location : United States







Related Discussions:- Relation instance or relation state, Assignment Help, Ask Question on Relation instance or relation state, Get Answer, Expert's Help, Relation instance or relation state Discussions

Write discussion on Relation instance or relation state
Your posts are moderated
Related Questions
What Is Recovery?  During the life of a transaction, i.e., a after the start of a transaction but before the transaction commits, various changes may be made in a database state

I need some help with my normalization database homework.

What is an object design? Object design is a very interactive method, which decides the relationship among objects, classifies operations on classes, determines overall system

What are the object-oriented approaches Software systems which are designed with structured design methodology never support some of desired quality attributes for example reus

Can a domain, assigned to a data element be changed? Yes.  We can do so by just overwriting the entry in the field domain.


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

An orchestra database consists of the following relations: CONDUCTS (conductor, composition) REQUIRES (composition, Instrument) PLAYS (Player, Instrument) Give the relational

1. Create a subroutine that does the remote blast on the file protein.fa. 2. Pass that returned files from the blast to another subroutine that parses the output and sends it to

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an