The University of Texas

CS 327e

Fall 2002

Lab 2

Due: 2002-09-27 Friday 8.30 a.m. by email.

PURPOSE:

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

IMPLEMENTATION:

For this lab, consider solving all of the following:

a) Review Questions 8 a) b) (Using Chen/IDEF1X model notation) on page 161 of the text1.

b) Problems 5 a) b) c) d) e) on pg. 163, 164 of the text1. Go ahead and show the cardinality, even if the model doesn’t allow it.

c) Problems 11, 12, 13 (Use Chen/IDEF1X notation) on page 203 of Text1.

For the ER-diagrams and dependency diagrams, you can use any commercial software (MS-Word, Visio [which contains built-in templates 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 lab2xxyy.zip, lab2xxyy.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 lab23456.zip containing the file lab23456.doc.

Last Updated: 9/16/2002 10:18:13 PM