T-SQL Tutor Project - 01 Oct 2001

Create a database diagram (as I explained in the main article) of the four tables: Customer, Order, Category, and Product. Before running each of the following queries, draw a Venn diagram to estimate the maximum number of rows that the query will return.

Write a query to answer the question, Which customers have purchased a product? List only the customer name.

Write a query to answer the question, What were the ProductIDs of the products that these customers purchased? Add the ProductID to the query in Step 2.

Write a query to answer the question, Which category is each product in? List the ProductName and the CategoryName for each product, regardless of which customers bought which products.

Create a database diagram of the Authors, Publishers, Pub_Info, Titles, and TitleAuthor tables.

What's the relationship between

Write a query to answer the question, Who published each title? List the publisher's name and the title for each book.

Write a query to answer the question, Which authors have written at least one title? List only the author's name.

Write a query to answer the question, For those authors who have written a title, what title_id has each author written? Add the TitleID to the query in Step 4.