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

Create a diagram for a database with following requiremengs Consider the partial

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

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!