Low-level relational operators from SQL
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:

SELECT d.name, k.city


And the JOIN operation is:

FROM DOG d, KENNEL k
...
AND d.kennel_name = k.name;