EER diagram of university department management system
2024-12-30 09:37:13 130 0 Report 0
0
Login to view full content
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.
Other creations by the author
Outline/Content
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
Recommended for you
More
