C M S I 4 8 6
IN T R O D U C T I O N T O DA T A B A S E SY S T E M S
Fall 2005
Assignment 1027
Time to focus on your respective database projects — presumably you’ve been working on them, since
they’ve been approved for a few weeks now…? Whether or not this is the case, it’s midsemester mile-
stone time.
Not for Submission
While I won’t specifically check for it this time, it is highly recommended that you commit all of your
working files to CVS, including your design documents (as PDFs, PNGs, or some other digital format).
Code should go under src and design documents should go under doc. Appropriate frequency and time-
liness of commits will play into the final grading of your project.
For Submission
Submit the latest versions of the following documents and/or code. Distribution instructions follow:
1. Use case model — Preferred level of detail is the point at which a use case can be translated
directly into DAO methods/queries
2. Conceptual data model — UML
3. Relational data model — Relational schema diagram
4. Database updates and queries — Relational algebra expressions; should correspond to the
database-related use cases and of course the relational schema
5. (optional, extra credit) Initial implementation — DAOs (based on your use case model),
DTOs (based on your conceptual and relational data model), DAO factory, test database fix-
ture, unit tests
Submit items (1) to (4) on hardcopy; if you have some of item (5) done, submit that on both hard-
copy and by e-mail.
Finally — make copies of (1) to (5) for distribution to the rest of the class. If you’ve done a bit of
(5), have the code ready at a workstation for us to review. We will go over selected portions of eve-
ryone’s work together in class.