Case study: College Teaching System In a college we have students, department, teachers and courses. A student has name registration No and address. A teacher has name NIC and qualification. A department is known by its name e.g. CSIT, and have a HOD name, Num of students and Floor No. A course is identified by its Code. Course also have name and level of degree. A student must enrol(roll no and Semester as relationship attribute in any one department. A department can have many students. The teacher is assigned class(time and day as attribute) in more than one department. A department has many teachers. A student can study up-to 5 courses by a teacher in given classroom number. Perform the following tasks based on the above case scenario mentioned. a. Find the entity, Attribute and primary key, also draw Entity diagram. b. Draw E-R diagram for each relation, also mention the cardinality