Lab 1

# The University of Texas

CS 327e

Spring 2002

### Lab 2

Due: 2002-02-22 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

a) Review Questions 6 a) b) c) on page 201 of the text.

b) Problems 18, 19, 20 on pg. 204, 205 of the text. Use the Chen IDEF1X, or Crows-Foot Model for the ER-Diagram in problem 20. If using the Crows-Foot Model, go ahead and show the cardinality, even if the model doesn’t allow it.

c) For the dependency diagram shown in Fig. P4.27 on page 207 of the text, Show the dependency diagram for each table such that they are in at least 3NF.

For the ER-diagrams and dependency 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 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 lab13456.zip containing the file lab23456.doc.

Home Page

Last Updated: 2/11/2002 2:44:53 PM