Database comp science:

$2\mathrm{.}1)$Provide SQL Statements to Create StudentGradeReport Database, Create Tables. Use

appropriate SQL Server data types for each column. Attach as a separate $.$sql file and call it Q$21\_$DDL$.$sql$.$ HINT: These are the DDL Statements we talked about

in class for the Bike Database. Don$$t forget about the Go statements. I should be able to run

this whole file without any errors!

Include this for EACH of the required DML Operation request

$--**************************************************************************************$

$--$ CREATE OBJECT Name

$--**************************************************************************************$

DROP TABLE IF EXISTS tblDave

$--$CREATE TABLE Statements Go Here

RAISERROR $($N$\text{'}$Creating Table $\%$s$...\text{'},--$ Message text.

$10,--$ Severity,

$1,--$ State,

$\text{'}\text{'},--$First Argument

NULL, $--$ Second Argument

NULL$)$; $--$ third argument.

GO

$2\mathrm{.}2)$ Create test data and Provide SQL Statements to Load tables with test data. Attach as a

separate $.$sql file and call Q$22\_$LoadDatabaseObjects.sql$.$

Include this for EACH of the required DML Operation request

$--**************************************************************************************$

$--$ LOAD OBJECT NAME

$--**************************************************************************************$

$--$Load data statements go here.

RAISERROR $($N$\text{'}$Loading Table $\%$s$...\text{'},--$ Message text.

$10,--$ Severity,

$1,--$ State,

$\text{'}\text{'},--$First Argument

NULL, $--$ Second Argument

NULL$)$; $--$ third argument.

GO