# Database: Relational Schema Exercise - School Districts

Name: _________________________________

5 points.

The state of Michigan wants a database containing each school in the state. This database will be used to locate all the schools in a district, county, or the entire state. Given a school it will also be able to get the district and county.

### Assumptions

- Each school is in one school district.
- Each school district is in a county.
- The only fields you need to show are the id and name of the entity, altho there would naturally be many more attributes for each table.

For example, Lawson Middle School is in the Ann Arbor School District, which is located in Washtenaw County.

## Draw the schema

Draw a relational schema to show these tables and how they are related. Use crow's foot notation (indicating optional/mandatory) to show the relationship between primary and foreign keys. Create bridging tables if necessary.