CS 327e
Spring 2002
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.
Last Updated: 2/11/2002 2:44:53 PM