SQL School

DROP TABLE IF EXISTS Student ; CREATE TABLE IF NOT EXISTS Student ( idStudent INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, stdFirstName TEXT NULL DEFAULT NULL, stdLastName TEXT NULL DEFAULT NULL, stdMajor TEXT NULL DEFAULT NULL, stdStanding TEXT NULL DEFAULT NULL, stdResidence TEXT NULL DEFAULT NULL ); DROP TABLE IF EXISTS Faculty ; CREATE TABLE IF NOT EXISTS Faculty ( idFaculty INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FacFirstName TEXT NULL DEFAULT NULL, FacLastName TEXT NULL DEFAULT NULL, FacRank TEXT NULL DEFAULT NULL, FacStartDate TEXT NULL ); DROP TABLE IF EXISTS Course ; CREATE TABLE IF NOT EXISTS Course ( idCourse INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, CourseDept TEXT NULL DEFAULT NULL, CourseNumber INTEGER NULL, CourseDesc TEXT NULL DEFAULT NULL, CourseUnits INTEGER NULL ); DROP TABLE IF EXISTS Offering ; CREATE TABLE IF NOT EXISTS Offering ( idOffering INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, OffTerm TEXT NULL DEFAULT NULL, Format TEXT NULL DEFAULT NULL, Capacity INTEGER NULL, Course_idCourse INTEGER NOT NULL, Faculty_idFaculty INTEGER NOT NULL ); DROP TABLE IF EXISTS Enrollment ; CREATE TABLE IF NOT EXISTS Enrollment ( idEnrollment INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, LetterGrade TEXT NULL, GPAPoints INTEGER NULL, Student_idStudent INTEGER NOT NULL, Offering_idOffering INTEGER NOT NULL );