--classes.sql
--sql script to create and populate dataset
--Andy Harris, 05/00

DROP TABLE section;
DROP TABLE instructor;

CREATE TABLE section(
  SectionID varchar2(4) primary key,
  Course varchar2(4),
  Room varchar2(7),
  Time varchar2(12),
  Days varchar2(5),
  Instructor number
);

INSERT INTO section VALUES ('V362', 'N345', 'BS2003', '1:00', 'T, R', 1);
INSERT INTO section VALUES ('V353', 'N311', 'SL247', '9:00', 'T, R', 1);
INSERT INTO section VALUES ('V350', 'N241', 'SL247', '11:00', 'M, W', 3);
INSERT INTO section VALUES ('V356', 'N331', 'SL247', '5:45', 'M, W', 2);

CREATE TABLE instructor(
  ID number(3) primary key,
  LName varChar2(10),
  FName varchar2(10),
  Office varChar2(10),
  Email varchar2(25)
);

INSERT INTO instructor VALUES(1, 'Harris', 'Andy', 'SL280', 'aharris@cs.iupui.edu');
INSERT INTO instructor VALUES(2, 'Roberts', 'Michele', 'SL280', 'mroberts@cs.iupui.edu');
INSERT INTO instructor VALUES(3, 'Molnar', 'Bob', 'SL279', 'rmolnar@cs.iupui.edu');

SELECT * FROM section;
SELECT * FROM instructor;

SELECT section.course, instructor.FName, instructor.LName 
FROM section, instructor
WHERE section.instructor = instructor.id;