Database Reference
In-Depth Information
Relational Scheme
student (regID, name, degree, year, deptID, guide )
Here, degree is the program ( BA, MA, LLB, LLM, Ph D etc) for which the student has
joined. Year is the year of admission and guide is the empID of a faculty member.
department (deptID, name, hod, contactNo)
teacher (empID, name, gender, doj, deptID, phone)
Here, dj is the year of joining of the faculty member in the department deptId.
course
(courseID, cname, MaxMarks, deptID )
Here, deptID indicates the department that offers the course.
admission(regID, courseID, semester, year, marksObt )
Here, semester can be either “odd”or “even” indicating the two semesters of an academic
year. The value of marksObt will be NULL for the current semester and NONNULL for
past semesters.
teaching (empID, courseId, semester, year, classRoom)
