Create a relational database schema for a Minor$-$Project, described by the following

relations and Insert tuples.

STUDENT $($Rollnea$\_$Name, Sem, Degree, Contact no$,$ Guide$\_$No$)$

GUIDE $($Guide$\_$name, Contat$\_$No$,$ Email$\_$ld$)$

PROJECT Project$\_$Area, Start$\_$dt$,$ dt$,$ Guide$\_$No$,)$ GROUP

$($Group$-$Code.$-$RQlLNQ$.)$

PROJECT$\_$GROUP $($Group Code. Project No$.$

Specify the following queries in SQL on the database schema Minor$\_$Project $.$

$1)$ Change the data type of attribute Rollo $($Student Table$),$ from Number $(10)$ to

Varchar$2($IO$).$

$2)$ Add a Check constraint on Gender attribute$($Student Table$)$ such that this attribute

accept only values.

$3)$ Add a constraint on Degree $($Student table$),$ such that no null values be inserted.

$4)$ Find the list of guide, who are guiding more than two student groups.

$5)$ Find the list of project no$,$ project name & name of guide, in domain of DataBase.

$6)$ Update the project start$\_$date with $01$ July $2015$ for student, who enrolled in $7$

semester.

$7)$ Update guide details of a roll no $\text{'}110011\text{'},$ new guide is 'Ram Mohan' & id

$\text{'}112200\text{'}.$

$8)$ Remove the Guide details, guide no is $\text{'}112211\text{'}$ and assign guide no $"133113"$ to

all respective students project group.