Draw an er diagram for a database based on the following information: in our database, we have students. they have a name, a registration number, and a course of study. the university offers lectures. each lecture may be part of some course of study in a certain semester. lectures may have other lectures as prerequisites. they have a title, provide a specific number of credits and have a unique id. each year, some of these lectures are offered by a professor at a certain day at a fixed time in a specific room. students may register for that lecture. professors have a name and are member of a specific department.