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

Advantages of Observation Methods, Advantages of Observation  Methods: ... Advantages of Observation  Methods: Bailey has pointed  out four  advantages of observation: 1. Superior in Data  Collection  on Non Verbal Behavior: When  a person  a opi

Concurrency control, define lock conversion define lock conversion

Hashed file organisation, Hashed File Organisation Hashing is the most ... Hashed File Organisation Hashing is the most common form of purely random access to a database or file. It is also used to access columns that do not have an index as an optimi

What are the benefits of prepared statements, What are the benefits of prep... What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

Define query processing, Define Query Processing Query processing is th... Define Query Processing Query processing is the process of selecting the best plan or strategy to be employed in responding to a database request. The plan is then executed to

Er database theoretical and modeling database system, Need an expert in ER ... Need an expert in ER database theoretical and modeling database system Project Description: Need an expert in ER database theoretical and modeling database systems? Skills

Pl/SQL, I need solution of the question posted at http://www.expertsmind.c... I need solution of the question posted at http://www.expertsmind.com/questions/sql-query-for-testing-triggers-and-stored-procedures-30140149.aspx

Data control, Data Control The data control mostly refers to commands that... Data Control The data control mostly refers to commands that permit system and data privileges to be passed to several users. These commands are usually available to database admi

Define normalization, Normalization :It is a process of examine the given ... Normalization :It is a process of examine the given relation schemas based on their primary key and Functional Dependencies (FDs) to achieve the properties Minimizing redun

Responsibilitied of DBA, explain five responsibilities of DBA? explain five responsibilities of DBA?