$1.$ Review the SQL statements contained in the file below.$$

SQL Schema:$$grades$.$sql

Summarize all constraints $($L$2\mathrm{.}1$ The Relational Model & Ch$4)$ in this schema

Find and fix a minor SQL syntax error in the given schema

$2.$ Create a database using the queries specified in the schema linked above $($grades$.$sql$).$

$3.$ Record that the Database Management Systems course is a $3-$credit course with number $0145443$ and is capped at $25$ students.

$4.$ Record that prof. Smith graded Susan Cooper for the databases courses in term $1702$ with a $\text{'}$B$+\text{'}$ on January $4,2017.$

$5.$ Record that Prof. Smith updated Susan Cooper's grade from a B$+$ to an A$-$ on January $6,2017.$

$6.$Write a query that answer the following question: What are the last names of the students?

$7.$Write a query that answer the following question: What courses are offered in term $1702?$

$8.$ Write a query that answer the following question: Which students scored a B or higher for the databases course in term $1702?$

$9.$ Write a query that shows the grade roster $($firstname$,$ lastname, grade$)$ in the databases course, sorted by grade $($highest to lowest$).$

All courses and all sections $--$ CREATE TABLE courses $($ courseid INTEGER, coursename VARCHAR$(40)$ NOT NULL, credits REAL NOT NULL, max$\_$students INTEGER NOT NULL, PRIMARY KEY $($courseid$))$; $----$ People $--$ CREATE TABLE people $($ personid INTEGER, lastname VARCHAR$(80)$ NOT NULL, firstname VARCHAR$(80)$ NOT NULL, dob DATE, gender char$(1),$ is$\_$student INTEGER NOT NULL, is$\_$professor INTEGER NOT NULL, PRIMARY KEY $($personid$),$ CHECK $($gender in $(\text{'}$M$\text{'},\text{'}$F$\text{'},\text{'}$O$\text{'})))$; $----$ Records all grades for all students $--$ CREATE TABLE grades $($ studentid INTEGER, courseid INTEGER, term VARCHAR$(10),$ grade VARCHAR$(2)$ NOT NULL, professorid INTEGER NOT NULL, grade$\_$date DATE NOT NULL, PRIMARY KEY $($studentid$,$ courseid, term$),$ FOREIGN KEY $($studentid$)$ REFERENCES people$($personid$),$ FOREIGN KEY $($courseid$)$ REFERENCES courses, FOREIGN KEY $($professorid$)$ REFERENCES people$($personid$),$ CHECK $($grade IN $(\text{'}$F$\text{'},\text{'}$I$\text{'},\text{'}$D$\text{'},\text{'}$C$-\text{'},\text{'}$C$\text{'},\text{'}$C$+\text{'},\text{'}$B$-\text{'},\text{'}$B$\text{'},\text{'}$B$+\text{'},\text{'}$A$-\text{'},\text{'}$A$\text{'},\text{'}$A$+\text{'})))$; $----$ Data load $--$ INSERT INTO people $($personid$,$ lastname, firstname, dob, gender, is$\_$student, is$\_$professor$)$ VALUES $(1000000001,$ 'Smith', 'John', $\text{'}1975/1/1\text{'},\text{'}$M$\text{'},1,0)$; INSERT INTO people $($personid$,$ lastname, firstname, dob, gender, is$\_$student, is$\_$professor$)$ VALUES $(1000000002,$ 'Doe', 'Jane', $\text{'}1985/12/15\text{'},\text{'}$F$\text{'},1,0)$; INSERT INTO people $($personid$,$ lastname, firstname, dob, gender, is$\_$student, is$\_$professor$)$ VALUES $(1000000003,$ 'Greene', 'David', $\text{'}1995/6/15\text{'},\text{'}$M$\text{'},1,0)$; INSERT INTO people $($personid$,$ lastname, firstname, dob, gender, is$\_$student, is$\_$professor$)$ VALUES $(1000000004,$ 'Cooper', 'Susan', $\text{'}1998/8/12\text{'},\text{'}$F$\text{'},0,1)$;

Please help with this ill leave a good review I need to understand this more.