ALTER TABLE STUDENT ADD CONSTRAINT C CHECK$($Major IN$(\text{'}$CS$\text{'},\text{'}$IS$\text{'},\text{'}$IT$\text{'}))$;

c$)$ ALTER TABLE STUDENT ADD Major CHAR$(2)$ IN$(\text{'}$CS$\text{'},\text{'}$IS$\text{'},\text{'}$IT$\text{'})$;

d$)$ None of the above.

Consider the following relation schema:

STUDENT

Which of the following statements creates the above relation?

a$)$ CREATE TABLE STUDENT $($

Name CHAR$(35),$

Student$\_$Number INT CHECK$($Student$\_$Number BETWEEN $1$ AND $9999),$

Class INT CHECK$($Class IN$(1,5,8,9,15))$ NOT NULL $)$;

b$)$ CREATE TABLE STUDENT $($

Name VARCHAR$(35),$

Student$\_$Number INT CHECK$($Student$\_$Number BETWEEN $1$ AND $10000),$

Class INT NOT NULL CHECK $($Class $=1$ OR Class $=5$ OR Class $=8$ OR Class $=9$ OR Class $=15)$;

c$)$ CREATE TABLE STUDENT $($

Name VARCHAR$(35),$

Student$\_$Number INT CHECK$($Student$\_$Number $>0$ AND Student$\_$Number

Class INT CHECK$($Class IN$(1,5,8,9,15)))$;

d$)$ None of the above

Consider the following relation schema:

BOOK

Maximum $5000-$The maximum number of characters is $40$

Which of the following statements creates the above relation?

a$)$ CREATE TABLE BOOK $($

Book$\_$ID DECIMAL $(3,0)$ PRIMARY KEY,

Title VARCHAR$(40)$ NOT NULL,

Publisher$\_$Name VARCHAR$(40)$ UNIQUE,

CHECK$($Book$\_$ID $>0$ AND Book$\_$ID $<mn\; id="EditorElement\_12462854">5</mn><mn\; id="EditorElement\_12462855">0</mn><mn\; id="EditorElement\_12462856">0</mn><mn\; id="EditorElement\_12462857">1</mn><mtext\; id="EditorElement\_12462418"></mtext><mi\; id="EditorElement\_12462419">)</mi>$;

b$)$ CREATE TABLE BOOK $($

Book$\_$ID INT PRIMARY KEY CHECK$($Book$\_$ID$>0$ AND Book$\_$ID

Title VARCHAR$(40),$

Publisher$\_$Name CHAR$(40)$ UNIQUE$)$;

c$)$ CREATE TABLE BOOK $($

Book$\_$ID INT PRIMARY KEY CHECK$($Book$\_$ID BETWEEN $1$ AND $5000),$

UNIQUE $($Publisher$\_$Name$),$

Title VARCHAR$(40)$ NOT NULL,

Publisher$\_$Name VARCHAR$(40))$;

d$)$ None of the above.

Consider the following relation schema:

BOOK

Which of the following statements creates the above relation?