Uploaded by User17111

Educational Database ERD: Courses, Students, Assignments

advertisement
Course_TimeLine
tec_ID INT
Duration INT
StartTime INT
DayofLesson INT
Course
Capacity SMALLINT
roomName VARCHAR(45)
room_ID INT
Classroom
Teacher_Name VARCH…
Content VARCHAR(10)
coutim_ID INT
userName VARCHAR(45)
cou_ID INT
Teacher
email VARCHAR(60)
TeacherName VARCHAR(45)
Active BOOL
dep_ID INT
tec_ID INT
Semester SMALLINT
CourseCode VARCHAR(10)
Cou_ID INT
File_Content2 BLOB
File_Content1 BLOB
FileName2 VARCHAR(100)
FileName1 VARCHAR(100)
Description VARCHAR(100)
Week INT
Cou_Con_ID INT
Course_Content
Indexes
Password BLOB
cou_ID INT
Edu_Type INT
CourseName VARCHAR(45)
room_ID INT
Image BLOB
userMode VARCHAR(1)
1 more...
managerMode VARCHA…
Indexes
dep_ID INT
Link_cou_ID INT
Indexes
DepartmentName VARC…
Indexes
Description BLOB
Assignment
Assi_ID INT
Description VARCHAR(100)
assi_ID INT
stu_ID BIGINT
cou_ID INT
cuttingValue DOUBLE
DeadTime DATETIME
File_Content BLOB
FileName VARCHAR(100)
per_ID INT
Indexes
Pra_ID INT
Practise
assi_ID INT
Description VARCHAR(100)
stu_ID BIGINT
cou_ID INT
cuttingValue DOUBLE
DeadTime DATETIME
Indexes
pra_ID INT
ClusterNo INT
Grade INT
File_Content BLOB
FileName VARCHAR(100)
per_ID INT
File_Content BLOB
per_ID INT
Indexes
Distance DOUBLE
FileName VARCHAR(100)
Indexes
ClusterNo INT
Grade INT
File_Content BLOB
FileName VARCHAR(100)
Indexes
Close BOOL
Student
eMail VARCHAR(60)
5 more...
Password BLOB
Indexes
Pra_Stu
Cases TEXT
ID INT
ClusterCases_Assi
Student_Name VARCHA…
stu_ID BIGINT
stu_ID BIGINT
Stu_Course
Indexes
dep_ID INT
Department
Assi_Stu
cou_ID INT
per_ID INT
Indexes
Period
per_ID INT
1 more...
PeriodName VARCHAR(45)
Indexes
ClusterCases_Pra
ID INT
par_ID INT
per_ID INT
Cases TEXT
Distance DOUBLE
Indexes
Indexes
Download