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

Dataware house(job scheduling strategy), Define a job scheduling strategy t... Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

What are the storage types, What are the storage types? The storage typ... What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

Which is a valid sql type, Which is a valid SQL type? A valid SQL Shoul... Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.

Hospital managment sysytem, sy bcs project of hospital managment system sy bcs project of hospital managment system

What is null, What is NULL? Simply NULL means not in value. What is NULL? Simply NULL means not in value.

Why like predicate used for, Why Like predicate used for? LIKE predicat... Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.

How can redundant associations be done, How can Redundant Associations be d... How can Redundant Associations be done It can be done by asking questions: i)  Is there a specific arrangement of network which would optimize critical aspects of completed

I need help on the following 5 questions, 1. Define and discuss Work Breakd... 1. Define and discuss Work Breakdown Structure, Critical Path Analysis, PERT charts and GANTT charts. Describe the role of each in determining scope, budgets, and schedules? What

Vertical fragmentation, Vertical Fragmentation- Vertical fragmentation grou... Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

Database, i would like to ask if you will do assignment of database number ... i would like to ask if you will do assignment of database number of words 1500 and how much