EER diagram of university department management system
2024-12-30 09:37:13 0 Report
Login to view full content
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)
Collect
Collect
Collect
Collect
0 Comments
Next page
Recommended for you
More
