Domain: "DATABASE UNIVERSITY MANAGEMENT SYSTEM"

1. Description of the domain/application and its database that you propose to work. Your description should be brief and relatively informal (TWO to THREE Pages). If there are any unique or particularly difficult aspects of your proposed application, please point them out.

2. An entity-relationship diagram (ER-Diagram) for your proposed database. Do not forget to underline key attributes and include cardinality ratio and participation constraint. If there are weak entity types, indicate them by double lines.

3. Translate your ER Diagram to a set of relations (Relational Schema). Please be sure to underline the primary keys. Normalize your relations to the highest possible form. For each opportunity to combine or decompose relations, decide whether or not to do so, and briefly explain your reasoning for doing so.