-- Populate database state of the "Homework" database
-- (assumes the presence of table schema and constraints)

INSERT INTO  STUDENTS(SID,FIRST,LAST,EMAIL)  VALUES (101,'Ann','Smith','ann.smith@mail.com');
INSERT INTO  STUDENTS(SID,FIRST,LAST,EMAIL)  VALUES (102,'Michael','Jones',NULL);
INSERT INTO  STUDENTS(SID,FIRST,LAST,EMAIL)  VALUES (103,'Richard','Turner','rt@geemail.org');
INSERT INTO  STUDENTS(SID,FIRST,LAST,EMAIL)  VALUES (104,'Maria','Brown','maria@univ.edu');
                       
INSERT INTO  EXERCISES(CAT,ENO,TOPIC,MAXPT) VALUES ('H',1,'Rel.Alg.',10);
INSERT INTO  EXERCISES(CAT,ENO,TOPIC,MAXPT) VALUES ('H',2,'SQL',10);            
INSERT INTO  EXERCISES(CAT,ENO,TOPIC,MAXPT) VALUES ('M',1,'SQL',14);
                        
INSERT INTO  RESULTS(SID,CAT,ENO,POINTS)   VALUES (101,'H',1,10);
INSERT INTO  RESULTS(SID,CAT,ENO,POINTS)   VALUES (101,'H',2,8);
INSERT INTO  RESULTS(SID,CAT,ENO,POINTS)   VALUES (101,'M',1,12);
INSERT INTO  RESULTS(SID,CAT,ENO,POINTS)   VALUES (102,'H',1,9);
INSERT INTO  RESULTS(SID,CAT,ENO,POINTS)   VALUES (102,'H',2,9);
INSERT INTO  RESULTS(SID,CAT,ENO,POINTS)   VALUES (102,'M',1,10);
INSERT INTO  RESULTS(SID,CAT,ENO,POINTS)   VALUES (103,'H',1,5);
INSERT INTO  RESULTS(SID,CAT,ENO,POINTS)   VALUES (103,'M',1,7);