EER Design

A Graduate School maintains data about the following entities:

a. Graduate Program, including name, description, courses, and program director

b. Enrollment, including semester, year, admitted, deferred, domestic, and international

c. Students, including student ID, name, and email address

d. Faculty, including faculty ID, name, title, phone number, and email address Further, the registration of students in a graduate program, and the matriculation date in the program the student registered for must be appropriately modeled. Each graduate program may have many enrollments, but we are also not interested in enrollment information about a graduate program if the program is no longer offered.

Construct the E-R diagram A Graduate School. Document all relationships (both directions for each relationship) and any assumptions that you make. Make sure that your model properly depicts entities, attributes, constraints, and relationships and weak entities (if any).

Note: It is very important that you stay within the bounds of the problem as stated above. For example, the description above refers to graduate programs. It does not mention or imply anything about undergraduate programs and majors. Therefore, dont even attempt to create a model that accommodates those items.

Model has to be developed using Microsoft word.