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

Ask an Expert

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

Write your message here..

Related Questions

What is called a query evaluation plan, What is called a query evaluation p... 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.

Primary key, explaination explaination

Explain different types of keys and relational model., Relational Model: T... 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, Describe a technique for direct sea... 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, What is Outer join?  They can be employed while we ... 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, What Count function return in SQL? C... 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

Database Design & Management, I need help for my Uni assignments I need help for my Uni assignments

Relation schema for student, Example RELATION SCHEMA for STUDENT: STU... Example RELATION SCHEMA for STUDENT: STUDENT (Roll No: string, name: string, login: string, age: integer) RELATION INSTANCE

ER diegrams, How to draw an ER diagram to a finance companz How to draw an ER diagram to a finance companz

Relational data base management system, explain in detail about crash recov... explain in detail about crash recovery