Exercise# 1: [10 Marks] You are asked to create a database for the university administration. They describe that they want the following objects in their system: Course having title, number, and quarter Student having name and year of study Teaching Assistant having name and contract PhD Student having name and thesis topic Lecturer having name and position They also describe the relationships between these objects: Each course is taught by a lecturer and a teaching assistant. Students follow a number of courses. Each PhD student is associated with a lecturer who is his supervisor. Keep in mind that both PhD students and teaching assistants are students. (a) Create an E/R diagram capturing the objects and relationships described above. Describe all constraints. Please use the notation for E/R diagrams introduced in the course book. (b) Transfer the E/R diagram from (a) to the relational model. Describe the process you have made