In a PhD program, students join a particular specialization offered by a department. Aspecialization with same title (e.g., DBMS) may be offered by one/more depts independently. Teachers are appointed to a specific department and given a room and telephone. Each department should have a teacher who serves as its head. Courses are offered under various specializations. A teacher may teach many courses and a course may be taught by many. A student studies a course under a teacher during some semester (e.g., semester 1 of 2019), and is awarded a grade. At eacher’s research interest may lie in one/more specializations. Courses have one/more/zerop prerequisites Construct an E-R diagram for the above specification. Document all assumptions.
In a PhD program, students join a particular specialization offered by a department. Aspecialization with same title (e.g., DBMS) may be offered by one/more depts independently.
Teachers are appointed to a specific department and given a room and telephone. Each department
should have a teacher who serves as its head. Courses are offered under various specializations.
A teacher may teach many courses and a course may be taught by many. A student studies a course
under a teacher during some semester (e.g., semester 1 of 2019), and is awarded a grade. At eacher’s research interest may lie in one/more specializations. Courses have one/more/zerop prerequisites
Construct an E-R diagram for the above specification. Document all assumptions.
Please don't copy answer form internet..i will give negative feedback
Step by step
Solved in 2 steps with 2 images
