-------------------------------------------------------------------------------- DROP TABLE roster; DROP TABLE instructor_info; DROP TABLE student_info; DROP TABLE course; DROP TABLE instructor; DROP TABLE student; -------------------------------------------------------------------------------- CREATE TABLE course ( course_id CHAR(8) NOT NULL PRIMARY KEY, description VARCHAR2(40) NOT NULL, price INT NOT NULL ); INSERT INTO course VALUES('X52-9272','SQL Programming Language',540); INSERT INTO course VALUES('X52-9759','XML for Web Development',1095); INSERT INTO course VALUES('X52-9740','Web Page Development with HTML',1095); INSERT INTO course VALUES('X52-9238','Introduction to Java',1095); INSERT INTO course VALUES('X52-9742','Intensive Web Development',3995); INSERT INTO course VALUES('X52-9755','JavaScript',1095); INSERT INTO course VALUES('X52-9267','Object Oriented Analysis and Design',995); INSERT INTO course VALUES('X52-9562','Java Web Services',1095); commit; -------------------------------------------------------------------------------- DROP SEQUENCE seq_instructor; CREATE SEQUENCE seq_instructor; CREATE TABLE instructor ( inst_id INT NOT NULL PRIMARY KEY, lname VARCHAR2(20) NOT NULL, fname VARCHAR2(20) NOT NULL, ssn CHAR(11) NOT NULL UNIQUE, sex CHAR(1) NOT NULL CHECK (sex='M' OR sex='F') ); CREATE INDEX inst_name_idx ON instructor (lname, fname); INSERT INTO instructor VALUES(seq_instructor.NEXTVAL,'Sultan','Sam','000-02-0001','M'); INSERT INTO instructor VALUES(seq_instructor.NEXTVAL,'Pefanis','George','000-02-0002','M'); INSERT INTO instructor VALUES(seq_instructor.NEXTVAL,'martin','susan','000-02-0003','F'); INSERT INTO instructor VALUES(seq_instructor.NEXTVAL,'Paller','Marc','000-02-0004','M'); INSERT INTO instructor VALUES(seq_instructor.NEXTVAL,'O''Brien','Mary','000-02-0005','F'); INSERT INTO instructor VALUES(seq_instructor.NEXTVAL,'Katz','Eric','000-02-0006','M'); commit; -------------------------------------------------------------------------------- DROP SEQUENCE seq_student; CREATE SEQUENCE seq_student; CREATE TABLE student ( stu_id INT NOT NULL, lname VARCHAR2(20) NOT NULL, fname VARCHAR2(20) NOT NULL, ssn CHAR(11) NOT NULL, sex CHAR(1) NOT NULL, -- CONSTRAINT student_pk PRIMARY KEY (stu_id), CONSTRAINT stu_ssn_uq UNIQUE (ssn), CONSTRAINT stu_sex_chk CHECK (sex IN ('M','F')) ); CREATE INDEX stu_name_idx ON student (lname, fname); INSERT INTO student VALUES(seq_student.NEXTVAL,'Burns','Barbara','000-01-0001','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Cambria','Vincent','000-01-0002','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Davidson','Duncan','000-01-0003','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Smith','David','000-01-0004','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Thomas','Eugene','000-01-0005','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Owens','Cynthia','000-01-0006','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Willis','Eileen','000-01-0007','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Myers','Rick','000-01-0008','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Ryan','Natasha','000-01-0009','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Stack','Patrick','000-01-0010','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Tobias','Wayne','000-01-0011','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Race','Joseph','000-01-0012','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Nelson','Colette','000-01-0013','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Brinson','Angel','000-01-0014','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Soley','John','000-01-0015','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Grace','Robert','000-01-0016','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Tok','Kathy','000-01-0017','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'miller','janet','000-01-0018','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Austin','Maria','000-01-0019','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Teagan','Edward','000-01-0020','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Milgrom','Anya','000-01-0021','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Vasquez','Lillian','000-01-0022','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Chan','David','000-01-0023','M'); INSERT INTO student VALUES(seq_student.NEXTVAL,'James','Phyllis','000-01-0024','F'); INSERT INTO student VALUES(seq_student.NEXTVAL,'Sultan','Sam','000-02-0001','M'); commit; -------------------------------------------------------------------------------- DROP SEQUENCE seq_instructor_info; CREATE SEQUENCE seq_instructor_info; CREATE TABLE instructor_info ( row_pk INT NOT NULL PRIMARY KEY, inst_id INT NOT NULL, lname VARCHAR2(20), fname VARCHAR2(20), ssn CHAR(11), sex CHAR(1) CHECK (sex IN ('M','F')), active_status CHAR(1), start_date DATE DEFAULT SYSDATE, specialty VARCHAR2(99), addr_type CHAR(1), street1 VARCHAR2(50), street2 VARCHAR2(50), city VARCHAR2(25), state CHAR(2), country VARCHAR2(20), -- CONSTRAINT inst_fk FOREIGN KEY (inst_id) REFERENCES instructor (inst_id) ); INSERT INTO instructor_info VALUES(seq_instructor_info.NEXTVAL,1,'Sultan','Sam','000-02-0001','M','A','01-SEP-1999','Web technology, Java, XML, SQL','H','123 Main Street',null,'Bronx','NY',null); INSERT INTO instructor_info VALUES(seq_instructor_info.NEXTVAL,1,'Sultan','Sam','000-02-0001','M','A','01-SEP-1999','Web technology, Java, XML, SQL','W','7 East 12 Street',null,'New York','NY',null); INSERT INTO instructor_info VALUES(seq_instructor_info.NEXTVAL,2,'Pefanis','George','000-02-0002','M','A','15-FEB-2000','ASP, .NET, HTML',null,null,null,null,null,null); INSERT INTO instructor_info VALUES(seq_instructor_info.NEXTVAL,3,'martin','susan','000-02-0003','F','A','01-JUL-1998',null,'H','5 West 4th Street','Apt 44','New York','NY',null); INSERT INTO instructor_info VALUES(seq_instructor_info.NEXTVAL,4,'Paller','Marc','000-02-0004','M','A','01-JAN-1995','Oracle, DB2',null,null,null,null,null,null); INSERT INTO instructor_info VALUES(seq_instructor_info.NEXTVAL,5,'O''Brien','Mary','000-02-0005','F','I','25-MAR-2003',null,'H','121 Eleventh Avenue',null,'New York','NY',null); INSERT INTO instructor_info VALUES(seq_instructor_info.NEXTVAL,5,'O''Brien','Mary','000-02-0005','F','I','25-MAR-2003',null,'W','48 East 42 Street',null,'New York','NY',null); INSERT INTO instructor_info VALUES(seq_instructor_info.NEXTVAL,6,'Katz','Eric','000-02-0006','M','A','15-MAY-2001','JavaScript, C, Flash',null,null,null,null,null,null); commit; -------------------------------------------------------------------------------- DROP SEQUENCE seq_student_info; CREATE SEQUENCE seq_student_info; CREATE TABLE student_info ( row_pk INT NOT NULL PRIMARY KEY, stu_id INT NOT NULL, lname VARCHAR2(20), fname VARCHAR2(20), ssn CHAR(11), sex CHAR(1) CHECK (sex IN ('M','F')), email VARCHAR2(99), addr_type CHAR(1), street1 VARCHAR2(50), street2 VARCHAR2(50), city VARCHAR2(25), state CHAR(2), country VARCHAR2(20), -- CONSTRAINT stu_fk FOREIGN KEY (stu_id) REFERENCES student (stu_id) ); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,1,'Burns','Barbara','000-01-0001','F','barbara.burns@nyu.edu','H','121 First Avenue',null,'New York','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,2,'Cambria','Vincent','000-01-0002','M','vcambria@yahoo.com',null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,3,'Davidson','Duncan','000-01-0003','M','duncan.davidson@nyu.edu','H','222 Second Avenue',null,'Brooklyn','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,3,'Davidson','Duncan','000-01-0003','M','duncan.davidson@nyu.edu','W','126 Madison Avenue',null,'New York','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,3,'Davidson','Duncan','000-01-0003','M','davidson123@aol.com','H','222 Second Avenue',null,'Brooklyn','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,3,'Davidson','Duncan','000-01-0003','M','davidson123@aol.com','W','126 Madison Avenue',null,'New York','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,4,'Smith','David','000-01-0004','M',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,5,'Thomas','Eugene','000-01-0005','M','ethomas@xyz.com','W','323 Third Avenue',null,'Bronx','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,6,'Owens','Cynthia','000-01-0006','F',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,7,'Willis','Eileen','000-01-0007','F',null,'H','424 Forth Avenue',null,'New York','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,8,'Myers','Rick','000-01-0008','M','rick.myers@nyu.edu',null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,8,'Myers','Rick','000-01-0008','M','rick.myers@abc.com',null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,8,'Myers','Rick','000-01-0008','M','myers101@aol.com',null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,9,'Ryan','Natasha','000-01-0009','F',null,'W','525 Fifth Avenue',null,'Yonkers','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,10,'Stack','Patrick','000-01-0010','M',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,11,'Tobias','Wayne','000-01-0011','M',null,'W','626 Sixth Avenue',null,'Hoboken','NJ',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,12,'Race','Joseph','000-01-0012','M','joerace321@xyz.tv',null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,13,'Nelson','Colette','000-01-0013','F',null,'H','727 Seventh Avenue',null,'New York','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,14,'Brinson','Angel','000-01-0014','F',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,15,'Soley','John','000-01-0015','M','soleyj@nyu.edu','H','828 Eight Avenue',null,'New York','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,16,'Grace','Robert','000-01-0016','M',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,17,'Tok','Kathy','000-01-0017','F',null,'W','929 Ninth Avenue',null,'Brooklyn','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,18,'miller','janet','000-01-0018','F',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,19,'Austin','Maria','000-01-0019','F',null,'H','101 Tenth Avenue',null,'Newark','NJ',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,20,'Teagan','Edward','000-01-0020','M',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,21,'Milgrom','Anya','000-01-0021','F',null,'H','1 Ontario Drive',null,'Toronto',null,'Canada'); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,21,'Milgrom','Anya','000-01-0021','F',null,'W','1155 Browdway',null,'New York','NY',null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,22,'Vasquez','Lillian','000-01-0022','F',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,23,'Chan','David','000-01-0023','M',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,24,'James','Phyllis','000-01-0024','F',null,null,null,null,null,null,null); INSERT INTO student_info VALUES(seq_student_info.NEXTVAL,25,'Sultan','Sam','000-02-0001','M',null,null,null,null,null,null,null); commit; -------------------------------------------------------------------------------- DROP SEQUENCE seq_roster; CREATE SEQUENCE seq_roster; CREATE TABLE roster ( roster_pk INT NOT NULL PRIMARY KEY, stu_id INT, stu_lname VARCHAR2(20), stu_fname VARCHAR2(20), stu_ssn CHAR(11), stu_sex CHAR(1) CHECK (stu_sex IN ('M','F')), session_id INT, course_id CHAR(8), description VARCHAR(40), price INT, inst_id INT, inst_lname VARCHAR2(20), inst_fname VARCHAR2(20), inst_ssn CHAR(11), inst_sex CHAR(1) CHECK (inst_sex IN ('M','F')), -- CONSTRAINT stu_id_fk FOREIGN KEY (stu_id) REFERENCES student (stu_id), CONSTRAINT inst_id_fk FOREIGN KEY (inst_id) REFERENCES instructor (inst_id), CONSTRAINT course_fk FOREIGN KEY (course_id) REFERENCES course (course_id) ); INSERT INTO roster VALUES(seq_roster.NEXTVAL,1,'Burns','Barbara','000-01-0001','F',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,1,'Burns','Barbara','000-01-0001','F',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,2,'Cambria','Vincent','000-01-0002','M',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,2,'Cambria','Vincent','000-01-0002','M',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,3,'Davidson','Duncan','000-01-0003','M',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,3,'Davidson','Duncan','000-01-0003','M',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,3,'Davidson','Duncan','000-01-0003','M',1,'X52-9755','JavaScript',1095,6,'Katz','Eric','000-02-0006','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,4,'Smith','David','000-01-0004','M',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,4,'Smith','David','000-01-0004','M',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,5,'Thomas','Eugene','000-01-0005','M',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,5,'Thomas','Eugene','000-01-0005','M',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,6,'Owens','Cynthia','000-01-0006','F',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,6,'Owens','Cynthia','000-01-0006','F',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,6,'Owens','Cynthia','000-01-0006','F',1,'X52-9755','JavaScript',1095,6,'Katz','Eric','000-02-0006','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,7,'Willis','Eileen','000-01-0007','F',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,7,'Willis','Eileen','000-01-0007','F',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,8,'Myers','Rick','000-01-0008','M',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,8,'Myers','Rick','000-01-0008','M',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,8,'Myers','Rick','000-01-0008','M',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,9,'Ryan','Natasha','000-01-0009','F',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,9,'Ryan','Natasha','000-01-0009','F',1,'X52-9755','JavaScript',1095,6,'Katz','Eric','000-02-0006','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,10,'Stack','Patrick','000-01-0010','M',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,10,'Stack','Patrick','000-01-0010','M',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,10,'Stack','Patrick','000-01-0010','M',1,'X52-9740','Web Page Development with HTML',1095,2,'Pefanis','George','000-02-0002','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,11,'Tobias','Wayne','000-01-0011','M',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,12,'Race','Joseph','000-01-0012','M',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,12,'Race','Joseph','000-01-0012','M',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,12,'Race','Joseph','000-01-0012','M',1,'X52-9755','JavaScript',1095,6,'Katz','Eric','000-02-0006','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,13,'Nelson','Colette','000-01-0013','F',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,13,'Nelson','Colette','000-01-0013','F',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,14,'Brinson','Angel','000-01-0014','F',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,14,'Brinson','Angel','000-01-0014','F',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,15,'Soley','John','000-01-0015','M',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,15,'Soley','John','000-01-0015','M',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,15,'Soley','John','000-01-0015','M',1,'X52-9755','JavaScript',1095,6,'Katz','Eric','000-02-0006','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,16,'Grace','Robert','000-01-0016','M',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,16,'Grace','Robert','000-01-0016','M',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,17,'Tok','Kathy','000-01-0017','F',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,17,'Tok','Kathy','000-01-0017','F',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,18,'miller','janet','000-01-0018','F',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,18,'miller','janet','000-01-0018','F',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,18,'miller','janet','000-01-0018','F',1,'X52-9755','JavaScript',1095,6,'Katz','Eric','000-02-0006','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,19,'Austin','Maria','000-01-0019','F',1,'X52-9759','XML for Web Development',1095,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,19,'Austin','Maria','000-01-0019','F',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,20,'Teagan','Edward','000-01-0020','M',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,20,'Teagan','Edward','000-01-0020','M',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,21,'Milgrom','Anya','000-01-0021','F',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,21,'Milgrom','Anya','000-01-0021','F',1,'X52-9755','JavaScript',1095,6,'Katz','Eric','000-02-0006','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,22,'Vasquez','Lillian','000-01-0022','F',1,'X52-9272','SQL Programming Language',540,1,'Sultan','Sam','000-02-0001','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,22,'Vasquez','Lillian','000-01-0022','F',2,'X52-9740','Web Page Development with HTML',1095,3,'martin','susan','000-02-0003','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,23,'Chan','David','000-01-0023','M',null,null,null,null,null,null,null,null,null); INSERT INTO roster VALUES(seq_roster.NEXTVAL,24,'James','Phyllis','000-01-0024','F',null,null,null,null,null,null,null,null,null); INSERT INTO roster VALUES(seq_roster.NEXTVAL,25,'Sultan','Sam','000-02-0001','M',null,null,null,null,null,null,null,null,null); INSERT INTO roster VALUES(seq_roster.NEXTVAL,null,null,null,null,null,null,null,null,null,4,'Paller','Marc','000-02-0004','M'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,null,null,null,null,null,null,null,null,null,5,'O''Brien','Mary','000-02-0005','F'); INSERT INTO roster VALUES(seq_roster.NEXTVAL,null,null,null,null,null,null,'X52-9238','Introduction to Java',1095,null,null,null,null,null); INSERT INTO roster VALUES(seq_roster.NEXTVAL,null,null,null,null,null,null,'X52-9267','Object Oriented Analysis and Design',995,null,null,null,null,null); INSERT INTO roster VALUES(seq_roster.NEXTVAL,null,null,null,null,null,null,'X52-9562','Java Web Services',1095,null,null,null,null,null); INSERT INTO roster VALUES(seq_roster.NEXTVAL,null,null,null,null,null,null,'X52-9742','Intensive Web Development',3995,null,null,null,null,null); commit;