fejl med O'Reilly Learning SQL
HejJeg sidder med O'Reilly - Learning SQL on SQL Server 2005 (Apr 2006, og skal nu igang med at bruge det kode eksempel, som står i bogen, jeg har copy pastet det ind i min databse med SQL Server Management Studio Express, men får denne fejl, nogle som ved hvad jeg kan gøre, synes det er lidt mystisk hvis der er fejl i bogens materiale :)
Denne fejl får jeg:
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'student', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 2
Cannot drop the table 'grade_report', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the table 'section', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 4
Cannot drop the table 'department_to_major', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 5
Cannot drop the table 'plants', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 6
Cannot drop the table 'prereq', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 7
Cannot drop the table 'course', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 8
Cannot drop the table 'cap', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 9
Cannot drop the table 'room', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 10
Cannot drop the table 'teststu', because it does not exist or you do not have permission.
Hele koden:
drop table student;
drop table grade_report;
drop table section;
drop table department_to_major;
drop table plants;
drop table prereq;
drop table course;
drop table cap;
drop table room;
drop table teststu;
create table Student
(STNO SMALLINT PRIMARY KEY NOT NULL,
SNAME NVARCHAR(20) NULL,
MAJOR NVARCHAR(4) NULL,
CLASS SMALLINT NULL,
BDATE SMALLDATETIME NULL)
;
create table Grade_report
(STUDENT_NUMBER SMALLINT NOT NULL,
SECTION_ID SMALLINT NOT NULL,
GRADE CHAR(1),
CONSTRAINT stno_secid PRIMARY KEY (STUDENT_NUMBER, SECTION_ID))
;
create table Section
(SECTION_ID SMALLINT PRIMARY KEY NOT NULL,
COURSE_NUM NVARCHAR(8),
SEMESTER NVARCHAR(6),
YEAR CHAR(2),
INSTRUCTOR NVARCHAR(10),
BLDG SMALLINT,
ROOM SMALLINT)
;
create table Department_to_major
(Dcode NVARCHAR(4) PRIMARY KEY NOT NULL,
DNAME NVARCHAR(20))
;
create table Plants
(COMPANY NVARCHAR(20),
PLANTLO NVARCHAR(15))
;
create table Prereq
(COURSE_NUMBER NVARCHAR(8),
PREREQ NVARCHAR(8),
CONSTRAINT couno_pre PRIMARY KEY(COURSE_NUMBER, PREREQ))
;
create table Course
(COURSE_NAME NVARCHAR(20),
COURSE_NUMBER NVARCHAR(8) PRIMARY KEY NOT NULL,
CREDIT_HOURS SMALLINT,
OFFERING_DEPT NVARCHAR(4))
;
create table Cap
(NAME NVARCHAR(9),
LANGU NVARCHAR(7))
;
create table Room
(BLDG SMALLINT NOT NULL,
ROOM SMALLINT NOT NULL,
CAPACITY SMALLINT,
OHEAD NVARCHAR(1),
CONSTRAINT bldg_room PRIMARY KEY(BLDG, ROOM))
;
create table Dependent
(PNO SMALLINT NOT NULL,
DNAME NVARCHAR(20) NULL,
RELATIONSHIP NVARCHAR(8) NULL,
SEX CHAR(1) NULL,
AGE SMALLINT NULL)
;
insert into cap values('BRENDA','FRENCH');
insert into cap values('BRENDA','CHINESE');
insert into cap values('RICHARD','CHINESE');
insert into cap values('RICHARD','GERMAN');
insert into cap values('MARY JO','FRENCH');
insert into cap values('RICHARD','FRENCH');
insert into cap values('LUJACK','GERMAN');
insert into cap values('LUJACK','CHINESE');
insert into cap values('MARY JO','GERMAN');
insert into cap values('MARY JO','CHINESE');
insert into cap values('MELANIE','FRENCH');
insert into cap values('LUJACK','FRENCH');
insert into cap values('MELANIE','CHINESE');
insert into cap values('BRENDA','SPANISH');
insert into cap values('RICHARD','SPANISH');
insert into cap values('JOE','CHINESE');
insert into cap values('LUJACK','SPANISH');
insert into cap values('KENT','CHINESE');
insert into course values('ACCOUNTING I','ACCT2020',3,'ACCT');
insert into course values('ACCOUNTING II ','ACCT2220',3,'ACCT');
insert into course values('MANAGERIAL FINANCE','ACCT3333',3,'ACCT');
insert into course values('ACCOUNTING INFO SYST','ACCT3464',3,'ACCT');
insert into course values('INTRO TO COMPUTER SC','COSC1310',4,'COSC');
insert into course values('TURBO PASCAL','COSC2025',3,'COSC');
insert into course values('ADVANCED COBOL','COSC2303',3,'COSC');
insert into course values('DATA STRUCTURES ','COSC3320',4,'COSC');
insert into course values('DATABASE','COSC3380',3,'COSC');
insert into course values('OPERATIONS RESEARCH ','COSC3701',3,'COSC');
insert into course values('ADVANCED ASSEMBLER','COSC4301',3,'COSC');
insert into course values('SYSTEM PROJECT','COSC4309',3,'COSC');
insert into course values('ADA - INTRODUCTION','COSC5234',4,'COSC');
insert into course values('NETWORKS','COSC5920',3,'COSC');
insert into course values('ENGLISH COMP I','ENGL1010',3,'ENGL');
insert into course values('ENGLISH COMP II ','ENGL1011',3,'ENGL');
insert into course values('WRITING FOR NON MAJO','ENGL3520',2,'ENGL');
insert into course values('ALGEBRA ','MATH2333',3,'MATH');
insert into course values('DISCRETE MATHEMATICS','MATH2410',3,'MATH');
insert into course values('CALCULUS 1','MATH1501',4,'MATH');
insert into course values('AMERICAN CONSTITUTIO','POLY1201',1,'POLY');
insert into course values('INTRO TO POLITICAL S','POLY2001',3,'POLY');
insert into course values('AMERICAN GOVERNMENT ','POLY2103',2,'POLY');
insert into course values('SOCIALISM AND COMMUN','POLY4103',4,'POLY');
insert into course values('POLITICS OF CUBA','POLY5501',4,'POLY');
insert into course values('TECHNICAL WRITING ','ENGL3402',2,'ENGL');
insert into course values('FUND. TECH. WRITING ','ENGL3401',3,'ENGL');
insert into course values('INTRO TO CHEMISTRY','CHEM2001',3,'CHEM');
insert into course values('ORGANIC CHEMISTRY ','CHEM3001',3,'CHEM');
insert into course values('CALCULUS 2','MATH1502',3,'MATH');
insert into course values('CALCULUS 3','MATH1503',3,'MATH');
insert into course values('MATH ANALYSIS','MATH5501',3,'MATH');
insert into department_to_major values('ACCT','Accounting');
insert into department_to_major values('ART','Art');
insert into department_to_major values('COSC','Computer Science');
insert into department_to_major values('ENGL','English');
insert into department_to_major values('MATH','Mathematics');
insert into department_to_major values('POLY','Political Science');
insert into department_to_major values('UNKN',null);
insert into department_to_major values('CHEM','Chemistry');
insert into grade_report values(2,85,'D');
insert into grade_report values(2,102,'B');
insert into grade_report values(2,126,'B');
insert into grade_report values(2,127,'A');
insert into grade_report values(2,145,'B');
insert into grade_report values(3,85,'A');
insert into grade_report values(3,87,'B');
insert into grade_report values(3,90,'B');
insert into grade_report values(3,91,'B');
insert into grade_report values(3,92,'B');
insert into grade_report values(3,96,'B');
insert into grade_report values(3,101,null);
insert into grade_report values(3,133,null);
insert into grade_report values(3,134,null);
insert into grade_report values(3,135,null);
insert into grade_report values(8,85,'A');
insert into grade_report values(8,92,'A');
insert into grade_report values(8,96,'C');
insert into grade_report values(8,102,'B');
insert into grade_report values(8,133,null);
insert into grade_report values(8,134,null);
insert into grade_report values(8,135,null);
insert into grade_report values(10,101,null);
insert into grade_report values(10,112,null);
insert into grade_report values(10,119,null);
insert into grade_report values(10,126,'C');
insert into grade_report values(10,127,'A');
insert into grade_report values(10,145,'C');
insert into grade_report values(13,85,'B');
insert into grade_report values(13,95,'B');
insert into grade_report values(13,99,null);
insert into grade_report values(13,109,null);
insert into grade_report values(13,119,null);
insert into grade_report values(13,133,null);
insert into grade_report values(13,134,null);
insert into grade_report values(13,135,null);
insert into grade_report values(14,102,'B');
insert into grade_report values(14,112,null);
insert into grade_report values(14,91,'A');
insert into grade_report values(14,135,null);
insert into grade_report values(14,145,'B');
insert into grade_report values(14,158,'B');
insert into grade_report values(15,85,'F');
insert into grade_report values(15,92,'B');
insert into grade_report values(15,99,null);
insert into grade_report values(15,102,'B');
insert into grade_report values(15,135,null);
insert into grade_report values(15,145,'B');
insert into grade_report values(15,158,'C');
insert into grade_report values(17,112,null);
insert into grade_report values(17,119,null);
insert into grade_report values(17,135,null);
insert into grade_report values(19,102,'B');
insert into grade_report values(19,119,null);
insert into grade_report values(19,133,null);
insert into grade_report values(19,158,'D');
insert into grade_report values(20,87,'A');
insert into grade_report values(20,94,'C');
insert into grade_report values(6,201,null);
insert into grade_report values(8,201,null);
insert into grade_report values(24,90,'B');
insert into grade_report values(34,90,'B');
insert into grade_report values(49,90,'C');
insert into grade_report values(62,90,'C');
insert into grade_report values(70,90,'C');
insert into grade_report values(121,90,'B');
insert into grade_report values(122,90,'B');
insert into grade_report values(123,90,'B');
insert into grade_report values(125,90,'C');
insert into grade_report values(126,90,'C');
insert into grade_report values(127,90,'C');
insert into grade_report values(128,90,'F');
insert into grade_report values(129,90,'A');
insert into grade_report values(130,90,'C');
insert into grade_report values(131,90,'C');
insert into grade_report values(132,90,'B');
insert into grade_report values(142,90,'A');
insert into grade_report values(143,90,'B');
insert into grade_report values(144,90,'B');
insert into grade_report values(145,90,'F');
insert into grade_report values(146,90,'B');
insert into grade_report values(147,90,'C');
insert into grade_report values(148,90,'C');
insert into grade_report values(31,90,'C');
insert into grade_report values(151,90,'C');
insert into grade_report values(153,90,'C');
insert into grade_report values(155,90,'B');
insert into grade_report values(157,90,'B');
insert into grade_report values(158,90,'C');
insert into grade_report values(163,90,'C');
insert into grade_report values(161,90,'C');
insert into grade_report values(160,90,'C');
insert into grade_report values(5,90,'C');
insert into grade_report values(7,90,'C');
insert into grade_report values(9,90,'F');
insert into grade_report values(62,94,'C');
insert into grade_report values(70,94,'C');
insert into grade_report values(49,94,'C');
insert into grade_report values(5,94,'C');
insert into grade_report values(6,94,'C');
insert into grade_report values(7,94,'C');
insert into grade_report values(8,94,'C');
insert into grade_report values(9,94,'F');
insert into grade_report values(5,95,'B');
insert into grade_report values(6,95,'B');
insert into grade_report values(7,95,'B');
insert into grade_report values(8,95,'B');
insert into grade_report values(9,95,'F');
insert into grade_report values(121,95,'B');
insert into grade_report values(122,95,'B');
insert into grade_report values(123,95,'B');
insert into grade_report values(125,95,'B');
insert into grade_report values(126,95,'B');
insert into grade_report values(127,95,'B');
insert into grade_report values(128,95,'F');
insert into grade_report values(129,95,'B');
insert into grade_report values(130,95,'C');
insert into grade_report values(121,94,'B');
insert into grade_report values(122,94,'B');
insert into grade_report values(123,94,'B');
insert into grade_report values(125,94,'C');
insert into grade_report values(126,94,'C');
insert into grade_report values(127,94,'C');
insert into grade_report values(128,94,'F');
insert into grade_report values(129,94,'A');
insert into grade_report values(130,94,'C');
insert into grade_report values(24,95,'B');
insert into grade_report values(24,96,'B');
insert into grade_report values(24,97,null);
insert into grade_report values(24,98,null);
insert into grade_report values(24,99,null);
insert into grade_report values(24,100,null);
insert into grade_report values(34,98,null);
insert into grade_report values(34,97,null);
insert into grade_report values(34,93,'A');
insert into grade_report values(49,98,null);
insert into grade_report values(49,97,null);
insert into grade_report values(49,93,'A');
insert into grade_report values(123,98,null);
insert into grade_report values(123,97,null);
insert into grade_report values(123,93,'A');
insert into grade_report values(125,98,null);
insert into grade_report values(125,97,null);
insert into grade_report values(125,93,'A');
insert into grade_report values(126,98,null);
insert into grade_report values(126,97,null);
insert into grade_report values(126,93,'A');
insert into grade_report values(127,98,null);
insert into grade_report values(127,97,null);
insert into grade_report values(127,93,'A');
insert into grade_report values(142,100,null);
insert into grade_report values(143,100,null);
insert into grade_report values(144,100,null);
insert into grade_report values(145,100,null);
insert into grade_report values(146,100,null);
insert into grade_report values(147,100,null);
insert into grade_report values(148,100,null);
insert into grade_report values(142,107,null);
insert into grade_report values(143,107,null);
insert into grade_report values(144,107,null);
insert into grade_report values(145,107,null);
insert into grade_report values(146,107,null);
insert into grade_report values(147,107,null);
insert into grade_report values(148,107,null);
insert into grade_report values(142,202,null);
insert into grade_report values(143,202,null);
insert into grade_report values(144,202,null);
insert into grade_report values(145,202,null);
insert into grade_report values(146,202,null);
insert into grade_report values(147,202,null);
insert into grade_report values(148,202,null);
insert into grade_report values(142,88,null);
insert into grade_report values(143,88,null);
insert into grade_report values(144,88,null);
insert into grade_report values(145,88,null);
insert into grade_report values(146,88,null);
insert into grade_report values(147,88,null);
insert into grade_report values(148,88,null);
insert into grade_report values(142,89,'A');
insert into grade_report values(143,89,'B');
insert into grade_report values(144,89,'B');
insert into grade_report values(145,89,'F');
insert into grade_report values(146,89,'B');
insert into grade_report values(147,89,'B');
insert into grade_report values(148,89,'B');
insert into grade_report values(151,97,null);
insert into grade_report values(153,97,null);
insert into grade_report values(155,97,null);
insert into grade_report values(157,97,null);
insert into grade_report values(158,97,null);
insert into grade_report values(160,97,null);
insert into grade_report values(161,97,null);
insert into grade_report values(163,97,null);
insert into grade_report values(151,109,null);
insert into grade_report values(153,109,null);
insert into grade_report values(155,109,null);
insert into grade_report values(157,109,null);
insert into grade_report values(158,109,null);
insert into grade_report values(160,109,null);
insert into grade_report values(161,109,null);
insert into grade_report values(163,109,null);
insert into grade_report values(151,201,null);
insert into grade_report values(153,201,null);
insert into grade_report values(155,201,null);
insert into grade_report values(157,201,null);
insert into grade_report values(158,201,null);
insert into grade_report values(160,201,null);
insert into grade_report values(161,201,null);
insert into grade_report values(163,201,null);
insert into plants values('GULP OIL','PITTSBURGH');
insert into plants values('GULP OIL','GULF BREEZE');
insert into plants values('GULP OIL','MOBILE');
insert into plants values('GULP OIL','SAN FRANCISCO');
insert into plants values('GULP OIL','HONOLULU');
insert into plants values('GULP OIL','BINGHAMTON');
insert into plants values('IBN COMPUTERS','PITTSBURGH');
insert into plants values('IBN COMPUTERS','GULF BREEZE');
insert into plants values('IBN COMPUTERS','MOBILE');
insert into plants values('IBN COMPUTERS','SAN FRANCISCO');
insert into plants values('IBN COMPUTERS','HONOLULU');
insert into plants values('IBN COMPUTERS','BINGHAMTON');
insert into plants values('BO$S TIRES','PITTSBURGH');
insert into plants values('BO$S TIRES','GULF BREEZE');
insert into plants values('BO$S TIRES','MOBILE');
insert into plants values('BO$S TIRES','SAN FRANCISCO');
insert into plants values('BO$S TIRES','HONOLULU');
insert into plants values('BO$S TIRES','BINGHAMTON');
insert into plants values('BANK D$AMERICER','PITTSBURGH');
insert into plants values('BANK D$AMERICER','GULF BREEZE');
insert into plants values('BANK D$AMERICER','MOBILE');
insert into plants values('BANK D$AMERICER','SAN FRANCISCO');
insert into plants values('BANK D$AMERICER','HONOLULU');
insert into plants values('BANK D$AMERICER','BINGHAMTON');
insert into plants values('COLONEL MOTORS','PITTSBURGH');
insert into plants values('COLONEL MOTORS','GULF BREEZE');
insert into plants values('COLONEL MOTORS','SAN FRANCISCO');
insert into plants values('COLONEL MOTORS','HONOLULU');
insert into plants values('COLONEL MOTORS','BINGHAMTON');
insert into plants values('COLONEL MOTORS','TUSCALOOSA');
insert into plants values('COKE COLA','PITTSBURGH');
insert into plants values('COKE COLA','GULF BREEZE');
insert into plants values('COKE COLA','MOBILE');
insert into plants values('COKE COLA','SAN FRANCISCO');
insert into plants values('COKE COLA','HONOLULU');
insert into plants values('COKE COLA','BINGHAMTON');
insert into plants values('COKE COLA','TUSCALOOSA');
insert into plants values('WENDIES','PITTSBURGH');
insert into plants values('WENDIES','GULF BREEZE');
insert into plants values('WENDIES','MOBILE');
insert into plants values('WENDIES','SAN FRANCISCO');
insert into plants values('WENDIES','HONOLULU');
insert into plants values('WENDIES','BINGHAMTON');
insert into plants values('WENDIES','TUSCALOOSA');
insert into plants values('CAPTAIN E$S','PITTSBURGH');
insert into plants values('CAPTAIN E$S','GULF BREEZE');
insert into plants values('CAPTAIN E$S','MOBILE');
insert into plants values('CAPTAIN E$S','SAN FRANCISCO');
insert into plants values('CAPTAIN E$S','HONOLULU');
insert into plants values('CAPTAIN E$S','BINGHAMTON');
insert into plants values('CAPTAIN E$S','TUSCALOOSA');
insert into plants values('RADAR SHACK','PITTSBURGH');
insert into plants values('RADAR SHACK','GULF BREEZE');
insert into plants values('RADAR SHACK','SAN FRANCISCO');
insert into plants values('RADAR SHACK','HONOLULU');
insert into plants values('RADAR SHACK','BINGHAMTON');
insert into plants values('RADAR SHACK','TUSCALOOSA');
insert into plants values('PHIL$S BAKE SHOP','PITTSBURGH');
insert into plants values('PHIL$S BAKE SHOP','GULF BREEZE');
insert into plants values('PHIL$S BAKE SHOP','SAN FRANCISCO');
insert into plants values('PHIL$S BAKE SHOP','HONOLULU');
insert into plants values('PHIL$S BAKE SHOP','BINGHAMTON');
insert into plants values('PHIL$S BAKE SHOP','TUSCALOOSA');
insert into plants values('WYATT$S TOMBSTONE','PITTSBURGH');
insert into plants values('WYATT$S TOMBSTONE','GULF BREEZE');
insert into plants values('WYATT$S TOMBSTONE','SAN FRANCISCO');
insert into plants values('WYATT$S TOMBSTONE','HONOLULU');
insert into plants values('WYATT$S TOMBSTONE','BINGHAMTON');
insert into plants values('WYATT$S TOMBSTONE','TUSCALOOSA');
insert into plants values('EAST PUBLISHING','PITTSBURGH');
insert into plants values('EAST PUBLISHING','GULF BREEZE');
insert into plants values('EAST PUBLISHING','SAN FRANCISCO');
insert into plants values('EAST PUBLISHING','HONOLULU');
insert into plants values('EAST PUBLISHING','BINGHAMTON');
insert into plants values('EAST PUBLISHING','TUSCALOOSA');
insert into plants values('UTAH BOB$S','PITTSBURGH');
insert into plants values('UTAH BOB$S','GULF BREEZE');
insert into plants values('UTAH BOB$S','SAN FRANCISCO');
insert into plants values('UTAH BOB$S','HONOLULU');
insert into plants values('UTAH BOB$S','BINGHAMTON');
update plants set company = replace(company,'$','''');
insert into prereq values('ACCT3333','ACCT2220');
insert into prereq values('COSC3320','COSC1310');
insert into prereq values('COSC3380','COSC3320');
insert into prereq values('COSC3380','MATH2410');
insert into prereq values('COSC5234','COSC3320');
insert into prereq values('ENGL1011','ENGL1010');
insert into prereq values('ENGL3401','ENGL1011');
insert into prereq values('ENGL3520','ENGL1011');
insert into prereq values('MATH5501','MATH2333');
insert into prereq values('POLY2103','POLY1201');
insert into prereq values('POLY5501','POLY4103');
insert into prereq values('CHEM3001','CHEM2001');
insert into room values(13,101,85,'Y');
insert into room values(36,123,35,'N');
insert into room values(58,114,60,null);
insert into room values(79,179,35,'Y');
insert into room values(79,174,22,'Y');
insert into room values(58,112,40,null);
insert into room values(36,122,25,'N');
insert into room values(36,121,25,'N');
insert into room values(36,120,25,'N');
insert into room values(58,110,null,'Y');
insert into section values(85,'MATH2410','FALL','98','KING',36,123);
insert into section values(86,'MATH5501','FALL','98','EMERSON',36,123);
insert into section values(87,'ENGL3401','FALL','98','HILLARY',13,101);
insert into section values(88,'ENGL3520','FALL','99','HILLARY',13,101);
insert into section values(89,'ENGL3520','SPRING','99','HILLARY',13,101);
insert into section values(90,'COSC3380','SPRING','99','HARDESTY',79,179);
insert into section values(91,'COSC3701','FALL','98',null,79,179);
insert into section values(92,'COSC1310','FALL','98','ANDERSON',79,179);
insert into section values(93,'COSC1310','SPRING','99','RAFAELT',79,179);
insert into section values(94,'ACCT3464','FALL','98','RODRIGUEZ',74,null);
insert into section values(95,'ACCT2220','SPRING','99','RODRIQUEZ',74,null);
insert into section values(96,'COSC2025','FALL','98','RAFAELT',79,179);
insert into section values(97,'ACCT3333','FALL','99','RODRIQUEZ',74,null);
insert into section values(98,'COSC3380','FALL','99','HARDESTY',79,179);
insert into section values(99,'ENGL3401','FALL','99','HILLARY',13,101);
insert into section values(102,'COSC3320','SPRING','99','KNUTH',79,179);
insert into section values(107,'MATH2333','SPRING','00','CHANG',36,123);
insert into section values(109,'MATH5501','FALL','99','CHANG',36,123);
insert into section values(112,'MATH2410','FALL','99','CHANG',36,123);
insert into section values(119,'COSC1310','FALL','99','ANDERSON',79,179);
insert into section values(126,'ENGL1010','FALL','98','HERMANO',13,101);
insert into section values(127,'ENGL1011','SPRING','99','HERMANO',13,101);
insert into section values(133,'ENGL1010','FALL','99','HERMANO',13,101);
insert into section values(134,'ENGL1011','SPRING','00','HERMANO',13,101);
insert into section values(135,'COSC3380','FALL','99','STONE',79,179);
insert into section values(145,'COSC1310','SPRING','99','JONES',79,179);
insert into section values(158,'MATH2410','SPRING','98',null,36,123);
insert into section values(201,'CHEM2001','FALL','99',null,58,114);
insert into section values(202,'CHEM3001','SPRING','00','CARNEAU',58,null);
insert into section values(100,'POLY1201','FALL','99','SCHMIDT',null,null);
insert into section values(101,'POLY2103','SPRING','00','SCHMIDT',null,null);
insert into section values(104,'POLY4103','SPRING','00','SCHMIDT',null,null);
insert into student values(2,'Lineas','ENGL','1','15-APR-80');
insert into student values(3,'Mary','COSC','4','16-JUL-78');
insert into student values(8,'Brenda','COSC','2','13-AUG-77');
insert into student values(10,'Richard','ENGL','1','13-MAY-80');
insert into student values(13,'Kelly','MATH','4','12-AUG-80');
insert into student values(14,'Lujack','COSC','1','12-FEB-77');
insert into student values(15,'Reva','MATH','2','10-JUN-80');
insert into student values(17,'Elainie','COSC','1','12-AUG-76');
insert into student values(19,'Harley','POLY','2','16-APR-81');
insert into student values(20,'Donald','ACCT','4','15-OCT-77');
insert into student values(24,'Chris','ACCT','4','12-FEB-78');
insert into student values(34,'Lynette','POLY','1','16-JUL-81');
insert into student values(49,'Susan','ENGL','3','11-MAR-80');
insert into student values(62,'Monica','MATH','3','14-OCT-80');
insert into student values(70,'Bill','POLY',null,'14-OCT-80');
insert into student values(121,'Hillary','COSC','1','16-JUL-77');
insert into student values(122,'Phoebe','ENGL','3','15-APR-80');
insert into student values(123,'Holly','POLY','4','15-JAN-81');
insert into student values(125,'Sadie','MATH','2','12-AUG-80');
insert into student values(126,'Jessica','POLY','2','16-JUL-81');
insert into student values(127,'Steve','ENGL','1','11-MAR-80');
insert into student values(128,'Brad','COSC','1','10-SEP-77');
insert into student values(129,'Cedric','ENGL','2','15-APR-80');
insert into student values(130,'Alan','COSC','2','16-JUL-77');
insert into student values(131,'Rachel','ENGL','3','15-APR-80');
insert into student values(132,'George','POLY','1','16-APR-81');
insert into student values(142,'Jerry','COSC','4','12-MAR-78');
insert into student values(143,'Cramer','ENGL','3','15-APR-80');
insert into student values(144,'Fraiser','POLY','1','16-JUL-81');
insert into student values(145,'Harrison','ACCT','4','12-FEB-77');
insert into student values(146,'Francis','ACCT','4','11-JUN-77');
insert into student values(147,'Smithly','ENGL','2','13-MAY-80');
insert into student values(148,'Sebastian','ACCT','2','14-OCT-76');
insert into student values(31,'Jake','COSC','4','12-FEB-78');
insert into student values(151,'Losmith','CHEM','3','15-JAN-81');
insert into student values(153,'Genevieve','UNKN',null,'15-OCT-79');
insert into student values(155,'Lindsay','UNKN','1','15-OCT-79');
insert into student values(157,'Stephanie','MATH',null,'16-APR-81');
insert into student values(158,'Thornton',null,null,'15-OCT-79');
insert into student values(163,'Lionel',null,null,'15-OCT-79');
insert into student values(161,'Benny','CHEM','4','10-JUN-80');
insert into student values(160,'Gus','ART ','3','15-OCT-78');
insert into student values(5,'Zelda','COSC',null,'12-FEB-78');
insert into student values(7,'Mario','MATH',null,'12-AUG-80');
insert into student values(9,'Romona','ENGL',null,'15-APR-80');
insert into student values(6,'Ken','POLY',null,'15-JUL-80');
insert into student values(88,'Smith',null,null,'15-OCT-79');
insert into student values(191,'Jake','MATH','2','10-JUN-80');
insert into dependent values(2,'Matt','Son','M',8);
insert into dependent values(2,'Mary','Daughter','F',9);
insert into dependent values(2,'Beena','Spouse','F',31);
insert into dependent values(10,'Amit','Son','M',3);
insert into dependent values(10,'Shantu','Daughter','F',5);
insert into dependent values(14,'Raju','Son','M',1);
insert into dependent values(14,'Rani',' ','F',3);
insert into dependent values(17,'Susan','Daughter','F',4);
insert into dependent values(17,'Sam','Son','M',1);
insert into dependent values(20,'Donald II','Son','M',Null);
insert into dependent values(20,'Chris','Son','M',6);
insert into dependent values(34,'Susan','Daughter','F',5);
insert into dependent values(34,'Monica','Daughter','F',1);
insert into dependent values(62,'Tom','Husband','M',45);
insert into dependent values(62,'James','Son','M',14);
insert into dependent values(62,'Hillary','Daughter','F',16);
insert into dependent values(62,'Phoebe','Daughter','F',12);
insert into dependent values(123,'James','Son','M',5);
insert into dependent values(123,'Jon','Son','M',2);
insert into dependent values(126,'Om','Son','M',6);
insert into dependent values(126,'Prakash','Son','M',1);
insert into dependent values(128,'Mithu','Son','M',1);
insert into dependent values(128,'Mita','Daughter','F',Null);
insert into dependent values(128,'Nita','Daughter','F',2);
insert into dependent values(128,'Barbara','Wife','F',26);
insert into dependent values(132,'Rekha','Daughter','F',6);
insert into dependent values(142,'Rakhi','Daughter','F',2);
insert into dependent values(143,'Mona','Daughter','F',7);
insert into dependent values(144,'Susan','Wife','F',22);
insert into dependent values(145,'Susie','Wife','F',22);
insert into dependent values(146,'Xi du','Wife','F',22);
insert into dependent values(147,'Barbara','Wife','F',23);
insert into dependent values(147,'Sebastian','Son','M',4);
insert into dependent values(147,'Jake','Son','M',2);
insert into dependent values(147,'Losmith','Son','M',Null);
insert into dependent values(153,'Madhu','Daughter','F',5);
insert into dependent values(153,'Mamta','Daughter','F',4);
insert into dependent values(153,'Mahesh','Son','M',2);
insert into dependent values(158,'Sally','wife', 'F',22);
select top 6 sname, major, class into teststu from student;
