$--$ #$1$ Add a statement below to DROP the database if it exists

$--$ #$2$ Add a statement below to CREATE the database

$--$ #$3$ Add a statement to USE the database

$--$ class table statementCREATE TABLE IF NOT EXISTS grades.class $($

class$\_$id INT NOT NULL AUTO$\_$INCREMENT,

department$\_$code CHAR$(4)$ NULL,

course$\_$number INT NULL,

course$\_$section CHAR$(4)$ NULL,

course$\_$name VARCHAR$(100)$ NULL,

academic quarter CHAR$(2)$ NULL,

academic$\_$year INT NULL,

PRIMARY KEY $($class$\_$id$)$

:

INSERT INTO grades.class $($department$\_$code, course$\_$number, course$\_$section,

course$\_$name, academic$\_$quarter, academic$\_$year$)$

VALUES $(\text{'}$INFO$\text{'},\text{'}1335\text{'},\text{'}$WW$\text{'},$ 'Full Stack App Development', $\text{'}$FA$\text{'},\text{'}2023\text{'})$;

$----$

CREATE TABLE IF NOT EXISTS grades.assignment $($

grade$\_$id INT NOT NULL AUTO$\_$INCREMENT,

task$\_$me VARCHAR$(100)$ NULI,

points$\_$earned INT NOT NULL,

points$\_$possible INT NOT NULL,

class$\_$id INT NOT NULL,

PRIMARY KEY $($grade id$),$

CONSTRAINT fk$\_$assignment$\_$class

FOREIGN KEY $($class$\_$id$)$ REFERENCES class $($class$\_$id$)$

$--$ grant priviledges for mgs user $----------------------------$

GRANT DELETE, INSERT, SELECT, UPDATE ON grades.$*$ TO mgs$\_$user@localhost;A$.$ Log in to your VM$.$

Note: For help, reference Accessing your VM$.$

B$.$ Download this SQL script: createGradesDbScript.sql darr

C$.$ Launch MySQL Workbench and connect to MySQL$.$

Important: Make sure to analyze the script file and make note of important table and column attributes, including the primary and foreign keys and what values are automatically

generated for you $($eg$.$ auto$-$increments$).$ For your reference, below is a Entity Relationship Diagram $($ERD$)$ showing the entity structure and the relationship of the tables.

E$.$ Finish writing the script so that it creates a database called grades and two tables called class and assignment with a $1$:M relationship respectively.

Note: Please follow the three commented prompts in the provided script. The CREATE statements for the class and assignment tables are already written for you. The script also

contains pre$-$written insert statements, one record for each table.

F$.$ Run the script by clicking on

G$.$ Save this updated SQL Script by selecting File $>$ Save Script As$...$ from the menu. Name your script myCreateScript.

Note: Later, you will submit this script file as a deliverable for the final project.

H$.$ Tol Take a screenshot showing that your grades database exists with the appropriate tables in MySQL Workbench. Name the screenshot gradesDb.