Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been asked to outline the sequence of commands using low-level operators (join/project/select) that are used in the following SQL statement;

WHERE d.kennel_name = "Holiday Kennels"
AND d.kennel_name =;

My understanding would be you would project and like this;


However beyond this I am unsure how you would use join and select to get the clauses?

Any help would be great, thanks.

share|improve this question
up vote 1 down vote accepted

I assume you're talking about Relational Algebra here.

A SELECT operation returns whole tuples (rows) based on some predicate. The predicate is defined in the SQL statement by the WHERE clause.

The PROJECT algebra operation is where you select a subset of attributes from each tuple. The PROJECT operation is defined in the SQL statement by the columns you specify. In SQL, the SELECT and PROJECT operations are combined into the SELECT clause.

A JOIN operation is used to combine two sets of tuples by a common and related attribute. In this example, you are using an INNER JOIN defined in the FROM and WHERE clause. I generally prefer to declare my joins solely in the FROM clause, but it works either way.

So, the SELECT operation is:

WHERE d.kennel_name = "Holiday Kennels"

The PROJECT operation is:


And the JOIN operation is:

AND d.kennel_name =;
share|improve this answer
So here we could say; PROJECT (using, SELECT (using d.kennel_name) AND JOIN (using d.kennel_name, – RJones Apr 4 '14 at 14:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.