Description
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).