Problem 2: ER design (40%) Design a database that captures the following information: Each person is either a student or teacher, but not both. Each person has a unique ID, a name, and phone (denoted …
Problem 2: ER design (40%) Design a database that captures the following information: Each person is either a student or teacher, but not both. Each person has a unique ID, a name, and phone (denoted by the model). The university offers different courses of study. Each course has a unique name and belongs to a department. In any given school year, a given subject can be taught by only one teacher. A course can be taught over multiple years and a student may study the same course multiple times. For each student, you need to additionally record the year when he or she entered the university (the class year), as well as his or her favorite subjects. A student or a teacher can belong to one or multiple departments. You should be able to track each department’s head and its current students. Each department has multiple clubs. You should be able to track each club’s current students.
OR