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
Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

how does Btree differ from a B+ - tree?

The Database Approach In order to overcome the limits of a file system, a new approach was needed. Hence a database approach emerged. A database is a persistent collection of

A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. T

The clause in SQL which specifies that the query result should be sorted in ascending or descending order based upon the values of one or much more columns is Ans : Order by

In which format database schema is written ? Data base schema is written in the DDL format.

Question: (a) What are the challenges in the development of Large Scale Distributed Real Systems? (b) What is backward engineering and forward engineering in a design packa

Describe Interfaces for the DBA? Interfaces for the DBA - Most database systems holds privileged commands which could be used only through the DBA's staff. These involves com

What is called remapping of bad sectors? If the controller detects that a sector is injured when the disk is initially formatted, or when an attempt is made to write the secto

A set of possible data values is called? A set of possible data values is called as domain.