Homework1 -- Due beginning of class on 22nd of February.
All homeworks should be done independently.

Reading assignment : Ch6 (5th edition) or Ch2 (4th edition) (you may skip the section on UML)

Construct an E-R diagram for the following enterprises.

• For each, show clearly all entity and relationship sets, and their attributes.
• For each relationship set, indicate the mapping cardinalities.
• For each set, identify the primary key or keys.
• Convert the E-R diagram into tables.
• Use the mapping cardinalities to eliminate redundant tables.
• List assumptions if any.
• Simplifying assumptions also lead to limitations on your design. Indicate any limitations.

Note : develop your design incrementally. Don't make it too simplistic but at the same time, do not generate a highly detailed model either. It is enough if each application contains about 5-10 entity sets and about half as many relationship sets. Take a look at the following
ER diagrams.