1. Create a database for a school registration system. The registration system should be able to hold information for the following entities:

a. Students

b. Courses

c. Teachers

d. Grades

At the minimum, the following queries should be answered: - how many students are enrolled in a class?

- How many courses are available on a Wednesday (or any given day)?

- Who are the teachers teaching a particular course?

- What is the average GPA for a course this semester?

2. Create an ERD (entity-relationship diagram) that shows the relationships of all your tables.

3. Normalize your tables.

4. Create a one-page summary/documentation on how you were able to construct your database. What are the (possible) pain points that still exist and how do you plan to address them in the future?

5. Submit your queries, database definitions, and diagram in either a Word file or (for the queries and results) a screenshot of your SQL developer commands and results. Zip them all up into one zip file and upload to Blackboard.