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 department may offer few courses. One or more subjects may be same for different courses as well as departments. Same subject (name) in two courses or department is separately identified by the corresponding subject_id. • Subject_id for a course of a department is unique. • A student must register to appear in the exam. A registered student is considered as exam candidate • The exam controller section is the administrator of this whole examination system. Find Entities and their relationships and Cardinalities of each relationships
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 department may offer few courses. One or more subjects may be same for
different courses as well as departments. Same subject (name) in two courses or
department is separately identified by the corresponding subject_id.
• Subject_id for a course of a department is unique.
• A student must register to appear in the exam. A registered student is considered as
exam candidate
• The exam controller section is the administrator of this whole examination system.
Find Entities and their relationships and Cardinalities of each relationships
Step by step
Solved in 2 steps with 1 images