CREATE TABLE progress(

    record_book numeric( 5 ) NOT NULL,

    subject text NOT NULL,

    acad_year text NOT NULL,

    term numeric( 1 ) NOT NULL CHECK ( term = 1 OR term = 2 ),

    mark numeric( 1 ) NOT NULL CHECK ( mark >= 3 AND mark <= 5 ) DEFAULT 5,

    FOREIGN KEY ( record_book )  REFERENCES students ( record_book )

    ON DELETE CASCADE

    ON UPDATE CASCADE

);