CS329E Elements of Biological Data Models

Homework 1

 

 

Assigned: 1/26/08

Due: 2/1/08, in class, (be prepared to discuss), late to class, homework is late. Expecting to be late to class, email the homework to me ahead of time. (Miranker@cs.utexas.edu )

 

 

Reading:  Hyper textbook, Database design with UML and SQL, 3rd edition

 

Sections:

¥ Introduction

Basic UML & SQL

¥ Models

¥ Classes & schemes

¥ Rows & tables

¥ Associations

¥ Keys

 

Homework Problems:

 

1. On page Exercise: designing classes

a)        A faculty member at a university.

b)       A work of art that is displayed in a gallery or museum.

 

2. On page Exercise: patients and blood samples

a)        Describe each class in English.

b)       Draw the class diagram.

c)         Describe each association in English (both directions).