Hello everyone,

In this class project, I turned the Database taught in the class (Company Database) into a School Database.

The tables that it has now are Students, Enrollments, and Classes. In this way, we have the names of the students that enroll in each class and we have it all set up in a relational database as Tony explains in one of the videos.

Here's an example query I wrote to find out how many DISTINCT nationalities are enrolled in each of the classes. I managed to use a Temp table and everything! It turns out that there are 3 distinct nationalities in Biology and Math, and there are 2 distinct ones in History:

So these are the tables in my relational database now:

Let me know if you have any feedback or comments and I'd be happy to check them out to improve this! Thanks!