Join operation, Database Management System

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







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
Related Questions
What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

Physical Records These are the records that are stored in the secondary storage devices. For the database relation, physical records are the group of fields kept in adjacent me

I am using Siteground. And my database is full of limit so need someone who reduces the data which no need. This is very simple and simple task. Skills required are Databa

Create role named role_table that allows a user to create tables. Using role_table allow users kripa and reena to create tables. CREATE ROLE role_table; GRANT CREATE ANY TABLE

Section A:  Use the following tables to create a database called College.  Use SQL commands. Student stuid(primary) lastName firstName

Explain what is RDBMS ? RDBMS - RDBMS is a database management system (DBMS) which stores data within the form of relations. Relational databases are powerful since they need f

What is Structured Query Langauge (SQL)? SQL is a powerful set-oriented language which was formed by IBM research for the databases that adhere to the relational model. It havi

The definition of the classes and operation can often be adjusted to increase the amount of inheritance". Justify the above statement.   Adjustment of Inheritance The def

What is a cascading update? Referential integrity constraints needs that foreign key values in one table correspond to primary key values in another. If the value of the primar