In SQL

Design a database for a gradebook. The gradebook should support atleast three classes, multiple students per class (M:N), and one teacher per class. Items in the gradebook must include at least Tests and Assignments, although you may add other types of items if you wish. Every table will use an integer field called ID for its primary key. All foreign keys will be named [RemoteTable]ID. Table names will be singular, and follow PascalCase conventions. All Fields in a table will be singular, and follow PascalCase conventions.

The gradebook can use raw points for the grading system although bonus points will be awarded for also supporting weighted averages.

You will submit a crows foot or ERD diagram for your database, along with a written explanation of the requirements and how the design meets the requirements.

You will also create a SQL script to create the tables and assign data types and constraints to the columns in each table. For each primary key, use the T-SQL constraint IDENTITY(1,1) to allow SQL Server to seed the primary key value itself. Foreign key's will be constrained as such, using the syntax

RemoteTableID int Foreign Key References RemoteTable(ID) -- (assumes the primary key in RemoteTable is a column named ID)

Fields will not be null-able unless needed as part of the business process.

You will also create a SQL script that will insert sample seed data for testing in your database.

Submit the diagram, written explanation, and the SQL script files.