Explain the equijoin, Database Management System

Explain the θ-join and equijoin

Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but she doesn't wish to spend more money for the boat as compared to for the car. The θ -join on the relation CarPrice > BoatPrice generates a table with all the probable options. If the condition employs equality operator then it is also termed as equijoin.

Posted Date: 5/6/2013 3:27:13 AM | Location : United States







Related Discussions:- Explain the equijoin, Assignment Help, Ask Question on Explain the equijoin, Get Answer, Expert's Help, Explain the equijoin Discussions

Write discussion on Explain the equijoin
Your posts are moderated
Related Questions
What is called a query evaluation plan? A sequence of primitive operations that can be used to assess a query is a query evaluation plan or a query implementation plan.


Relational Model: The relational model uses a collection of tables to represent both data and the relationships among those data. Each table has multiple columns and each column h

Describe a technique for direct search? Explain how data is stored within a file so which direct searching can be performed. For a file of unordered fixed length records by u

What is Outer join?  They can be employed while we want to keep all the tuples in R, or all those in S or all those in both relations in the result of the JOIN in spite of of w

What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou


Example RELATION SCHEMA for STUDENT: STUDENT (Roll No: string, name: string, login: string, age: integer) RELATION INSTANCE

How to draw an ER diagram to a finance companz