1) The Brooklyn College Graduate School maintains data about the following entit
1) The Brooklyn College Graduate School maintains data about the following entities:
a. Graduate Program, including name, description, courses, website, and program director
b. Enrollment, including semester, year, admitted, deferred, domestic, and international
c. Students, including student ID, name, address, phone number, and email address
d. Program Director, including employee 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 for the brooklyn 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, don’t even attempt to create a model that
accommodates those items.
It is also very important that you do not add attributes if they are not necessary or required by the
problem. For example, the description above refers to students. It does not mention or imply
anything about student status (i.e. freshman, sophomore etc). Therefore, don’t even attempt to
create a model that includes student status as an attribute; it would be superfluous.
These are just examples of how you can find yourself out of bounds.
