Entity relationship diagram kutm
?
0 likes?484 views
The document describes the tables in a student management system database including tables for faculty, departments, curriculums, subjects, students, and lecturers. The tables contain fields like names, ids, degrees, and other attributes. Relationships between the tables are shown by foreign keys marked with an asterisk.
Entity relationship diagram kutm
- 1. sms_faculty sms_department sms_course_curriculum facultyid : int (11) departmentid : int (11) curriculumid : int (11) khfacultyname : varchar (255) khdeptname : varchar (255) degree : varchar (255) endeptname : varchar (255) Register Department semester : int (11) enfacultyname : varchar (255) Register Faculty associatedegree : int (11) departmentid : int (11)* postgraduatedegree : int (11) undergraduate degree : int (11) Lecturer doctordegree : int (11) generation : int (11) Register Curriculum facultyid : int (11)* sms_lecturer Select Department lecturerid : varchar (255) sms_subject khlecname : varchar (255) Register Student subjectid : varchar (255) enlecname : varchar (255) khsubjectname : varchar (255) sms_student gender : varchar (255) ensubjectname : varchar (255) studentid : varchar (255) nationality : varchar (255) credit : double khstuname : varchar (255) idcard : varchar (255) hour : double enstuname : varchar (255) dob : date curriculumid : int (11) * gender : varchar (255) pob : text phone : varchar (255) degree : varchar (255) email : varchar (255) department : varchar (255) highschool : varchar (255) school : varchar (255) year : varchar (255) from : varchar (255) studydegree : varchar (255) atyear : varchar (255) academicyear : varchar (255) address : text generation : int (11) phone : varchar (255) group : varchar (255) email : varchar (255) testexam : varchar (255) facultyid : int (11)* scholarship : varchar (255) photo : text facultyid : int (11)* departmentid : int (11)*