University System ER Diagram
Use immediately

University System ER Diagram

centers

center_id INT(10)

center_name ARCHAR(300)

Indexes

Sessions

session_id INT(10)

session_name VARCHAR(25)

session_start DATE

session_end DATE

center_id INT(10)

Indexes

schoolholidays

schoolholiday_id INT (10)

schoolhoiday_name VARCHAR(50)

schoolholiday_datestrt DATE

schoolholiday_dateend DATE

session_id INT(10)

Indexes

users

user_id INT(10)

guardian_id INT(10)

staff_id INT(10)

student_id INT(10)

user_login VARCHAR(15)

user_password CHAR(40)

user_salt CHAR(32)

Indexes

staff

staff_id INT(10)

staff_firstname VARCHAR(25)

staff_lastname VARCHAR(25)

staff_nric VARCHAR(10)

staff_phonehome VARCHAR(10)

staff_phoneoffice VARCHAR(10)

staff_phonemobile VARCHAR(50)

staff_email VARCHAR(50)

staff_status SET(..)

department_id INT(10)

center_id INT(10)

Indexes

departments

depart_id INT(10)

department_name VARCHAR(200)

Indexes

guardians

guardian_id INT(10)

guardian_name VARCHAR(100)

guardian_nric VARCHAR(14)

guardian_phonehome VARCHAR(10)

guardian_phoneoffice VARCHAR(10)

guardian_phonemobile VARCHAR(10)

guardian_email VARCHAR(50)

Indexes

guardians_students

gs_id INT(10)

guardian_id INT(10)

student_id INT(10)

Indexes

classes

class_id INT(10)

class_name VARCHAR(100)

schoolsession_id INT(10)

Indexes

classes_students

cs_id INT(10)

class_id INT(10)

student_id INT(10)

Indexes

schoolsessions

schoolsession_id INT(10)

schoolsession_name VARCHAR(50)

schoolsession_timestart TIME

schoolsession_timeend TIME

session_id INT(10)

Indexes

students

student_id INT(10)

student_firstname VARCHAR(100)

student_lastname VARCHAR(100)

student_gender ENUM('M',F)

student_dob DATE

student_nric VARCHAR(14)

student_bc VARCHAR(10)

student_remarks VARCHAR(1000)

center_id INT(10)

Indexes

69
3
2
publish time: 2021-06-04
Captain O Captain

University System Entity-Relationship (ER) diagram has entities like staff, sessions, users, centers, guardians, departments, guardians_students, etc. As the below university system ER diagram illustrates, there are attributes like guardian_id, guardian_name, guardian_nric, guardian_phonehome, department_name, guardian_id, student_id, user_id, user_login, user_password, staff_status, staff_phoneoffice, staff_firstname, staff_lastname, and others. The university system entity-relationship model is a graphical approach to database design. It can be designed or created using EdrawMax or EdrawMax Online. It has several predefined templates that make designing such ERM diagrams very easy. It is a high-level data model that defines data elements and their relationship for a specified software system. At the same time, an affiliation exists between various qualities of a component.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
23
0
0
DILSHAN SACHINDRA