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
Prepare a gantt chart for the stock control project: Scenario Lucas-TVS is the Leader in Auto Electricals in India today with 50 years experience in desig

Describe the two alternatives for specifying structural constraints on relationship kinds? Relationship kinds have certain constraints in which limit the possible combination o

Implementing software control To implement software control designer must redesign strategy of state event model which is present in dynamic model. There are three basic ap

This report identifies and outlines my CIS 499 project named Traffic Data Management  Systems (TDMS) .   My goal is to design a replica of all traffic issues to be implemented i

a project based on normalization with first, second and third normalization. There need to be a diagram also

Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic

What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application? Enterprise Resource Planning (ERP) is an information system used in manuf

Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.

Properties of a Transaction        A transaction has four main properties. These are: Atomicity Consistency Isolation or Independence Durability or Permanen

What is candidate key? Candidate Key - A candidate key of an entity set is a minimal superkey, which uniquely identifies each row in the relation.