# Database: Relational Schema Exercise - University Committees Chairperson

Name: _________________________________

5 points.

The following relational schema shows which professors are on which committees.

INSERT SCHEMA

### Assumptions

You need to indicate who the chariperson of each committee is, subject to the following constraints.

- Every committee has one chairperson, a professor, who is on the committee.
- A professor may be the chairperson of more than one committee.

### Modify the schema

Redraw the relational schema to show how you would add the chairperson, eg, as additional fields or tables. Use crow's foot notation.