Exercise 1: Graduate Supervision Database

Your task: Design an entity-relationship diagram (ER-diagram) that covers the requirements below. Do not forget to include cardinality and participation constraints.

Requirements:

- For each student store the name and student ID. Student IDs are unique.

- Each student has exactly one address. An address consists of street, town and postal code, and is uniquely identified by this information

- For each professor, store the name, staff ID and office number. Staff ID's are unique.

- Each student has exactly one supervisor. A professor may supervise a number of students.

- The date when supervision began also needs to be stored.

- For each research topic store the title and a short description. Titles are unique.

- Each student can be supervised in only one research topic, though topics that are currently not assigned also need to be stored in the database.