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

The concurrent transactions, The Concurrent Transactions  Almost every ... The Concurrent Transactions  Almost every commercial DBMS support multi-user environment. Therefore, allowing multiple transactions to proceed concurrently. The DBMS must make

B-tree, construct a b-tree for the following set of key values 2,3,5,7,11,1... construct a b-tree for the following set of key values 2,3,5,7,11,17,19,23,29,31.assume that the tree is initial empty and the values are added in ascending order

Cases of constraint violations, (1)     Insert into PERSON Violated con... (1)     Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

Delete - referential integrity, During the deletion of a tuple two cases ca... During the deletion of a tuple two cases can happen: Deletion of tuple in relation having the foreign key: In this type of case simply delete the desired tuple. For example, in

What is a database, What is a Database? To know what database is, we ha... What is a Database? To know what database is, we have to start from data, which is the basic building block of any DBMS. Data: Facts, figures, statistics etc. having no pa

Managing databases, Code an Oracle Database trigger to enforce the constrai... Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.

IT Assignmnet, i need help for assignment .. i need help for assignment ..

Define data conversion, Define data conversion? Helpful to load data in... Define data conversion? Helpful to load data into temporary staging tables. Then can write SQL code to do much of data processing. SQL code is simpler and faster to write than

What are decision support systems, Question: (a) What are decision sup... Question: (a) What are decision support systems, and what role do they play in the business environment? (b) Data mining is a knowledge discovery process of automated extr

Sequences-data control, Sequences Sequences: Automatically produ... Sequences Sequences: Automatically produce unique numbers Are sharable Are typically used to make a primary key value Replace application code Speed up t