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

relations and Insert tuples.

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

GUIDE $($Guide$\_$name, Guide$\_$No$,$ Guide$\_$reserach$\_$domain, Contat$\_$No$,$ Email$\_$Id$)$

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

$($Group$\_$Code, Roll$\_$No$,)$

PROJECT$\_$GROUP $($Group$\_$Code, Project$\_$No$,$ no$\_$of$\_$students$)$

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(10).$

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

accept only $($M$,$F$,$m$,$f$)$ 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$th

semester.

$7)$ Update guide details of a roll no $110011,$ new guide is $$Ram Mohan$$ & id

$112200.$

$8)$ Remove the Guide details, guide no is $112211$ and assign guide no $133113$ to

all respective students project group.