CSE3330 Homework #4
Due on Wednesday November 17, before midnight
Worth 4% of the final grade


Your relational schemas should contain keys and referential integrity constraints, similar to the schema in Figure 3.7 on page 75 in the textbook.

  1. (50 points) Consider the following E-R diagram that represents course offerings in a university:

    hw3.gif

    Represent this diagram in the relational model.

  2. (50 points) Represent the following E-R diagram in the relational model.

    ex31.gif

How to Submit the Homework

You need to submit your homework solution online using the following web form. Acceptable document formats are: Microsoft word/powerpoint document, PDF, and postscript. You may submit it as many times as you like, but only the most recently submitted file will be retained and evaluated.

Submit Homework #4:

Last modified: 11/10/10 by Leonidas Fegaras