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;
SELECT d.name, k.city FROM DOG d, KENNEL k WHERE d.kennel_name = "Holiday Kennels" AND d.kennel_name = k.name;
My understanding would be you would project
k.city like this;
PROJECT d.name, k.city
However beyond this I am unsure how you would use join and select to get the clauses?
Any help would be great, thanks.