Homework 1

Assigned: 1/30/06

Due: 2/2/06, in class, (be prepared to discuss), late to class, homework is late

(late policy: If you are not late to class, you may have 1 late homework without penalty – but it may not be this homework)

Special Instructions: bring two copies of your homework to class on Friday, one to hand in, one to discuss.

Reading: Text to page 22 in the packet. This corresponds to

http://www.tomjewett.com/dbdesign/dbdesign.php

Links labeled

• Introduction

Basic UML & SQL

• Models

• Classes & schemes

• Rows & tables

• Associations

- Patients

- Cities / states

- Library books

The packets were promised by Friday, but they are always done early, especially if you go in and nag. The packets will be available from Paradigm, on 24^th Street, close to the drag, next to the falafel place.

In the meantime, the text is available at

Although I gave permission for study groups for this homework, you will be much better off if you try to do as much of the homework as you can by yourself. In particular, if you do study groups, the group may only discuss one problem per meeting. This will give you an opportunity to work on question 2 by yourself even if you needed help with question 1.

Question 1:

http://www.tomjewett.com/dbdesign/dbdesign.php?page=patient.php

Question 2:

http://www.tomjewett.com/dbdesign/dbdesign.php?page=city.php