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

Ask an Expert

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

Write your message here..

Related Questions

Special workarea for interface, While using extract datasets it is required... 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, Explain the term - Handling... 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, Explain Data Sublangauges ? Data sublanguage... 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

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

BCA, Ask qu. Write a XML with database with book details (Book ID, Title, A... 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, What subschema expresses ? A subschema expres... 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 operation, Determine Whi... Determine Which is not a consequence of concurrent operations? Ans: Update anomaly.

Explain the five levels of capability maturity models, Question 1 What is ... 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

Improve efficiency in query evaluation, Question: AirwaysCentre, an int... 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, Explain Relational model an... 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