4.1: Challenge 1

Write a single SQL query that generates the tables below:

Challenge 1

Some things to keep in mind when creating your tables:

• There is a one-to-many relationship between Student and Enrollment entities.

• There is a one-to-many relationship between Course and Enrollment entities.

• The key icon (circled in red) indicates the Primary Key for each table.

• The Navigation Properties (circled in orange) are the foreign keys within that table.

Click here to see the solution for this challenge. Then, continue to Part 4.2 for the next challenge.