Create a database for a small school with the following specifications:

It has three departments: o English, Math, Music

It has six teachers: o John, Jane, Bob (English department) o Cathy, Peter (Math department) o Angela (Music department)

It has five students: o Kim, Harman, Mike, Jack, Jessica

It offers five courses: o English 10, English 11, Math 10, Math 11, Music Basics

A department has a department id and a department name;

A teacher has an employee id, a name, and works for a department;

A course has a course number and course name;

A student has an id, a name, and an age;

A teacher should teach at least one course;

A student should take at least one course;

The school uses a registration table to record the courses each student takes;

The school uses a schedule table to track teacher course assignments.

1. Design a database for this school. What are the tables needed?

2. Draw an ER diagram for the database with relations between tables.

3. Create the tables in the SQL Server based on the information above. Use proper primary keys and foreign keys. Take screenshots.

4. Assign courses to the teachers based on the department they belong to. Register the students in some courses as well. Take screenshots.