CREATE TABLE STUDENT(
    SSN INT NOT NULL,
    ID INT NOT NULL,
    FIRSTNAME VARCHAR(20) NOT NULL,
    MIDDLENAME VARCHAR(20),
    LASTNAME VARCHAR(20) NOT NULL,
    RESIDENCY VARCHAR(10) NOT NULL,
    CONSTRAINT PK_STD PRIMARY KEY(SSN)
);