Teacher's code, Teacher's name, Teacher's address, rank, department,
course taught by the teacher, Course name, credit for course, No of
students in the class, course taught in Semester no., Student no.,name,
dept, year and courses taken in semester no. The following
information is given on dependencies.
i) A teacher may teach more than one course in a semester
ii) A teacher is affiliated to only one department
iii) A student may take many courses in a semester.
iv) The same course may have more than one section and
different sections will be taught by different teachers..
v) A course may be taught in more than one semester.
Deduce the E-R Diagram for the above.
b) What are the drawbacks of E-R models
