Lab 1

# The University of Texas

CS 327e

Spring 2002

### Lab 1

Due: 2002-02-15 Friday 8.30 a.m. by email.

PURPOSE:

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

IMPLEMENTATION:

For this lab, consider solving

a) Problems 1,2,3 on pg. 163 of the text. Use the Chen, IDEF1X, or Crows-Foot Model. If using the Crows-Foot Model, go ahead and show the cardinality, even if the model doesn’t allow it.

b) Problems 5 on pg. 163, 164 of the text. Use the Chen IDEF1X, or Crows-Foot Model. If using the Crows-Foot Model, go ahead and show the cardinality, even if the model doesn’t allow it.

For the ER-diagrams, you can use any commercial software (MS-Word, Visio [which contains built-in templates for Crows-Foot and IDEF1X notation in the Database folder], ERWin, MS-Paint etc.). Clearly label/write any assumptions you make during the design.

SUBMISSION:

Please submit an electronic zipped file by emailing it to the TA (CC: the instructor) by the Due Date/Time. Consult the class web page for

- Email addresses of Instructor/TA

- Late submission policy

- Academic Dishonesty Policy

NOTE: For electronic submissions, use file naming conventions such as lab1xxyy.zip, lab1xxyy.mdb etc., where xxyy are the last 4 digits of your SSN.

For example, if you are submitting a MS-Word document, and the last 4 digits of your SSN are 3456, then submit a file named lab13456.zip containing the file lab13456.doc.

Home Page