Challenge: Apply Foreign Keys to Tables

ERD

Create a students database using the following entity relationship diagram.

Problem Statement

Some things that may not be obvious from the diagram are the following:

1. All id columns are mandatory and are primary keys that take values automatically