# Database: Relational Schema Exercise - University Committees

Name: _________________________________

5 points.

A university has academic committees and wants a database to keep track of them.

### Assumptions

- Each committee may have many professors as members.
- A professor may be on several committees.
- Every committee has one chairperson, a professor, who is on the committee.
- A professor may be the chairperson of more than one committee.

### Design a schema

Draw a relational schema below to show appropriate tables and how they are related. Using crow's foot notation (indicating optional/mandatory) to show the relationships. Create bridging tables if necessary.