Management Information Systems (33:136:370:02) 
Fall 2015, Professor Eckstein
Assignment 8

Due: Thursday, November 12
   

Q1.  Problem 4 on page 14 of draft chapter 9 (normalization: car wash).  Hand in an entity-relationship diagram and a database design outline.
 

Q2.  Problem 8 on page 17 of draft chapter 9 (normalization: marketing fabric).  Make sure you have updated your version of Chapter 9 to the latest one.  Hand in an entity-relationship diagram and a database design outline.
 

Q3.  Problem 2 on page 27 of draft chapter 10 (queries: conference database).  Make sure you have updated your version of Chapter 10 to the latest one.  The conference.mdb file is available here.  For each of parts (a) through (h), 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.