Question: 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

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.
Design an E/R diagram for this database. Replace the current ER-diagram.png with your figure (you may also use other picture formats like .jpg, but remember to change the filename in the cell below). Very briefly explain the intuitive meaning of any entity and relationship sets as needed. Do not forget to indicate keys and multiplicity of relationships, as well as ISA relationships and weak entity sets (if any), using appropriate notation.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!