Problem Set 1

Assigned: 9/2/09

Due: 5:00PM 9/9/09, email to the T.A., place CS 347 PS1 in the subject line.

Required Reading:

• Mata-Toledo & Cushman (Schaum book), Chapter 1
• Jewett, (on-line text) five sections comprising Basic UML and SQL
• Models
• Classes & schemes
• Rows & tables
• Associations
• Keys

Problems:

Part A: From Jewett,

1. Exercise: patients and blood samples, http://www.tomjewett.com/dbdesign/dbdesign.php?page=patient.php

Do the entire problem.

2. Exercise: cities and states, http://www.tomjewett.com/dbdesign/dbdesign.php?page=city.php

Only draw the UML diagram

3. Exercise: library books http://www.tomjewett.com/dbdesign/dbdesign.php?page=book.php

Only draw the UML diagram

Part B: From Mata-Toledo and Cushman,

1.28 1.31, note the solutions are in the book, so do not hand these in.