The University of Texas

CS 327e

Fall 2004

Lab 2

Due: 2004-09-24 Friday 8.30 a.m. in class.

PURPOSE:

The purpose of this lab is to learn about Database Design using ER-Diagrams.

IMPLEMENTATION:

For this lab, consider solving all of the following:

a) Problems 2.72, 2.73, 2.74, 2.75, 2.76 on pg. 68, 69 of Chapter 2 from the text. For these exercises, read the relevant sections on pages 33-35.(HINT: You might need to read these pages to (say) answer 2.72 D)

b) Problem 3.36 on pg. 106, 107 of Chapter 3 from the text.

For the ER-diagrams, you can use any commercial software (MS-Word, Visio [which contains built-in templates in the Database folder], ERWin, MS-Paint etc.). Also, see links 53, 54, 55 on the class web page. Clearly label/write any assumptions you make during the design.

SUBMISSION:

Please submit a paper copy in class by the Due Date/Time.

Make sure you have written the following on your paper submission:

· First Name, Last Name

· Course Name

· Lab #

· EID (optional)

MAKE SURE YOU STAPLE THE PAGES BEFORE SUBMISSION.

Consult the class web page for

- Late submission policy

- Academic Dishonesty Policy

Last Updated: 11/4/2004 11:20:54 AM