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
I want a good Microsoft Admin experienced in IIS and SQL Server. They require being able to set it up and administer from then onwards. Experience in Team Foundation Server a

What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on

What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency

Define shadow paging. An alternative to log-based crash recovery method is shadow paging. This technique requires fewer disk accesses than do the log-based methods.

Which database level is closest to the users? External database level is closest to the users.

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Which operation is used if we are interested in only certain columns of a table? PROJECTION operation is used if we are interested in only certain columns of a table.

Consider the following frequency counts of some itemsets in a transaction database r : freq({A}, r) = 0.405 freq({B}, r) = 0.510 freq({C}, r) = 0.303 freq({A

What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.

Project Description: Oracle Certified Professional with 20 years of practice, Oracle version 6.0.34, 7.3, 8.0, 8i, 9i, 10G, 11G, 12C. Crossplatform migration, Informix, MSSql