Create a file Assignment$6.$sql and add commented queries that do what is needed for the tasks that follow.

When creating a table table$\_$name or view wiew$\_$name, use this syntax to avoid errors when re$-$running:

DROP TABLE IF EXISTS table$\_$name;

CREATE TABLE table$\_$name...

CREATE OR REPLACE VIEW view$\_$name AS SELECT...

followed by the statement that generates the content of the table or view

$[4]$ Create a table grade$\_$points $($grade$,$ points$)$ that maps letter grades to number grades.

The highest grade is A $(=4\mathrm{.}0),$ the lowest is F $(=0\mathrm{.}0),$ and a $+$ and $-$ respectively increase $/$ decrease the value by $0\mathrm{.}3($i$.$e$.$ B$+=3\mathrm{.}3$ and B$-=2\mathrm{.}7).$ There is no grade A$+$ or F$-.$

Set grade as your primary key, both because it is inherently appropriate to have a primary key and because you need it $($or at least a unique constraint$)$ for the foreign key in the next task.

Create a "check constraint" to ensure that the points attribute is within the range $[0,4].$ The syntax for a check constraint is CONSTRAINT constraint$\_$name CHECK$($constraint conditions...$).$ Beware that some older versions of MySQL parse and store the check constraint, but do not enforce it; go ahead and add it$,$ and don$$t worry if it isn$$t enforced.

$[5]$ Add a foreign key from the grade column in the existing takes table to the new grade$\_$points table.

Use the syntax ALTER TABLE table$\_$name followed by the changes to the table

$[6]$ Create a view v$\_$takes$\_$points that returns the data in takes table along with the numeric equivalent of the grade.

$[7]$ Compute the total number of grade points $($credits $*$ grade points$)$ earned by student X $($pick a student id from the DB$).$ You will need to join takes, course, and the new grade$\_$points tables. If the student is in the system, but hasn't taken any courses, the student's total points is $0.$

$[8]$ Compute the GPA $-$ i$.$e$.$ total grade points $/$ total credits $-$ for the same student in the previous question.

$[9]$ Find the GPA of all students, i$.$e$.$ not just for one student at a time.

$[10]$ Create a view v$\_$student$\_$gpa $($id$,$ gpa$)$ that gives a dynamic version of the information in the previous question.