CSE3330 Homework #4
Due on Thursday November 17, before midnight
Worth 5% 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:


    Represent this diagram in the relational model.

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


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/08/11 by Leonidas Fegaras