DePauw University,
Computer Science Department,
Spring 2011Maintained by Brian Howard (
bhoward@depauw.edu).
Last updated
| Overview | Schedule | Resources | Assignments | Home |
bhoward@depauw.edu)
Chapter 4, Exercises 1, 3, 8, 9, 13, and 20 (b, e, h, k, n, and q; you do not need to show the query trees)Choose an application domain which interests you and about which you have some knowledge.
Design a database to manage information for some aspect of this domain. Create a class diagram
and a corresponding SQL specification (that is, a sequence of create table commands)
for your database. As a minimum, there should be at least four tables in your database, with
(ideally) no redundant or inadequate relationships (in the terminology of Chapter 3). In addition,
give at least four examples of useful queries written against your database. Finally, write up your
design decisions, and discuss at least one example of a view that could be used to provide
restricted access to your database for some users.
For this project, I am not requiring that you actually create the database (for example, in Derby) or populate it with data. However, you may find it helpful to do so when testing your queries.
| Overview | Schedule | Resources | Assignments | Home |
DePauw University,
Computer Science Department,
Spring 2011
Maintained by Brian Howard
(bhoward@depauw.edu).
Last updated