EER diagram of university department management system
0 Report
This is an EER diagram of a university department management system, designed to illustrate the structural relationships among various entities within the institution. The diagram highlights connections between departments such as the Business School, School of Electronic and Information Engineering, and School of Computer Science. Key components include department IDs, deans, dormitory buildings, and relationships among students, parents, and faculty. Additionally, it showcases the intricate links between departments and their associated entities, such as teachers' families and student information. This diagram serves as a comprehensive guide to understanding the organizational framework of the university's departmental management.
Related Recommendations
Other works by the author
Outline/Content
See more
1:n
n
1..1
Business School
School of Commerce ID varchar(50)School of Commerce Dean Name int(20)
0..*
1: n
School of Electronic and Information Engineering
Telecommunications College ID varchar(50)Telecommunications Dean Name int(20)
department
Department ID{PK} varchar(50)Department Name int(50)
Telecommunications College dormitory building
Dormitory building number {PK} varchar(50)Dormitory building name int(20)
Telecom College teacher's family
Telecom College teacher work ID {PK} varchar(50)Family member name int10)Relationship with the teacher varchar(50)
School of Computer Science
Computer Science Institute ID varchar(50)Dean of Computer Science Institute int(20)
University
School ID{PK} varchar(50)School Name int(50)
Parents of students in the School of Telecommunications
Student ID {PK} varchar(50)Parent name int(10)Relationship with student varchar(50)Parent phone number varchar(20)
Telecommunications College student
Student number {PK} varchar(50)Student name int(10)Student grade varchar(50)
1
Is
1:1
Telecommunications College teacher
Telecom School teacher work ID {PK} varchar(50)Teacher's name int(10)Teacher's phone number varchar(20)
0 Comments
Next Page