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

Payment processors, We have a buildup of payments that need to be processed... We have a buildup of payments that need to be processed. You will need:- To prepare customer account on our site Process payment (you must have working Paypal account to d

Create a database for their customers, The ABC Bank authority now wants to ... The ABC Bank authority now wants to create a database for their customers. So you are requested to modify your program of Assignment A3 as follows. The main program first displa

What is relational algebra, What is Relational Algebra? Relational algebr... What is Relational Algebra? Relational algebra is a Procedural query Language?

What are composite objects, What are composite objects? Objects that ha... What are composite objects? Objects that have other objects are known as complex objects or composite objects.

Explain sorted file with advantages, Explain sorted File with advantages? ... Explain sorted File with advantages?  Sorted file The sort utility shall perform one of the subsequent functions: 1.Sort lines of all the named files together and write the

Explain the term- signal-to-noise ratio, Explain the term- signal-to-noise ... Explain the term- signal-to-noise ratio A signal-to-noise ratio of 20 dB means that S/N = 100. As log2101 is around 6.658, the Shannon limit is around 19.975 kbps. The Nyquist

What is the function of io/m signal in the 8085, What is the function of IO... What is the function of IO/M signal in the 8085? It is a status signal. It is used to differentiate among memory locations and I/O operations. When this signal is low (IO/M = 0

Define the five basic operators of relational algebra, Define the five basi... Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

What is the full form of odbc, What is the full form of ODBC ? ODBC stand... What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

Write short notes on tuple relational calculus, Write short notes on tuple ... Write short notes on tuple relational calculus. The tuple relational calculation is anon procedural query language. It defines the desired information without giving a particul