# Uncomment these once they are defined
DROP TABLE Student;
DROP TABLE Student_Extra;
DROP TABLE ProjGroup;
DROP TABLE Assignment;
DROP TABLE Grade;
DROP TABLE LetterGrade;
DROP TABLE Demo;
DROP TABLE TimeSlot;

CREATE TABLE Student
   (Name              CHAR(64) NOT NULL,
    Id                INT      NOT NULL,
                      PRIMARY KEY (Id),
    Email             CHAR(64),
    Section           Int);

CREATE TABLE Student_Extra
   (Id                INT      NOT NULL,
                      PRIMARY KEY (Id),
    Password          CHAR(64),
    GroupId           INT);    
    
CREATE TABLE ProjGroup
   (GroupId           INT      NOT NULL,
                      PRIMARY KEY (GroupId),
    Name              CHAR(64) NOT NULL);

CREATE TABLE Assignment
   (AssignId          INT      NOT NULL,
                      PRIMARY KEY (AssignId),
    Descript          CHAR(16),
    Points            INT);

CREATE TABLE Grade
   (Id                INT           NOT NULL,
    AssignID          INT           NOT NULL,
                      PRIMARY KEY (Id, AssignId),
    Value             FLOAT);

CREATE TABLE LetterGrade
   (Id                INT      NOT NULL,
                      PRIMARY KEY (Id),
    Letter            CHAR(3),
    Reason            CHAR(128));

CREATE TABLE Demo
   (GroupId           INT      NOT NULL,
                      PRIMARY KEY (GroupId),
    SlotId            INT);

CREATE TABLE TimeSlot
   (SlotId            INT      NOT NULL,
                      PRIMARY KEY (SlotId),
    SlotDesc          CHAR(16),
    Number            INT);