Question: Create a diagram for a database with following requiremengs Consider the partial University ERD. Amend the diagram to support the following following information: A faculty
Create a diagram for a database with following requiremengs

Consider the partial University ERD. Amend the diagram to support the following following information: A faculty has one or more departments, while a department belongs to one faculty. Department may have one or more professors, while a professor is a member of one or more departments. Each department has a chair (boss) who is a professor, while a professor may not be a chair of any department and is a chair of at most one department. A person may be a graduate or u/g student. For a grad student, we need to know the thesis title (i.e., we need to have the same info about the grad student as about the person (same attributes), but for a grad student, we need additional information). For an undergraduate student, we need to know the start-date. A student cannot be both a graduate and an undergraduate student. (Hint: Use subtypes.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
