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

Due: Friday, April 22

 

Q1.   Problem 7 of draft chapter 12 (movie catalog).  Draw an entity-relationship diagram and write a database outline.
 
 

Q2.  Problem 4 of draft chapter 12 (biomedical citation index).  Draw an entity-relationship diagram and write a database outline.
 

For each part of each remaining 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 are using the most recent version of draft chapter 10.  Versions downloaded before April 15 will be missing some of the following problems or have them numbered differently.
 

Q3.  Problem 16 of draft chapter 10 (criteria after grouping on the conference database).
 

Q4.  Problem 17 of draft chapter 10 (simple sorting on the plumbing store database).
 

Q5.  Problem 18 of draft chapter 10 (more complicated sorting queries on the plumbing store database).