CS 327e
Spring 2003
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