Management Information Systems (33:136:370) 
Spring 2016, Professor Eckstein
Assignment 9

Due: Friday, April 8

 

For each part of each problem, paste your SQL code and query results into an MS Word document.  Hand in a printout of the entire Word document.
 

Make sure you download the latest available version of draft chapter 10.  Versions downloaded before April 1 will not have all of the problems specified below.
 

Q1.   Problem 9 of draft chapter 10 (compound joins on the conference database). 
 
 

Q2.  Problem 11 of draft chapter 10 (simple aggregation without grouping on the conference database).
 

Q3.  Problem 13 of draft chapter 10 (aggregation with grouping on the conference database).
 

Q4.  Problem 14 of draft chapter 10 (aggregation with grouping on the bookstore-2000 database).