database design and implement

Q3 (2 pt): The university asks you to design an efficient database to store their lecturer and courses data. The requirements for the database are as follows: 1. For each lecturer, the database stores Name, Lecturer ID, and Date of Birth. 2. For each course, the database stores a Course ID, Name, Section Number 3. A lecturer can be uniquely identified by lecturer ID 4. A course can be uniquely identified by Course ID and Section Number 5. A lecturer can teach any number of courses 6. A course can only be taught by at most one lecturer. The first task to create the database is designing the E-R diagram. Please draw your E-R diagram to model all the requirements. Do not forget to draw the constraints