-- Vladimir Vacic <vladimir@vacic.org>
-- Center for Information Science and Technology
-- Temple University, Philadelphia, PA
-- Feb-21-2004

--
-- POPULATE THE STUDENTS EXAMPLE DATABASE
--


--
-- Departments at Temple's College of Science and Technology 
--

INSERT INTO departments
    VALUES ('BIO', 'Biology', 'CST')
;

INSERT INTO departments
    VALUES ('BIOPHY', 'Biophysics', 'CST')
;

INSERT INTO departments
    VALUES ('CHEM', 'Chemistry', 'CST')
;

INSERT INTO departments
    VALUES ('CIS', 'Computer and Information Sciences', 'CST')
;

INSERT INTO departments
    VALUES ('ENG', 'Engineering', 'CST')
;

INSERT INTO departments
    VALUES ('ENV', 'Environmental Studies', 'CST')
;

INSERT INTO departments
    VALUES ('GEO', 'Geology', 'CST')
;

INSERT INTO departments
    VALUES ('MATH', 'Mathematics', 'CST')
;

INSERT INTO departments
    VALUES ('MATHECO', 'Mathematical Economics', 'CST')
;

INSERT INTO departments
    VALUES ('NEUR', 'Neuroscience', 'CST')
;

INSERT INTO departments
    VALUES ('PHYS', 'Physics', 'CST')
;


--
-- Professors at Temple's IST Center
--

INSERT INTO professors
    VALUES ('2345789078', 'Zoran', null, 'Obradovic', 'Professor', 'CIS')
;

INSERT INTO professors
    VALUES ('8234578907', 'Longin', 'Jan', 'Latecki', 'Associate Professor', 'CIS')
;

INSERT INTO professors
    VALUES ('7823457890', 'Rolf', null, 'Lakaemper', 'Assistant Professor', 'CIS')
;

INSERT INTO professors
    VALUES ('0782345789', 'Vasilis', null, 'Megalooikonomou', 'Assistant Professor', 'CIS')
;

INSERT INTO professors
    VALUES ('9078234578', 'Slobodan', null, 'Vucetic', 'Assistant Professor', 'CIS')
;


--
-- students
--

INSERT INTO students
    VALUES ('7539847598', 'Queen', null, 'Victoria', 'CIS')
;

INSERT INTO students
    VALUES ('8753984759', 'Karl', null, 'Marx', 'CIS')
;

INSERT INTO students
    VALUES ('9875398475', 'Wolfgang', 'Amadeus', 'Mozart', 'CIS')
;

INSERT INTO students
    VALUES ('5987539847', 'Genghis', null, 'Khan', 'CIS')
;

INSERT INTO students
    VALUES ('7598753984', 'Rene', null, 'Descartes', 'CIS')
;

INSERT INTO students
    VALUES ('4759875398', 'Werner', null, 'Heisenberg', 'CIS')
;

INSERT INTO students
    VALUES ('1259875398', 'Mileva', null, 'Einstein', 'CIS')
;

INSERT INTO students
    VALUES ('3459875398', 'Leonard', null, 'Euler', 'CIS')
;

INSERT INTO students
    VALUES ('5659875398', 'Lucrezia', null, 'Borgia', 'CIS')
;

INSERT INTO students
    VALUES ('7859875398', 'Salome', 'de', 'Bahia', 'CIS')
;



--
-- classes
--

INSERT INTO classes
    VALUES('CIS526', 'Machine Learning', 3, 'CIS')
;

INSERT INTO classes
    VALUES('CIS525', 'Neural Computation', 3, 'CIS')
;

INSERT INTO classes
    VALUES('CIS595', 'Content Based Image and Video Retrieval', 3, 'CIS')
;

INSERT INTO classes
    VALUES('CIS596', 'Quantum Computation', 3, 'CIS')
;

INSERT INTO classes
    VALUES('CIS616', 'Introduction to Database Systems', 3, 'CIS')
;

INSERT INTO classes
    VALUES('CIS664', 'Knowledge Discovery and Data Mining', 3, 'CIS')
;


--
-- professors_classes
--

INSERT INTO professors_classes
    VALUES ('9078234578', 'CIS525', 'SPRING2004');

INSERT INTO professors_classes
    VALUES ('9078234578', 'CIS526', 'SPRING2004');

INSERT INTO professors_classes
    VALUES ('7823457890', 'CIS595', 'SPRING2004');

INSERT INTO professors_classes
    VALUES ('0782345789', 'CIS616', 'SPRING2004');

INSERT INTO professors_classes
    VALUES ('2345789078', 'CIS664', 'SPRING2004');


--
-- students_classes
--

INSERT INTO students_classes
    VALUES ('7539847598', 'CIS525', 'SPRING2004', 4.00);

INSERT INTO students_classes
    VALUES ('7539847598', 'CIS526', 'SPRING2004', 3.67);

INSERT INTO students_classes
    VALUES ('7539847598', 'CIS595', 'SPRING2004', 3.33);

INSERT INTO students_classes
    VALUES ('8753984759', 'CIS616', 'SPRING2004', 3.00);

INSERT INTO students_classes
    VALUES ('8753984759', 'CIS664', 'SPRING2004', 4.00);

INSERT INTO students_classes
    VALUES ('8753984759', 'CIS525', 'SPRING2004', 4.00);

INSERT INTO students_classes
    VALUES ('9875398475', 'CIS526', 'SPRING2004', 3.00);

INSERT INTO students_classes
    VALUES ('9875398475', 'CIS595', 'SPRING2004', 3.67);

INSERT INTO students_classes
    VALUES ('9875398475', 'CIS616', 'SPRING2004', 3.67);

INSERT INTO students_classes
    VALUES ('7598753984', 'CIS664', 'SPRING2004', 4.00);

INSERT INTO students_classes
    VALUES ('7598753984', 'CIS525', 'SPRING2004', 4.00);

INSERT INTO students_classes
    VALUES ('7598753984', 'CIS526', 'SPRING2004', 3.33);

INSERT INTO students_classes
    VALUES ('7598753984', 'CIS595', 'SPRING2004', 3.33);

INSERT INTO students_classes
    VALUES ('4759875398', 'CIS616', 'SPRING2004', 4.00);

INSERT INTO students_classes
    VALUES ('4759875398', 'CIS664', 'SPRING2004', 4.00);

INSERT INTO students_classes
    VALUES ('4759875398', 'CIS525', 'SPRING2004', 4.00);

INSERT INTO students_classes
    VALUES ('4759875398', 'CIS526', 'SPRING2004', 4.00);

INSERT INTO students_classes
    VALUES ('4759875398', 'CIS595', 'SPRING2004', 4.00);