CSE3330/5330 Homework #2
Due Thursday February 25, before midnight
Worth 3.33% of the final grade


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

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

    hw3.gif

    where the prerequisite relationship indicates which courses are prerequisites for a course (one course may have many prerequisites and a course can be a prerequisite of many courses). Represent this diagram in the relational model.

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

    ex31.gif

Submit Homework #2:

Last modified: 02/16/10 by Leonidas Fegaras