Intersection, Database Management System

If R1 and R2 are two union compatible relations or functions, then the result of R3 = R1 ∩R2 is the relation that contains all tuples that are in both the relations In other words, R3will have tuples such that R3 = {t | R1 ∋ t ∧ R2 ∋ t}.

Example:

 

 R1

A

B

A1

B1

A2

B2

A3

B3

A4

B4

  R2                     

A7

B7

X

Y

A1

B1

A7

B7

A2

B2

A4

B4

 

R3 = R1 ∩ R2 is

 

 

R3 = R1 ∩ R2 is

A

B

A1

B1

A2

B2

A4

B4

 

Note: 1) Intersection is an associative operation, i.e., R1 ∩ (R2 ∩ R3) = (R1 ∩ R2) ∩ R3

2) Intersection is a commutative operation, i.e., R1 ∩ R2 = R2 ∩ R1

Posted Date: 3/6/2013 5:45:16 AM | Location : United States







Related Discussions:- Intersection, Assignment Help, Ask Question on Intersection, Get Answer, Expert's Help, Intersection Discussions

Write discussion on Intersection
Your posts are moderated
Related Questions
What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)

Explain three main attributes of data.

What is an Operand? The data on which the operation is to be performed is known as an Operand

What are the purpose for having variable length records? What kinds of separator characters are required for each? Variable-Length Records - Variable-length records are thos

System Design: An Object Oriented Approach Any software systems always try to change and evolve as technology and business rules evolve. The development of information systems

What is a records management consultation? Our organization is an authority for disseminating your specific requirements and giving you with a solution to effectively manage yo

What is a hash index? A hash index organizes the search keys, with their associated pointers, into a hash file structure.

Define multivalued dependency.  What do understand by trivial multivalued dependency?  Ans: A multivalued dependency is a full constraint among two sets of attributes in a rela

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

Define the notation for classes and atrributes The notation for class, attribute, and operations are shown below:     Figure: Class with attributes and operations A