7 of draft chapter 12 (movie catalog). Draw an entity-relationship diagram
and write a database outline.
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
Problem 16 of draft chapter 10 (criteria after grouping on the conference
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).