/* Begin script ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */

/* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */
/*                                                                               */
/* INSERT statements of a sample database used in the lecture slides             */
/*                                                                               */
/* Departments offer courses                                                     */ 
/*                                                                               */
/* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */
/*                                                                               */
BEGIN;

INSERT INTO DEPARTMENT VALUES ('Computer Science','CSCI',30,'Peter',223426.9 );
INSERT INTO DEPARTMENT VALUES ('Physics','PHYS',20,'John',223453.9 );
INSERT INTO DEPARTMENT VALUES ('Engineering','ENGI',33,'Harry',313455.9 );
INSERT INTO DEPARTMENT VALUES ('Mathematics','MATH',33,'Percy',133456.9 );
INSERT INTO DEPARTMENT VALUES ('Business','BUSI',45,'Smith',224455.9 );
INSERT INTO DEPARTMENT VALUES ('Education','EDUC',23,'Sam',173557.9 );
INSERT INTO DEPARTMENT VALUES ('Arts','ARTS',15,'Daniel',163459.9 );
INSERT INTO DEPARTMENT VALUES ('Science','SCIE',35,'Albert',163459.9 );

			  
INSERT INTO COURSE VALUES('CSCI235', 'Databases', 6, 'Computer Science');
INSERT INTO COURSE VALUES('CSCI205', 'Advanced Programming', 6, 'Computer Science');
INSERT INTO COURSE VALUES('CSCI203', 'Algorithms and Data Structures', 6, 'Computer Science');
INSERT INTO COURSE VALUES('MECH111', 'Mechanics', 12, 'Physics');
INSERT INTO COURSE VALUES('CSCI111', 'C++', 6, 'Computer Science');
INSERT INTO COURSE VALUES('MATH111', 'Calculus', 12, 'Mathematics');
INSERT INTO COURSE VALUES('PHYS312', 'Relativity', 6, 'Physics');
INSERT INTO COURSE VALUES('ACCY111', 'Accounting Fundamentals', 6, 'Business');
INSERT INTO COURSE VALUES('COMM101', 'Principles of Responsible Business', 6, 'Business');
INSERT INTO COURSE VALUES('FINN111', 'Introductory Principles of Finance', 6, 'Business');
INSERT INTO COURSE VALUES('ENGG103', 'Materials in Design', 6, 'Engineering');
INSERT INTO COURSE VALUES('ENGG100', 'Engineering Computing and Analysis', 6, 'Engineering');
INSERT INTO COURSE VALUES('EDUC111', 'Introductory Principles of Education', 6, 'Education');
INSERT INTO COURSE VALUES('ARCH202', 'World Archaeology', 6, 'Science');
INSERT INTO COURSE VALUES('ENGG111', 'C++', 6, 'Engineering');

COMMIT;
/*                                                                               */
/* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */
/* End of script								 */
/* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */

/* End script   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ */;
