Join operation, Database Management System

The JOIN operation is applied on two relations. When we want to choose related tuples from two given relation join is used. The join operation need that both the joined relations must have at least single domain compatible attributes.

Syntax:

R1 R2 is used to join related tuples from two relations R1 and R2 into a single tuple.

is of the form:

ANDAND..............AND.

  • Degree of Relation:

Degree (R1   R2) <= Degree (R1) + Degree (R2).

  • There are three types of joins:

a)   Theta join

When every condition is of the form A θ B, A is an attribute of R1 and B is an attribute of R2 and have the similar domain, and θ is one of the comparison operators { ≤, ≥, ≠, =, <, <}.

Posted Date: 3/6/2013 5:53:13 AM | Location : United States







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

Write discussion on Join operation
Your posts are moderated
Related Questions
While using extract datasets it is required to have a special workarea for interface False.  It is not required to have a special workarea for interface

Explain the term - Handling Boundary Condition These are some circumstances that to be handled in any system initialization and termination. Describes how system is bro

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

explain three types of internet risks to the consummers whent he business system is data dependent. how can we minimise these risks

Ask qu. Write a XML with database with book details (Book ID, Title, Author, subject, published year, language, vendor, and price).estion #Minimum 100 words accepted#

What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)

Determine Which is not a consequence of concurrent operations? Ans: Update anomaly.

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

Question: AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P

Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode