preview

Semester Exam System Erd.Pdf

Better Essays

Semester Examination System
DBMS Lab Assignment

Group - III Srimanta Singh (004) Samik Saha (015) Prasenjit Gayen (016)

3rd yr. 1st sem., Department of Computer Sc. & Engg. Jadavpur University

ASSUMPTIONS Data requirements:

 The major characteristics of the semester examination system are……..The university has many departments which are identified basically by the department_id. Also the departments have a particular location (campus).  Each department has teachers. Each teacher is assigned to teach a particular subject. He also has to make question paper and evaluate the answer script. WE have assumed that a teacher can take classes in different department but he will belong to a particular department.  A particular …show more content…

And the participation of the weak entity set. We also have a one-to-one binary has relationship between the exam and the exam results.  Belongs to This is the 1-to-many binary relation ship set between DEPARTMENT and TEACHER sets. Because- for a particular department there are many teacher but for a teacher only 1 department is fixed. And the participation of the teacher entity sets in this relation ship sets is partial.  Teaches This is the many-to-many binary relationship sets between teacher and subjects.  Enrolls This is the one-to-one binary relationship sets between Student and Exam Candidate. Component attributes are: date, month, and year.  Sits for This is a many-to-many binary relationship sets between the Exam Candidate and the Examination.  Scheduled This is the relationship that holds between the examination and the exam routine.  Holds This is a many-to-many binary relationship set between the department and the examination.

 ISA This is a relationship set that holds between the exam and the two category of exam-regular and supplementary.  Of This relation holds between the exam and subjects as well as the subject and results.  Gets This is the relationship sets between Exam Candidate and the Results.

name dept. no. name belongs to department contact no. teacher teacher-id

has

of sub-id

name roll no. student

regd. no.

Get Access