# Database: Relational Schema Exercise - Magazine Subscriptions

Name: _________________________________

5 points.

A publisher needs a database to keep track of magazines and subscribers. Not only may a subscriber subscribe to more than one magazine, they may subscript more than once to the same magazine. Each subscription has an expiration date.

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