CREATE TABLE Student(
S_ID VARCHAR(5) NOT NULL PRIMARY KEY,
S_NAME VARCHAR(30) NOT NULL,
GENDER VARCHAR(1) NOT NULL CHECK ( [Gender] IN ('M', 'F') ),
DOB VARCHAR(8) CHECK (DOB > 'Current_Date'),
P_ID VARCHAR(5) FOREIGN KEY REFERENCES Degree_Programs(P_ID) );
CREATE TABLE Degree_Programs(
P_ID...