Lab 1

# The University of Texas

CS 327e

Spring 2003

### Lab 2

Due: 2003-02-10 Monday 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) Problems 1, 2, 3 on pg. 163 of Chapter 3 from the text (Using Chen model notation).

b) Problems 1, 2, 3, 4 on pg. 201-202 of Chapter 4 from the text (Using Chen model notation).

NOTE: You can assume that any given product is supplied by a single vendor, but a vendor can supply many products.

c) Problems 15, 16, 17 on pg. 205 of Chapter 4 (Using Chen model notation).

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: 2/3/2003 11:31:06 AM