CS 327e
Spring 2002
Due: 2002-02-15 Friday 8.30 a.m. by email.
PURPOSE:
The purpose of this lab is to learn about Database Design using
ER-Diagrams.
IMPLEMENTATION:
For this lab, consider solving
a)
Problems
1,2,3 on pg. 163 of the text. Use the Chen, IDEF1X, or Crows-Foot Model. If
using the Crows-Foot Model, go ahead and show the cardinality, even if the
model doesn’t allow it.
b)
Problems
5 on pg. 163, 164 of the text. Use the Chen IDEF1X, or Crows-Foot Model. If
using the Crows-Foot Model, go ahead and show the cardinality, even if the
model doesn’t allow it.
For the ER-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 lab1xxyy.zip, lab1xxyy.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 lab13456.doc.