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 disadvantage of multiple inheritances? There is potential ambiguity if the similar variable or method can be inherited from more than one superclass.eg: student class m

Strict 2PL :Though, this basic 2PL suffers from the trouble that it can result into loss of isolation / atomic property of transaction as theoretically speaking once a lock is rele

Discuss The difference between drop table R and delete from R.  DROP TABLE command deletes all the records with the table definition. This command will automatically committed

File Manager File manager handles the allocation of space on disk storage. It starts and maintains the list of structures and indices described in the internal schema that is

what would go in order patient#, patient name, patien address, surgeon#, surgeon name, surgery date, surgery type, drug admin

We want have a website; we need to test the security of our website. You need to: -Try to bypass our security by simulate a website hacking -Try some hack Techniques like

crete a data base relationship model Entity: Students; Professors; Dormitories buildings; Attributes of students: Name; Address; Dorm;

Determine the Persistent object Persistent object can be stored in one of the following: Files Cheap, permanent, simple storage Low level (Write, Read) Ap

Define instance and schema? Instance: Collection of data stored in the data base at a certain moment is Schema: The overall design of the data base is known as the data base

If the insertion violates one or more constraints, then two alternatives are available: Default option: - Insertion can be discarded and the reason of refusal can also be ex