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

Define partial key and primary key, Define Partial Key and Primary Key ... Define Partial Key and Primary Key A partial key, also known as discriminator, is the set of attributes which can uniquely identify weak entities that are related to similar o

Fragmentation, Differentiate between horizontal & mixed horizontal fragment... Differentiate between horizontal & mixed horizontal fragmentation?

Explain the term- periodic recomputation, Explain the term- Periodic recomp... Explain the term- Periodic recomputation Periodic recomputation:  Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p

What are the key features of oracle, What are the key features of Oracle? ... What are the key features of Oracle? Key features of Oracle are as follows: • Read Consistency • Concurrency • Locking Mechanisms • Quiesce Database • RAC • Portability

What is data block, What is data block? Data Block - In oracle the data... What is data block? Data Block - In oracle the data blocks are referred to as tablespaces. A tablespace is an fields of disk consisting of one or more disk files. A tablespace

Approachs of database management system, The Database Approach In ord... The Database Approach In order to overcome the limits of a file system, a new approach was needed. Hence a database approach emerged. A database is a persistent collection of

Data models, After going by the database architecture, let us now dwell on ... After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab

Express the queries in relational algebra, Question: This question refe... Question: This question refers to the database schema. a) Express the following queries in SQL: (i) Write the SQL code that will create the table Company. Your answer sh

Define the relations as tables in sql, Consider the relations given below ... Consider the relations given below Borrower (id_no, name) Book (accno., title, author, borrower_idno) (a) Define the above relations as tables in SQL forming real world assumptio

Single valued normalisation, Single Valued Normalisation  Codd in the y... Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati