$1$ Single Table Constraints

Your first task as a database designer is to create an initial schema for all the tables with attributes and their abovementioned types. Adhere to the Primary Key and Foreign Key constraints, and use the same names for the tables and the columns. Additionally, add the database requirements calls for the following single table Not NULL, Unique, and check constraints:

$1\mathrm{.}1$ Not NULL and Unique Constraints:

$\backslash$table$[[$Column Name,Constraint$],[$first$\_$name,NOT NULL$],[$student$\_$id$,$NOT NULL$],[$contact$\_$number,NOT NULL, UNIQUE$],[$email$\_$id$,$UNIQUE$],[$tot$\_$credits,NOT NULL$]]$

Table $9$: student

$\backslash$table$[[$Column Name,Constraint$],[\backslash$table$[[$course$\_$id$],[$course$\_$name$],[$credits$]],$NOT NULL$],[$NOT NULL, UNIQUE,$],[$NOT NULL,$]]$

Table $10$: courses

$\backslash$table$[[$Column Name,Constraint$],[$grade$,$NOT NULL$]]$

Table $11$: student$\_$courses

$\backslash$table$[[$Column Name,Constraint$],[$semester$,$NOT NULL$]]$

Table $12$: course$\_$offers

$\backslash$table$[[$Column Name,Constraint$],[$professor$\_$first$\_$name,NOT NULL$],[$professor$\_$last$\_$name,NOT NULL$],[$contact$\_$numner,NOT NULL$]]$

Table $13$: professor

$\backslash$table$[[$Column Name,Constraint$],[$entry$\_$year,NOT NULL$],[$seq$\_$number,NOT NULL$]]$

Table $14$: valid$\_$entry

$4$

$\backslash$table$[[$Column Name,Constraint$],[$dept$\_$name,NOT NULL, UNIQUE$]]$

Table $15$: department

$1\mathrm{.}2$ Check Constraints:

tot$\_$credits in the student table should be greater than or equal to $0.$

credits in the courses table should be greater than $0.$

grade in student$\_$courses should be between $0$ and $10($inclusive$).$

start$\_$year should be less than or equal to resign$\_$year in the professor table.

semester should either be $1$ or $2$ in course$\_$of fers and student$\_$courses tables.

course$\_$id must have first $3$ characters as some dept$\_$id and next $3$ characters must be digits.