CS 330
Homework 2
Th Sept. 11, 1997
Due: 9/18/97 by 9:00pm (before class)

Self-test exercises

 I am not grading these exercises, but you should do them, since similar ones might be on your first midterm exam.

Textbook page 107

Required Homework

Part 1: Theory

Note: The last problems are based on material that may not have been covered in class on Th, but will be covered on Tu - giving you enough time to do them. I suggest that you do the first two (based on the material done on Th) before Tuesday's class.

Textbook page 107
  1. Ex. 3.5, only the relational algebra part.
  2. Ex. 3.10. Query should be described in the relational algebra.
  3. Ex. 3.12.
  4. Ex. 3.15.
  5. Ex. 3.16.

Part 2: Access

Implement a small database in Access corresponding to exercise 3.5 on page 107. Create simple forms for entering the data and fill in the tables with a few records (about 5-6 records per table). Implement the queries as Access queries. Create reports based on the queries.

Using the Help menu, read about Creating an application. Create a main switchboard form with buttons for forms and reports. Think about the various types of users who might be using these forms and reports, and what type of permissions you should give them to the information in the database. You will explain this in a short email message to me (see below).

To turn in:
  1. Handwritten (but, please, legible) answers to the exercises assigned in Part 1.
  2. An Access database on a diskette for Part 2.
  3. A short email (which should arrive by Wednesday midnight!) with subject line: Homework 2, Access answering the above question in Part 2 about users and permissions.
Ileana Streinu