Q1.  Problem 3 on pages 14-15 of draft chapter 11 (products, features and substitute products).  Hand in an entity-relationship diagram and a database design outline.
 

Q2.  Problem 9 on page 17 of draft chapter 11 (salespeople and alternates).  Hand in an entity-relationship diagram and a database design outline.
 

Q3.  Problem 5, parts (a)-(d), on page 15-16 of draft chapter 11 (queries on the employee database).  The emp-self-accdb file is available here.  For each of parts (a) through (d), paste the text of your SQL query and its results table into the same Word document, which you should then print out and hand in.  Create your queries from scratch using SQL rather than using the query design view grid.  You are not required to do part (e).