![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to installPEOPLE.sqlsybase CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / PeopleDBScripts|
Return to installPEOPLE.sqlsybase CVS log | Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / PeopleDBScripts |
1.1 root 1: /******************************************************************************
2: * Create the PEOPLE database by pasting this file into an isql terminal window.
3: ******************************************************************************/
4: use master
5: go
6: drop database PEOPLE
7: go
8:
9: create database PEOPLE
10: go
11: use PEOPLE
12: go
13:
14: /******************************************************************************
15: * Cut below this banner to just drop the tables.
16: *
17: ******************************************************************************/
18: drop table EMPLOYEE
19: go
20: drop table DEPARTMENT
21: go
22: drop table FACILITY
23: go
24: drop table EMP_PROJECT
25: go
26: drop table PROJECT
27: go
28: drop table EMP_PHOTO
29: go
30: drop table EMP_QUOTE
31: go
32: drop table JOB_TITLE
33: go
34: drop table EMP_EQUIPMENT
35: go
36: drop table UNIQUE_KEY
37: go
38:
39:
40: /******************************************************************************
41: * Create the tables.
42: ******************************************************************************/
43: create table EMPLOYEE (
44: EMP_ID int,
45: DEPT_ID int null,
46: LAST_NAME varchar(40),
47: FIRST_NAME varchar(40),
48: PHONE char(12) null,
49: ADDRESS varchar(40) null,
50: CITY varchar(20) null,
51: STATE char(2) null,
52: ZIP char(5) null,
53: TITLE_ID int null,
54: HIRE_DATE datetime null,
55: MANAGER int null,
56: SALARY float null
57: )
58: go
59:
60: grant all on EMPLOYEE to public
61: go
62:
63: create table DEPARTMENT (
64: DEPT_ID int,
65: DEPARTMENT_NAME varchar(30),
66: LOCATION_ID int
67: )
68: go
69:
70: grant all on DEPARTMENT to public
71: go
72:
73: create table FACILITY (
74: LOCATION_ID int,
75: LOCATION varchar(30),
76: PHOTO image null
77: )
78: go
79:
80: grant all on FACILITY to public
81: go
82:
83: create table EMP_PROJECT (
84: EMP_ID int,
85: PROJECT_ID int,
86: )
87: go
88:
89: grant all on EMP_PROJECT to public
90: go
91:
92: create table PROJECT (
93: PROJECT_ID int,
94: PROJECT_NAME varchar(30),
95: SUMMARY_IMAGE image null
96: )
97: go
98:
99: grant all on PROJECT to public
100: go
101:
102: create table EMP_PHOTO (
103: EMP_ID int,
104: PHOTO image null
105: )
106: go
107:
108: grant all on EMP_PHOTO to public
109: go
110:
111: create table EMP_QUOTE (
112: EMP_ID int,
113: QUOTE image null
114: )
115: go
116:
117: grant all on EMP_QUOTE to public
118: go
119:
120: create table JOB_TITLE (
121: TITLE_ID int,
122: TITLE varchar(30),
123: TITLE_TYPE varchar(12)
124: )
125: go
126:
127: grant all on JOB_TITLE to public
128: go
129:
130: create table EMP_EQUIPMENT (
131: ASSET_TAG int,
132: DESCRIPTION varchar(100) null,
133: SERIAL_NUMBER varchar(20) null,
134: EMP_ID int null
135: )
136: go
137:
138: grant all on EMP_EQUIPMENT to public
139: go
140:
141:
142: /******************************************************************************
143: * Insert values.
144: ******************************************************************************/
145: begin transaction
146: go
147:
148: insert into FACILITY values(1101, 'Waterfront One', null)
149: go
150:
151: insert into FACILITY values(1103, 'Hillside 1', null)
152: go
153:
154: insert into FACILITY values(1106, 'Hillside 2', null)
155: go
156:
157: insert into FACILITY values(1207, 'Embarcadero', null)
158: go
159:
160: insert into FACILITY values(1104, 'Arcada', null)
161: go
162:
163: insert into EMP_PROJECT values (101, 501)
164: go
165:
166: insert into EMP_PROJECT values (102, 503)
167: go
168:
169: insert into EMP_PROJECT values (103, 507)
170: go
171:
172: insert into EMP_PROJECT values (104, 510)
173: go
174:
175: insert into EMP_PROJECT values (105, 512)
176: go
177:
178: insert into EMP_PROJECT values (106, 501)
179: go
180:
181: insert into EMP_PROJECT values (107, 503)
182: go
183:
184: insert into EMP_PROJECT values (108, 507)
185: go
186:
187: insert into EMP_PROJECT values (109, 510)
188: go
189:
190: insert into EMP_PROJECT values (110, 512)
191: go
192:
193: insert into EMP_PROJECT values (111, 501)
194: go
195:
196: insert into EMP_PROJECT values (112, 503)
197: go
198:
199: insert into EMP_PROJECT values (113, 507)
200: go
201:
202: insert into EMP_PROJECT values (114, 510)
203: go
204:
205: insert into EMP_PROJECT values (115, 512)
206: go
207:
208: insert into EMP_PROJECT values (116, 501)
209: go
210:
211: insert into EMP_PROJECT values (117, 503)
212: go
213:
214: insert into EMP_PROJECT values (118, 507)
215: go
216:
217: insert into EMP_PROJECT values (119, 510)
218: go
219:
220: insert into EMP_PROJECT values (120, 512)
221: go
222:
223: insert into EMP_PROJECT values (121, 501)
224: go
225:
226: insert into EMP_PROJECT values (122, 503)
227: go
228:
229: insert into EMP_PROJECT values (123, 507)
230: go
231:
232: insert into EMP_PROJECT values (124, 510)
233: go
234:
235: insert into EMP_PROJECT values (125, 512)
236: go
237:
238: insert into EMP_PROJECT values (126, 501)
239: go
240:
241: insert into EMP_PROJECT values (127, 503)
242: go
243:
244: insert into EMP_PROJECT values (128, 507)
245: go
246:
247: insert into EMP_PROJECT values (129, 510)
248: go
249:
250: insert into EMP_PROJECT values (130, 512)
251: go
252:
253: insert into EMP_PROJECT values (131, 501)
254: go
255:
256: insert into EMP_PROJECT values (132, 503)
257: go
258:
259: insert into EMP_PROJECT values (133, 507)
260: go
261:
262: insert into EMP_PROJECT values (134, 510)
263: go
264:
265: insert into EMP_PROJECT values (135, 512)
266: go
267:
268: insert into EMP_PROJECT values (136, 501)
269: go
270:
271: insert into EMP_PROJECT values (137, 503)
272: go
273:
274: insert into EMP_PROJECT values (138, 507)
275: go
276:
277: insert into EMP_PROJECT values (139, 510)
278: go
279:
280: insert into EMP_PROJECT values (140, 512)
281: go
282:
283: insert into EMP_PROJECT values (141, 501)
284: go
285:
286: insert into EMP_PROJECT values (142, 503)
287: go
288:
289: insert into EMP_PROJECT values (143, 507)
290: go
291:
292: insert into EMP_PROJECT values (144, 510)
293: go
294:
295: insert into EMP_PROJECT values (145, 512)
296: go
297:
298: insert into EMP_PROJECT values (146, 501)
299: go
300:
301: insert into EMP_PROJECT values (147, 503)
302: go
303:
304: insert into EMP_PROJECT values (148, 507)
305: go
306:
307: insert into EMP_PROJECT values (149, 510)
308: go
309:
310: insert into EMP_PROJECT values (150, 512)
311: go
312:
313: insert into EMP_PROJECT values (151, 501)
314: go
315:
316: insert into EMP_PROJECT values (152, 503)
317: go
318:
319: insert into EMP_PROJECT values (153, 507)
320: go
321:
322: insert into EMP_PROJECT values (154, 510)
323: go
324:
325: insert into EMP_PROJECT values (155, 512)
326: go
327:
328: insert into EMP_PROJECT values (156, 501)
329: go
330:
331: insert into EMP_PROJECT values (157, 503)
332: go
333:
334: insert into EMP_PROJECT values (158, 507)
335: go
336:
337: insert into EMP_PROJECT values (159, 510)
338: go
339:
340: insert into EMP_PROJECT values (160, 512)
341: go
342:
343: insert into EMP_PROJECT values (161, 501)
344: go
345:
346: insert into EMP_PROJECT values (162, 503)
347: go
348:
349: insert into EMP_PROJECT values (163, 507)
350: go
351:
352: insert into EMP_PROJECT values (164, 510)
353: go
354:
355: insert into EMP_PROJECT values (165, 512)
356: go
357:
358: insert into EMP_PROJECT values (166, 501)
359: go
360:
361: insert into EMP_PROJECT values (167, 503)
362: go
363:
364: insert into EMP_PROJECT values (168, 507)
365: go
366:
367: insert into EMP_PROJECT values (169, 510)
368: go
369:
370: insert into EMP_PROJECT values (170, 512)
371: go
372:
373: insert into EMP_PROJECT values (171, 501)
374: go
375:
376: insert into EMP_PROJECT values (172, 503)
377: go
378:
379: insert into EMP_PROJECT values (173, 507)
380: go
381:
382: insert into EMP_PROJECT values (174, 510)
383: go
384:
385: insert into EMP_PROJECT values (175, 512)
386: go
387:
388: insert into EMP_PROJECT values (176, 501)
389: go
390:
391: insert into EMP_PROJECT values (177, 503)
392: go
393:
394: insert into EMP_PROJECT values (178, 507)
395: go
396:
397: insert into EMP_PROJECT values (179, 510)
398: go
399:
400: insert into EMP_PROJECT values (180, 512)
401: go
402:
403: insert into EMP_PROJECT values (181, 501)
404: go
405:
406: insert into EMP_PROJECT values (182, 503)
407: go
408:
409: insert into EMP_PROJECT values (183, 507)
410: go
411:
412: insert into EMP_PROJECT values (184, 510)
413: go
414:
415: insert into EMP_PROJECT values (185, 512)
416: go
417:
418: insert into EMP_PROJECT values (186, 501)
419: go
420:
421: insert into EMP_PROJECT values (187, 503)
422: go
423:
424: insert into EMP_PROJECT values (188, 507)
425: go
426:
427: insert into EMP_PROJECT values (189, 510)
428: go
429:
430: insert into EMP_PROJECT values (190, 512)
431: go
432:
433: insert into EMP_PROJECT values (191, 501)
434: go
435:
436: insert into EMP_PROJECT values (192, 503)
437: go
438:
439: insert into EMP_PROJECT values (193, 507)
440: go
441:
442: insert into EMP_PROJECT values (194, 510)
443: go
444:
445: insert into EMP_PROJECT values (195, 512)
446: go
447:
448: insert into EMP_PROJECT values (196, 501)
449: go
450:
451: insert into EMP_PROJECT values (197, 503)
452: go
453:
454: insert into EMP_PROJECT values (198, 507)
455: go
456:
457: insert into EMP_PROJECT values (199, 510)
458: go
459:
460: insert into EMP_PROJECT values (200, 512)
461: go
462:
463: insert into EMP_PROJECT values (201, 501)
464: go
465:
466: insert into EMP_PROJECT values (202, 503)
467: go
468:
469: insert into EMP_PROJECT values (203, 507)
470: go
471:
472: insert into EMP_PROJECT values (204, 510)
473: go
474:
475: insert into EMP_PROJECT values (205, 512)
476: go
477:
478: insert into EMP_PROJECT values (206, 501)
479: go
480:
481: insert into EMP_PROJECT values (207, 503)
482: go
483:
484: insert into EMP_PROJECT values (208, 507)
485: go
486:
487: insert into EMP_PROJECT values (209, 510)
488: go
489:
490: insert into EMP_PROJECT values (210, 512)
491: go
492:
493: insert into EMP_PROJECT values (211, 501)
494: go
495:
496: insert into EMP_PROJECT values (212, 503)
497: go
498:
499: insert into EMP_PROJECT values (213, 507)
500: go
501:
502: insert into EMP_PROJECT values (214, 510)
503: go
504:
505: insert into EMP_PROJECT values (215, 512)
506: go
507:
508: insert into EMP_PROJECT values (216, 501)
509: go
510:
511: insert into EMP_PROJECT values (217, 503)
512: go
513:
514: insert into EMP_PROJECT values (218, 507)
515: go
516:
517: insert into EMP_PROJECT values (219, 510)
518: go
519:
520: insert into EMP_PROJECT values (220, 512)
521: go
522:
523: insert into EMP_PROJECT values (221, 501)
524: go
525:
526: insert into EMP_PROJECT values (222, 503)
527: go
528:
529: insert into EMP_PROJECT values (223, 507)
530: go
531:
532: insert into EMP_PROJECT values (224, 510)
533: go
534:
535: insert into EMP_PROJECT values (225, 512)
536: go
537:
538:
539: insert into PROJECT values( 501, 'BankLink Financials', null)
540: go
541:
542: insert into PROJECT values( 503, 'Crossover Environment', null)
543: go
544:
545: insert into PROJECT values( 507, 'Net DesignWorks', null)
546: go
547:
548: insert into PROJECT values( 510, 'InfoVault', null)
549: go
550:
551: insert into PROJECT values( 512, 'Customer Satisfaction', null)
552: go
553:
554:
555: insert into DEPARTMENT values (100, 'General and Administration', 1104)
556: go
557:
558: insert into DEPARTMENT values (101, 'Office of the President', 1207)
559: go
560:
561: insert into DEPARTMENT values (104, 'Reception', 1104)
562: go
563:
564: insert into DEPARTMENT values (105, 'Adminstration', 1103)
565: go
566:
567: insert into DEPARTMENT values (200, 'Production and Design', 1103)
568: go
569:
570: insert into DEPARTMENT values (201, 'Art Design', 1104)
571: go
572:
573: insert into DEPARTMENT values (202, 'Hardware Engineering', 1106)
574: go
575:
576: insert into DEPARTMENT values (203, 'System Software', 1106)
577: go
578:
579: insert into DEPARTMENT values (204, 'User Software', 1101)
580: go
581:
582: insert into DEPARTMENT values (250, 'Production', 1106)
583: go
584:
585: insert into DEPARTMENT values (252, 'Logistics', 1101)
586: go
587:
588: insert into DEPARTMENT values (300, 'Sales and Marketing', 1207)
589: go
590:
591: insert into DEPARTMENT values (320, 'Domestic Marketing', 1207)
592: go
593:
594: insert into DEPARTMENT values (330, 'International Marketing', 1207)
595: go
596:
597: insert into DEPARTMENT values (350, 'Sales', 1207)
598: go
599:
600: insert into DEPARTMENT values (400, 'Customer Service', 1106)
601: go
602:
603: insert into DEPARTMENT values (405, 'Service Logistics', 1106)
604: go
605:
606: insert into DEPARTMENT values (410, 'Customer Front-Line', 1106)
607: go
608:
609: insert into DEPARTMENT values (420, 'Customer Back-Line', 1106)
610: go
611:
612: insert into DEPARTMENT values (500, 'Personnel', 1101)
613: go
614:
615: insert into DEPARTMENT values (900, 'Public Relations', 1104)
616: go
617:
618:
619: insert into JOB_TITLE values (1, 'President', 'Salaried')
620: go
621:
622: insert into JOB_TITLE values (2, 'Vice President', 'Salaried')
623: go
624:
625: insert into JOB_TITLE values (3, 'Director', 'Salaried')
626: go
627:
628: insert into JOB_TITLE values (4, 'MANAGER', 'Salaried')
629: go
630:
631: insert into JOB_TITLE values (5, 'Engineer', 'Hourly')
632: go
633:
634: insert into JOB_TITLE values (6, 'Designer', 'Hourly')
635: go
636:
637: insert into JOB_TITLE values (7, 'Sales Representative', 'Salaried')
638: go
639:
640: insert into JOB_TITLE values (8, 'Administrator', 'Hourly')
641: go
642:
643: insert into JOB_TITLE values (9, 'Customer Representative', 'Hourly')
644: go
645:
646: insert into JOB_TITLE values (10, 'Product MANAGER', 'Salaried')
647: go
648:
649: insert into JOB_TITLE values (11, 'Benefits and Compensation', 'Hourly')
650: go
651:
652: insert into JOB_TITLE values (12, 'Associate', 'Hourly')
653: go
654:
655:
656: insert into EMPLOYEE values ( 101, 101, 'Winston', 'James', '415-323-7265',
657: '6269 Washington Ave.', 'Woodside', 'CA', '94160', 1,
658: 'Jan 14 1989 12:00:00:000AM', 101, 5700.00 )
659:
660: go
661:
662: insert into EMPLOYEE values ( 102, 200, 'Veasey', 'Kai', '415-323-261 ',
663: '3401 Strand St.', 'Woodside', 'CA', '94153', 2,
664: 'Aug 19 1991 12:00:00:000AM', 1, 4600.00 )
665:
666: go
667:
668: insert into EMPLOYEE values ( 103, 400, 'MacAskill', 'Debra', '415-328-4407',
669: '3495 Middlefield Ave.', 'Mountain View', 'CA', '94245', 2,
670: 'Nov 19 1992 12:00:00:000AM', 101, 4300.00 )
671:
672: go
673:
674: insert into EMPLOYEE values ( 104, 104, 'Oswald', 'Lesley', '415-321-564 ',
675: '6751 Chowen St.', 'Sunnyvale', 'CA', '94234', 4,
676: 'Jun 20 1994 12:00:00:000AM', 101, 4200.00 )
677:
678: go
679:
680: insert into EMPLOYEE values ( 105, 320,'Scheer', 'Janine', '415-327-9345',
681: '295 Poplar Road', 'San Jose', 'CA', '94226', 4,
682: 'Jan 5 1990 12:00:00:000AM', 107, 5700.00 )
683:
684: go
685:
686: insert into EMPLOYEE values ( 106, 500, 'Maselli', 'John', '415-328-9769',
687: '3494 Pelican Ave.', 'Palo Alto', 'CA', '94226', 2,
688: 'Apr 16 1992 12:00:00:000AM', 101, 4900.00 )
689:
690: go
691:
692: insert into EMPLOYEE values ( 107, 300, 'Lunau', 'Ken', '415-322-2815',
693: '7163 York Road', 'Woodside', 'CA', '94174', 2,
694: 'Dec 12 1991 12:00:00:000AM', 101, 5600.00 )
695:
696: go
697:
698: insert into EMPLOYEE values ( 108, 203, 'DeKeyser', 'John', '415-326-9241',
699: '5633 High Road', 'Mountain View', 'CA', '94228', 3,
700: 'Nov 18 1989 12:00:00:000AM', 102, 5200.00 )
701:
702: go
703:
704: insert into EMPLOYEE values ( 109, 900, 'Windgate', 'Mark', '415-321-3718',
705: '4615 Oak Ave.', 'Oakland', 'CA', '94194', 2,
706: 'Feb 20 1990 12:00:00:000AM', 101, 4000.00 )
707:
708: go
709:
710: insert into EMPLOYEE values ( 110, 400,'Walsh', 'Phyllis', '415-327-2599',
711: '3746 Oak Road', 'Palo Alto', 'CA', '94165', 5,
712: 'Aug 14 1991 12:00:00:000AM', 103, 4900.00 )
713:
714: go
715:
716:
717: insert into EMPLOYEE values ( 111, 203, 'Quan', 'Merianne', '415-323-9827',
718: '7503 Washington Blvd.', 'Redwood City', 'CA', '94223', 5,
719: 'Apr 6 1988 12:00:00:000AM', 102, 4700.00 )
720:
721: go
722:
723: insert into EMPLOYEE values ( 112, 300, 'Kanzaki', 'Mark', '415-324-7911',
724: '2709 Kristen St.', 'Woodside', 'CA', '94219', 3,
725: 'Apr 5 1988 12:00:00:000AM', 107, 4500.00 )
726: go
727:
728: insert into EMPLOYEE values ( 113, 400, 'Helton', 'Dung', '415-320-6474',
729: '4397 Schoman Road', 'Woodside', 'CA', '94173', 5,
730: 'Oct 9 1990 12:00:00:000AM', 103, 5600.00 )
731:
732: go
733:
734: insert into EMPLOYEE values ( 114, 200, 'Thiry', 'Greg', '415-326-4613',
735: '3883 Drew Road', 'Redwood City', 'CA', '94198', 10,
736: 'Mar 13 1988 12:00:00:000AM', 102, 4700.00 )
737:
738: go
739:
740: insert into EMPLOYEE values ( 115, 400,'Gath', 'Jon', '415-322-1987',
741: '502 Johnson St.', 'Santa Clara', 'CA', '94209', 5,
742: 'Nov 4 1989 12:00:00:000AM', 103, 5100.00 )
743:
744: go
745:
746: insert into EMPLOYEE values ( 116, 203, 'Kallimani', 'Yoshinori', '415-322-6335',
747: '7099 Knuth Ave.', 'San Jose', 'CA', '94214', 3,
748: 'Dec 26 1990 12:00:00:000AM', 102, 4200.00 )
749:
750: go
751:
752: insert into EMPLOYEE values ( 117, 405, 'Hojnowski', 'Gregor', '415-323-2994',
753: '5215 Strand Way', 'Pacific Heights', 'CA', '94209', 5,
754: 'Oct 25 1992 12:00:00:000AM', 103, 5200.00 )
755:
756: go
757:
758: insert into EMPLOYEE values ( 118, 300, 'Tautz', 'Denise', '415-322-3937',
759: '7851 Oak Trail', 'Woodside', 'CA', '94181', 10,
760: 'Mar 3 1992 12:00:00:000AM', 107, 5100.00 )
761:
762: go
763:
764: insert into EMPLOYEE values ( 119, 500, 'Upson', 'Alex', '415-323-11 ',
765: '1440 Addams Circle', 'Mountain View', 'CA', '94193', 4,
766: 'Sep 9 1989 12:00:00:000AM', 106, 4900.00 )
767:
768: go
769:
770: insert into EMPLOYEE values ( 120, 350,'Riley', 'Michael', '415-323-2795',
771: '7747 Pope Road', 'Redwood City', 'CA', '94195', 7,
772: 'Feb 3 1991 12:00:00:000AM', 107, 4300.00 )
773:
774: go
775:
776:
777: insert into EMPLOYEE values ( 121, 252, 'Kammerer', 'Sanjay', '415-328-3042',
778: '7331 Walnut Ave.', 'Palo Alto', 'CA', '94178', 5,
779: 'Jan 9 1990 12:00:00:000AM', 102, 4700.00 )
780:
781: go
782:
783: insert into EMPLOYEE values ( 122, 405, 'Affinito', 'Jon', '415-326-515 ',
784: '639 Schoman Ave.', 'Woodside', 'CA', '94239', 5,
785: 'May 1 1988 12:00:00:000AM', 103, 5000.00 )
786:
787: go
788:
789: insert into EMPLOYEE values ( 123, 400, 'Liu', 'Tom', '415-321-1766',
790: '3342 Main St.', 'Sunnyvale', 'CA', '94219', 5,
791: 'Jan 6 1989 12:00:00:000AM', 103, 4700.00 )
792:
793: go
794:
795: insert into EMPLOYEE values ( 124, 410, 'Walton', 'Jennifer', '415-324-4697',
796: '2673 France St.', 'Santa Clara', 'CA', '94157', 4,
797: 'Jan 18 1990 12:00:00:000AM', 103, 5700.00 )
798:
799: go
800: insert into EMPLOYEE values ( 125, 101,'Page', 'Paul', '415-320-8100',
801: '2754 Johnson Ave.', 'Redwood City', 'CA', '94170', 4,
802: 'Aug 18 1992 12:00:00:000AM', 101, 4200.00 )
803:
804: go
805:
806: insert into EMPLOYEE values ( 126, 105, 'Seng', 'Paul', '415-320-7249',
807: '4876 High Road', 'Half Moon Bay', 'CA', '94171', 6,
808: 'Jul 2 1988 12:00:00:000AM', 101, 5000.00 )
809:
810: go
811:
812: insert into EMPLOYEE values ( 127, 101, 'Nelson', 'Andrew', '415-323-1072',
813: '562 Knuth Circle', 'Palo Alto', 'CA', '94164', 11,
814: 'Nov 14 1988 12:00:00:000AM', 101, 5300.00 )
815:
816: go
817:
818: insert into EMPLOYEE values ( 128, 252, 'Tucker', 'Karen', '415-323-1180',
819: '1952 Lutece St.', 'Atherton', 'CA', '94195', 5,
820: 'Nov 12 1989 12:00:00:000AM', 102, 5700.00 )
821:
822: go
823:
824: insert into EMPLOYEE values ( 129, 410, 'Tavana', 'Jim', '415-321-4763',
825: '7067 Broad Road', 'Woodside', 'CA', '94236', 4,
826: 'May 5 1992 12:00:00:000AM', 103, 5500.00 )
827:
828: go
829:
830: insert into EMPLOYEE values ( 130, 250,'Paquette', 'Satch', '415-326-4537',
831: '6972 York Road', 'Pacific Heights', 'CA', '94158', 5,
832: 'Apr 27 1992 12:00:00:000AM', 102, 4800.00 )
833:
834: go
835:
836: insert into EMPLOYEE values ( 131, 350, 'Egner', 'Andy', '415-322-8602',
837: '4106 Poplar St.', 'Redwood City', 'CA', '94246', 7,
838: 'Sep 3 1990 12:00:00:000AM', 107, 5700.00 )
839:
840: go
841:
842: insert into EMPLOYEE values ( 132, 104, 'Page', 'Opal', '415-323-4670',
843: '859 Poplar St.', 'Redwood City', 'CA', '94218', 6,
844: 'Mar 27 1989 12:00:00:000AM', 101, 5300.00 )
845:
846: go
847:
848: insert into EMPLOYEE values ( 133, 203, 'Bay', 'Rosalie', '415-320-3763',
849: '6535 Juneberry Ave.', 'Mountain View', 'CA', '94243', 4,
850: 'Feb 5 1992 12:00:00:000AM', 102, 4300.00 )
851:
852: go
853:
854: insert into EMPLOYEE values ( 134, 300, 'Fisk', 'George', '415-326-4655',
855: '4346 Connell Circle', 'Atherton', 'CA', '94211', 3,
856: 'May 1 1991 12:00:00:000AM', 107, 5700.00 )
857:
858: go
859:
860: insert into EMPLOYEE values ( 135, 252,'Hecker', 'Junko', '415-321-7489',
861: '3930 York Ave.', 'Redwood City', 'CA', '94178', 5,
862: 'Jan 24 1988 12:00:00:000AM', 102, 4700.00 )
863:
864: go
865:
866: insert into EMPLOYEE values ( 136, 101, 'Walsh', 'Guiseppe', '415-328-2963',
867: '1209 High Road', 'Atherton', 'CA', '94172', 10,
868: 'Nov 28 1992 12:00:00:000AM', 101, 4200.00 )
869:
870: go
871:
872: insert into EMPLOYEE values ( 137, 105, 'Davidson', 'Cary', '415-322-7699',
873: '4773 York St.', 'Santa Clara', 'CA', '94160', 3,
874: 'May 23 1989 12:00:00:000AM', 101, 5600.00 )
875:
876: go
877:
878: insert into EMPLOYEE values ( 138, 250, 'Burt', 'Elida', '415-324-444 ',
879: '939 Middlefield St.', 'Santa Clara', 'CA', '94232', 5,
880: 'Apr 6 1988 12:00:00:000AM', 102, 4500.00 )
881:
882: go
883:
884: insert into EMPLOYEE values ( 139, 900, 'Kelleher', 'Leonard', '415-328-569 ',
885: '3481 Knox St.', 'Palo Alto', 'CA', '94246', 12,
886: 'Jul 27 1990 12:00:00:000AM', 109, 4600.00 )
887:
888: go
889:
890: insert into EMPLOYEE values ( 140, 203,'Henriquez', 'Dave', '415-320-6936',
891: '3790 Market Road', 'Belmont', 'CA', '94219', 5,
892: 'Oct 10 1992 12:00:00:000AM', 102, 5700.00 )
893:
894: go
895:
896:
897: insert into EMPLOYEE values ( 141, 252, 'Fuster', 'Manny', '415-325-3468',
898: '6688 Poplar Blvd.', 'Millbrae', 'CA', '94187', 4,
899: 'Dec 15 1990 12:00:00:000AM', 102, 5100.00 )
900:
901: go
902:
903: insert into EMPLOYEE values ( 142, 104, 'Cleary', 'Kathi', '415-320-3912',
904: '2746 Schoman St.', 'Redwood City', 'CA', '94150', 11,
905: 'Nov 23 1991 12:00:00:000AM', 101, 5100.00 )
906:
907: go
908:
909: insert into EMPLOYEE values ( 143, 350, 'Moore', 'Debra', '415-326-5087',
910: '4126 Lutece Ave.', 'San Jose', 'CA', '94237', 7,
911: 'Apr 4 1991 12:00:00:000AM', 107, 5000.00 )
912:
913: go
914:
915: insert into EMPLOYEE values ( 144, 100, 'Hopkins', 'Chris', '415-321-8620',
916: '1482 Elm Ave.', 'Oakland', 'CA', '94198', 7,
917: 'Aug 13 1991 12:00:00:000AM', 101, 5300.00 )
918:
919: go
920:
921: insert into EMPLOYEE values ( 145, 204,'Self', 'Jack', '415-325-767 ',
922: '7044 Walnut Road', 'Half Moon Bay', 'CA', '94164', 4,
923: 'Nov 5 1990 12:00:00:000AM', 102, 5500.00 )
924:
925: go
926:
927: insert into EMPLOYEE values ( 146, 500, 'Cerbone', 'Mark', '415-322-2943',
928: '7137 Juneberry Road', 'San Francisco', 'CA', '94172', 3,
929: 'May 13 1991 12:00:00:000AM', 106, 4300.00 )
930:
931: go
932:
933: insert into EMPLOYEE values ( 147, 202, 'Ralston', 'Anne', '415-323-4177',
934: '3599 Beech Ave.', 'Palo Alto', 'CA', '94169', 5,
935: 'Jul 20 1991 12:00:00:000AM', 102, 5000.00 )
936:
937: go
938:
939: insert into EMPLOYEE values ( 148, 250, 'Henry', 'John', '415-322-5562',
940: '7645 Lancaster Ave.', 'Belmont', 'CA', '94231', 5,
941: 'Jan 14 1991 12:00:00:000AM', 102, 4500.00 )
942:
943: go
944:
945: insert into EMPLOYEE values ( 149, 200, 'Kinney', 'Alex', '415-327-8472',
946: '4044 Hanson St.', 'Mountain View', 'CA', '94239', 6,
947: 'Sep 24 1990 12:00:00:000AM', 102, 5300.00 )
948:
949: go
950:
951: insert into EMPLOYEE values ( 150, 420,'Moore', 'James', '415-325-4316',
952: '6425 Broad Ave.', 'Redwood City', 'CA', '94244', 5,
953: 'Aug 23 1989 12:00:00:000AM', 103, 5600.00 )
954:
955: go
956:
957:
958: insert into EMPLOYEE values ( 151, 105, 'Nguyen', 'Jorg', '415-322-2523',
959: '5531 Knuth St.', 'Pacific Heights', 'CA', '94192', 11,
960: 'Feb 27 1990 12:00:00:000AM', 101, 5600.00 )
961:
962: go
963:
964: insert into EMPLOYEE values ( 152, 330, 'Veasey', 'David', '415-320-1483',
965: '3999 Juneberry Road', 'Belmont', 'CA', '94177', 10,
966: 'Dec 8 1992 12:00:00:000AM', 107, 4400.00 )
967:
968: go
969:
970: insert into EMPLOYEE values ( 153, 350, 'Morse', 'Guy', '415-328-6708',
971: '1276 Middlefield Ave.', 'Atherton', 'CA', '94234', 7,
972: 'Apr 4 1991 12:00:00:000AM', 107, 4000.00 )
973:
974: go
975:
976: insert into EMPLOYEE values ( 154, 350, 'Fordam', 'Donna', '415-320-2744',
977: '7712 Chowen St.', 'Oakland', 'CA', '94215', 7,
978: 'Mar 21 1990 12:00:00:000AM', 107, 4800.00 )
979:
980: go
981:
982: insert into EMPLOYEE values ( 155, 320,'Walsh', 'James', '415-323-7264',
983: '3532 Anderson St.', 'San Francisco', 'CA', '94179', 10,
984: 'Aug 23 1990 12:00:00:000AM', 107, 4200.00 )
985:
986: go
987:
988: insert into EMPLOYEE values ( 156, 420, 'Fukasawa', 'Ben', '415-327-4471',
989: '5337 Kristen Blvd.', 'Palo Alto', 'CA', '94207', 5,
990: 'Sep 23 1989 12:00:00:000AM', 103, 4300.00 )
991:
992: go
993:
994: insert into EMPLOYEE values ( 157, 200, 'Yu', 'Martin', '415-321-9787',
995: '7580 High Ave.', 'Palo Alto', 'CA', '94186', 3,
996: 'Dec 26 1991 12:00:00:000AM', 102, 4800.00 )
997:
998: go
999:
1000: insert into EMPLOYEE values ( 158, 201, 'Hodor', 'Lee', '415-328-151 ',
1001: '2669 Sparrow Ave.', 'Belmont', 'CA', '94194', 6,
1002: 'Feb 22 1988 12:00:00:000AM', 102, 4000.00 )
1003:
1004: go
1005:
1006: insert into EMPLOYEE values ( 159, 203, 'Naroff', 'Unjieng,', '415-322-8693',
1007: '5176 Lincoln St.', 'San Francisco', 'CA', '94168', 5,
1008: 'Jan 5 1990 12:00:00:000AM', 102, 5300.00 )
1009:
1010: go
1011:
1012: insert into EMPLOYEE values ( 160, 330,'Lee', 'Eric', '415-326-9238',
1013: '3234 Connell St.', 'San Francisco', 'CA', '94198', 3,
1014: 'Jan 22 1989 12:00:00:000AM', 107, 4900.00 )
1015:
1016: go
1017:
1018: insert into EMPLOYEE values ( 161, 330, 'Barber', 'Bart', '415-320-7854',
1019: '7277 Shorebird St.', 'Half Moon Bay', 'CA', '94243', 10,
1020: 'Jul 18 1991 12:00:00:000AM', 107, 4200.00 )
1021:
1022: go
1023:
1024: insert into EMPLOYEE values ( 162, 900, 'Patel', 'Jim', '415-322-3915',
1025: '2767 Drew St.', 'Sunnyvale', 'CA', '94214', 12,
1026: 'Jul 12 1992 12:00:00:000AM', 109, 5400.00 )
1027:
1028: go
1029:
1030: insert into EMPLOYEE values ( 163, 900, 'Vergnot', 'Glenn', '415-324-287 ',
1031: '6882 Connell St.', 'San Francisco', 'CA', '94236', 3,
1032: 'Aug 18 1991 12:00:00:000AM', 109, 4300.00 )
1033:
1034: go
1035:
1036: insert into EMPLOYEE values ( 164, 104, 'Hertz', 'Christian', '415-321-3157',
1037: '1884 Pope St.', 'San Jose', 'CA', '94208', 3,
1038: 'Oct 12 1989 12:00:00:000AM', 101, 4000.00 )
1039:
1040: go
1041:
1042: insert into EMPLOYEE values ( 165, 350,'Etcheverry', 'Jon', '415-328-714 ',
1043: '2996 Lutece St.', 'Belmont', 'CA', '94216', 7,
1044: 'Feb 21 1988 12:00:00:000AM', 107, 4200.00 )
1045:
1046: go
1047:
1048: insert into EMPLOYEE values ( 166, 101, 'Burt', 'Alice', '415-320-3192',
1049: '5114 Lancaster St.', 'Pacific Heights', 'CA', '94241', 3,
1050: 'Oct 14 1992 12:00:00:000AM', 101, 5200.00 )
1051:
1052: go
1053:
1054: insert into EMPLOYEE values ( 167, 350, 'Novak', 'Russ', '415-326-281 ',
1055: '6478 Spruce Trail', 'Mountain View', 'CA', '94185', 7,
1056: 'Apr 13 1989 12:00:00:000AM', 107, 4900.00 )
1057:
1058: go
1059:
1060: insert into EMPLOYEE values ( 168, 202, 'Francis', 'Vicki', '415-321-8842',
1061: '2391 Broadway Ave.', 'Redwood City', 'CA', '94220', 5,
1062: 'Jul 24 1991 12:00:00:000AM', 102, 4200.00 )
1063:
1064: go
1065:
1066: insert into EMPLOYEE values ( 169, 201, 'Jochims', 'Hal', '415-324-8628',
1067: '6030 State Ave.', 'Palo Alto', 'CA', '94217', 6,
1068: 'Jul 21 1992 12:00:00:000AM', 102, 4200.00 )
1069:
1070: go
1071:
1072: insert into EMPLOYEE values ( 170, 900,'Tucker', 'Tom', '415-328-2067',
1073: '3258 Wallace St.', 'Mountain View', 'CA', '94246', 12,
1074: 'Mar 18 1988 12:00:00:000AM', 109, 4600.00 )
1075:
1076: go
1077:
1078:
1079: insert into EMPLOYEE values ( 171, 252, 'Herald', 'Ellen', '415-321-1238',
1080: '674 Addams Road', 'San Francisco', 'CA', '94228', 5,
1081: 'Feb 5 1990 12:00:00:000AM', 102, 5300.00 )
1082:
1083: go
1084:
1085: insert into EMPLOYEE values ( 172, 405, 'Anthony', 'Mitch', '415-322-3205',
1086: '5062 Hanson Trail', 'Half Moon Bay', 'CA', '94218', 5,
1087: 'May 26 1991 12:00:00:000AM', 103, 4600.00 )
1088:
1089: go
1090:
1091: insert into EMPLOYEE values ( 173, 350, 'Fuster', 'Lane', '415-320-9534',
1092: '7796 Main Ave.', 'Sunnyvale', 'CA', '94163', 7,
1093: 'Jan 25 1988 12:00:00:000AM', 107, 4300.00 )
1094:
1095: go
1096:
1097: insert into EMPLOYEE values ( 174, 350, 'Dunham', 'Jim', '415-320-691 ',
1098: '3866 Lancaster St.', 'Mountain View', 'CA', '94190', 7,
1099: 'Jul 9 1988 12:00:00:000AM', 107, 4700.00 )
1100:
1101: go
1102:
1103: insert into EMPLOYEE values ( 175, 300,'Ferrante', 'Kristen', '415-324-6344',
1104: '6086 Broad Blvd.', 'Sunnyvale', 'CA', '94216', 4,
1105: 'Apr 14 1990 12:00:00:000AM', 107, 5100.00 )
1106:
1107: go
1108:
1109: insert into EMPLOYEE values ( 176, 202, 'Manross', 'Ken', '415-325-8979',
1110: '2452 Lincoln Blvd.', 'Pacific Heights', 'CA', '94228', 5,
1111: 'Feb 18 1988 12:00:00:000AM', 102, 5600.00 )
1112:
1113: go
1114:
1115: insert into EMPLOYEE values ( 177, 105, 'Dahlbeck', 'Olivier', '415-326-2780',
1116: '3510 Wallace Trail', 'Millbrae', 'CA', '94187', 5,
1117: 'Mar 12 1988 12:00:00:000AM', 101, 4600.00 )
1118:
1119: go
1120:
1121: insert into EMPLOYEE values ( 178, 400, 'Meyer', 'Bonnie', '415-324-140 ',
1122: '1885 Kristen St.', 'Belmont', 'CA', '94155', 5,
1123: 'Jan 14 1991 12:00:00:000AM', 103, 4900.00 )
1124:
1125: go
1126:
1127: insert into EMPLOYEE values ( 179, 203, 'Lappin', 'Denise', '415-320-2072',
1128: '6441 Spruce St.', 'Palo Alto', 'CA', '94198', 5,
1129: 'May 20 1992 12:00:00:000AM', 102, 5200.00 )
1130:
1131: go
1132:
1133: insert into EMPLOYEE values ( 180, 100,'Magennis', 'Jerry', '415-320-3085',
1134: '2457 Chowen St.', 'Redwood City', 'CA', '94224', 8,
1135: 'Dec 28 1989 12:00:00:000AM', 101, 4300.00 )
1136:
1137: go
1138:
1139:
1140: insert into EMPLOYEE values ( 181, 202, 'Law', 'Mike', '415-320-4077',
1141: '1683 Roberts Blvd.', 'Oakland', 'CA', '94174', 5,
1142: 'Jul 13 1990 12:00:00:000AM', 102, 4700.00 )
1143:
1144: go
1145:
1146: insert into EMPLOYEE values ( 182, 350, 'Jackson', 'Thomas', '415-320-5390',
1147: '3279 Hanson St.', 'Belmont', 'CA', '94177', 7,
1148: 'Jun 8 1991 12:00:00:000AM', 107, 5300.00 )
1149:
1150: go
1151:
1152: insert into EMPLOYEE values ( 183, 320, 'Rokovich', 'Dung', '415-320-7176',
1153: '4656 Anderson St.', 'Palo Alto', 'CA', '94210', 10,
1154: 'Jun 26 1991 12:00:00:000AM', 107, 5300.00 )
1155:
1156: go
1157:
1158: insert into EMPLOYEE values ( 184, 105, 'White', 'Curits', '415-320-6492',
1159: '175 Kristen St.', 'Belmont', 'CA', '94180', 9,
1160: 'Jan 25 1989 12:00:00:000AM', 101, 5000.00 )
1161:
1162: go
1163:
1164: insert into EMPLOYEE values ( 185, 420,'Yee', 'Peggy', '415-328-1314',
1165: '4885 France Ave.', 'Half Moon Bay', 'CA', '94239', 4,
1166: 'Aug 16 1990 12:00:00:000AM', 103, 4600.00 )
1167:
1168: go
1169:
1170: insert into EMPLOYEE values ( 186, 900, 'Derrickson', 'Joy', '415-327-5048',
1171: '5708 Elm Ave.', 'Redwood City', 'CA', '94231', 12,
1172: 'Aug 15 1988 12:00:00:000AM', 109, 4700.00 )
1173:
1174: go
1175:
1176: insert into EMPLOYEE values ( 187, 330, 'Steenkamer', 'Jerry', '415-324-4072',
1177: '3861 Washington St.', 'San Jose', 'CA', '94238', 4,
1178: 'Oct 6 1991 12:00:00:000AM', 107, 5200.00 )
1179:
1180: go
1181:
1182: insert into EMPLOYEE values ( 188, 252, 'Sridhara', 'Dieter', '415-321-5690',
1183: '3025 Lancaster Blvd.', 'Atherton', 'CA', '94233', 5,
1184: 'Jun 7 1988 12:00:00:000AM', 102, 4900.00 )
1185:
1186: go
1187:
1188: insert into EMPLOYEE values ( 189, 100, 'Mikkelsen', 'Rob', '415-321-6689',
1189: '4027 Shorebird Ave.', 'Woodside', 'CA', '94188', 9,
1190: 'May 12 1991 12:00:00:000AM', 101, 4400.00 )
1191:
1192: go
1193:
1194: insert into EMPLOYEE values ( 190, 500,'Yee', 'Kollivakkam', '415-324-1358',
1195: '3271 Knuth St.', 'Palo Alto', 'CA', '94217', 4,
1196: 'Jan 10 1988 12:00:00:000AM', 106, 4800.00 )
1197:
1198: go
1199:
1200:
1201: insert into EMPLOYEE values ( 191, 204, 'Guerrero', 'Stephen', '415-321-6736',
1202: '6368 Anderson St.', 'Palo Alto', 'CA', '94173', 5,
1203: 'Jun 3 1992 12:00:00:000AM', 102, 4600.00 )
1204:
1205: go
1206:
1207: insert into EMPLOYEE values ( 192, 420, 'Page', 'Michael', '415-321-1199',
1208: '7713 Middlefield Ave.', 'Atherton', 'CA', '94194', 5,
1209: 'Nov 23 1988 12:00:00:000AM', 103, 4500.00 )
1210:
1211: go
1212:
1213: insert into EMPLOYEE values ( 193, 350, 'McClung', 'Chad', '415-327-1329',
1214: '2902 Connell Ave.', 'Sunnyvale', 'CA', '94181', 7,
1215: 'Aug 25 1988 12:00:00:000AM', 107, 4200.00 )
1216:
1217: go
1218:
1219: insert into EMPLOYEE values ( 194, 104, 'Perka', 'Sam', '415-326-1256',
1220: '61 Knox St.', 'Santa Clara', 'CA', '94191', 9,
1221: 'Nov 23 1988 12:00:00:000AM', 101, 4900.00 )
1222:
1223: go
1224:
1225: insert into EMPLOYEE values ( 195, 420, 'Sickinghe', 'Sherman', '415-325-2233',
1226: '4865 France St.', 'Atherton', 'CA', '94207', 5,
1227: 'Jul 19 1989 12:00:00:000AM', 103, 4500.00 )
1228:
1229: go
1230:
1231: insert into EMPLOYEE values ( 196, 250, 'Welch', 'Robin', '415-328-1833',
1232: '7631 Knox Road', 'Mountain View', 'CA', '94153', 5,
1233: 'Oct 21 1991 12:00:00:000AM', 102, 4100.00 )
1234:
1235: go
1236:
1237: insert into EMPLOYEE values ( 197, 105, 'Nardin', 'Larry', '415-321-2064',
1238: '6179 Main St.', 'Tiberon', 'CA', '94157', 8,
1239: 'Dec 13 1992 12:00:00:000AM', 101, 4600.00 )
1240:
1241: go
1242:
1243: insert into EMPLOYEE values ( 198, 100, 'Zamarripa', 'Drew', '415-320-2956',
1244: '6542 State St.', 'Pacific Heights', 'CA', '94163', 10,
1245: 'Jul 18 1991 12:00:00:000AM', 101, 5400.00 )
1246:
1247: go
1248:
1249: insert into EMPLOYEE values ( 199, 500, 'Edwards', 'John', '415-328-186 ',
1250: '1318 Chowen St.', 'Mountain View', 'CA', '94198', 4,
1251: 'Jun 12 1989 12:00:00:000AM', 106, 5100.00 )
1252:
1253: go
1254:
1255: insert into EMPLOYEE values ( 200, 202,'Schrey', 'Scott', '415-323-3258',
1256: '4033 Knox Road', 'Woodside', 'CA', '94206', 5,
1257: 'Nov 2 1989 12:00:00:000AM', 102, 4000.00 )
1258:
1259: go
1260:
1261:
1262: insert into EMPLOYEE values ( 201, 320, 'Jackson', 'Mike', '415-323-8048',
1263: '6956 Spruce St.', 'Mountain View', 'CA', '94187', 10,
1264: 'Apr 14 1992 12:00:00:000AM', 107, 4700.00 )
1265:
1266: go
1267:
1268: insert into EMPLOYEE values ( 202, 252, 'Mostofi', 'Richard', '415-324-3019',
1269: '1704 Lancaster Road', 'Palo Alto', 'CA', '94206', 5,
1270: 'Aug 12 1989 12:00:00:000AM', 102, 4500.00 )
1271:
1272: go
1273:
1274: insert into EMPLOYEE values ( 203, 410, 'Bonidy', 'Salvatore', '415-322-582 ',
1275: '3116 Knuth Ave.', 'Half Moon Bay', 'CA', '94245', 5,
1276: 'Apr 14 1992 12:00:00:000AM', 103, 5200.00 )
1277:
1278: go
1279:
1280: insert into EMPLOYEE values ( 204, 101, 'Janssen', 'Gene', '415-327-7614',
1281: '648 Washington Way', 'San Jose', 'CA', '94175', 8,
1282: 'Apr 17 1988 12:00:00:000AM', 1, 4300.00 )
1283:
1284: go
1285:
1286: insert into EMPLOYEE values ( 205, 252,'Scott', 'Ken', '415-325-3118',
1287: '5936 Strand Road', 'Palo Alto', 'CA', '94150', 5,
1288: 'Jul 13 1989 12:00:00:000AM', 102, 5700.00 )
1289:
1290: go
1291:
1292: insert into EMPLOYEE values ( 206, 101, 'Droulers', 'Matt', '415-322-213 ',
1293: '4617 Roberts Blvd.', 'Sunnyvale', 'CA', '94232', 7,
1294: 'Nov 23 1990 12:00:00:000AM', 101, 4400.00 )
1295:
1296: go
1297:
1298: insert into EMPLOYEE values ( 207, 202, 'Pinkerton', 'Matt', '415-324-6350',
1299: '7803 Sparrow Road', 'Woodside', 'CA', '94245', 4,
1300: 'Jul 6 1991 12:00:00:000AM', 102, 5600.00 )
1301:
1302: go
1303:
1304: insert into EMPLOYEE values ( 208, 202, 'Campetelli', 'Margaret', '415-321-2664',
1305: '7435 Strand Blvd.', 'Redwood City', 'CA', '94200', 5,
1306: 'Sep 19 1992 12:00:00:000AM', 102, 5200.00 )
1307:
1308: go
1309:
1310: insert into EMPLOYEE values ( 209, 410, 'Lee', 'Jerry', '415-325-9499',
1311: '1484 Adams St.', 'Tiberon', 'CA', '94191', 5,
1312: 'Jan 11 1991 12:00:00:000AM', 103, 5000.00 )
1313:
1314: go
1315:
1316: insert into EMPLOYEE values ( 210, 250,'Bucher', 'Fred', '415-323-8440',
1317: '7048 Knox Road', 'Palo Alto', 'CA', '94243', 3,
1318: 'May 18 1988 12:00:00:000AM', 102, 4000.00 )
1319:
1320: go
1321:
1322:
1323: insert into EMPLOYEE values ( 211, 400, 'Farah', 'David', '415-322-2744',
1324: '1691 Pelican St.', 'San Francisco', 'CA', '94242', 5,
1325: 'Mar 17 1988 12:00:00:000AM', 103, 4600.00 )
1326:
1327: go
1328:
1329: insert into EMPLOYEE values ( 212, 350, 'Avenell', 'Perry', '415-328-1319',
1330: '5910 Lutece Road', 'Palo Alto', 'CA', '94172', 7,
1331: 'May 9 1992 12:00:00:000AM', 107, 5500.00 )
1332:
1333: go
1334:
1335: insert into EMPLOYEE values ( 213, 200, 'Butler', 'Mike', '415-327-8235',
1336: '5872 Regent Ave.', 'Palo Alto', 'CA', '94226', 11,
1337: 'May 5 1990 12:00:00:000AM', 102, 5400.00 )
1338:
1339: go
1340:
1341: insert into EMPLOYEE values ( 214, 405, 'Graves', 'David', '415-323-6928',
1342: '5706 Shorebird Road', 'Sunnyvale', 'CA', '94173', 5,
1343: 'Nov 14 1992 12:00:00:000AM', 103, 4100.00 )
1344:
1345: go
1346:
1347: insert into EMPLOYEE values ( 215, 350,'Hourvitz', 'Keith', '415-326-7210',
1348: '1092 Pelican St.', 'Sunnyvale', 'CA', '94185', 7,
1349: 'Mar 6 1989 12:00:00:000AM', 107, 5400.00 )
1350:
1351: go
1352:
1353: insert into EMPLOYEE values ( 216, 105, 'Messer', 'Tushar', '415-322-2698',
1354: '7117 Drew Road', 'Tiberon', 'CA', '94201', 3,
1355: 'Feb 21 1990 12:00:00:000AM', 101, 4800.00 )
1356:
1357: go
1358:
1359: insert into EMPLOYEE values ( 217, 101, 'Bumgarner', 'Kristen', '415-321-2840',
1360: '2039 Adams St.', 'Belmont', 'CA', '94174', 9,
1361: 'Apr 17 1988 12:00:00:000AM', 101, 5600.00 )
1362:
1363: go
1364:
1365: insert into EMPLOYEE values ( 218, 201, 'Derrickson', 'Ben', '415-322-5122',
1366: '513 Connell St.', 'Tiberon', 'CA', '94176', 6,
1367: 'Aug 15 1988 12:00:00:000AM', 102, 4900.00 )
1368:
1369: go
1370:
1371: insert into EMPLOYEE values ( 219, 101, 'Rushin', 'Mark', '415-323-5883',
1372: '5391 Addams St.', 'Redwood City', 'CA', '94221', 6,
1373: 'Oct 14 1989 12:00:00:000AM', 101, 4900.00 )
1374:
1375: go
1376:
1377: insert into EMPLOYEE values ( 220, 100,'Graffagnino', 'Susan', '415-323-3617',
1378: '5999 Walnut Circle', 'Tiberon', 'CA', '94239', 7,
1379: 'Jan 6 1992 12:00:00:000AM', 101, 4400.00 )
1380:
1381: go
1382:
1383:
1384: insert into EMPLOYEE values ( 221, 202, 'Gibbons', 'Jim', '415-326-9370',
1385: '2305 Emerson St.', 'Millbrae', 'CA', '94188', 4,
1386: 'Nov 13 1988 12:00:00:000AM', 102, 4700.00 )
1387:
1388: go
1389:
1390: insert into EMPLOYEE values ( 222, 101, 'Wasmeier', 'Ken', '415-326-6257',
1391: '7802 Schoman St.', 'Atherton', 'CA', '94159', 8,
1392: 'Nov 5 1990 12:00:00:000AM', 101, 5300.00 )
1393:
1394: go
1395:
1396: insert into EMPLOYEE values ( 223, 405, 'Joseph', 'Ralph', '415-325-6536',
1397: '3635 France St.', 'San Jose', 'CA', '94199', 5,
1398: 'May 15 1989 12:00:00:000AM', 103, 4100.00 )
1399:
1400: go
1401:
1402: insert into EMPLOYEE values ( 224, 201, 'Fried', 'Joel', '415-320-9111',
1403: '1493 Roberts St.', 'Palo Alto', 'CA', '94196', 6,
1404: 'Apr 2 1989 12:00:00:000AM', 102, 5200.00 )
1405:
1406: go
1407:
1408: insert into EMPLOYEE values ( 225, 410,'Blumenfeld', 'Linda', '415-321-2818',
1409: '4373 Roberts St.', 'Mountain View', 'CA', '94195', 5,
1410: 'Jun 11 1991 12:00:00:000AM', 103, 5700.00 )
1411:
1412: go
1413:
1414: insert into EMP_PHOTO(EMP_ID) values (101)
1415: insert into EMP_PHOTO(EMP_ID) values (102)
1416: insert into EMP_PHOTO(EMP_ID) values (103)
1417: insert into EMP_PHOTO(EMP_ID) values (104)
1418: insert into EMP_PHOTO(EMP_ID) values (105)
1419: insert into EMP_PHOTO(EMP_ID) values (106)
1420: insert into EMP_PHOTO(EMP_ID) values (107)
1421: insert into EMP_PHOTO(EMP_ID) values (108)
1422: insert into EMP_PHOTO(EMP_ID) values (109)
1423: insert into EMP_PHOTO(EMP_ID) values (110)
1424: insert into EMP_PHOTO(EMP_ID) values (111)
1425: insert into EMP_PHOTO(EMP_ID) values (112)
1426: insert into EMP_PHOTO(EMP_ID) values (113)
1427: insert into EMP_PHOTO(EMP_ID) values (114)
1428: insert into EMP_PHOTO(EMP_ID) values (115)
1429: insert into EMP_PHOTO(EMP_ID) values (116)
1430: insert into EMP_PHOTO(EMP_ID) values (117)
1431: insert into EMP_PHOTO(EMP_ID) values (118)
1432: insert into EMP_PHOTO(EMP_ID) values (119)
1433: insert into EMP_PHOTO(EMP_ID) values (120)
1434: insert into EMP_PHOTO(EMP_ID) values (121)
1435: insert into EMP_PHOTO(EMP_ID) values (122)
1436: insert into EMP_PHOTO(EMP_ID) values (123)
1437: insert into EMP_PHOTO(EMP_ID) values (124)
1438: insert into EMP_PHOTO(EMP_ID) values (125)
1439: insert into EMP_PHOTO(EMP_ID) values (126)
1440: insert into EMP_PHOTO(EMP_ID) values (127)
1441: insert into EMP_PHOTO(EMP_ID) values (128)
1442: insert into EMP_PHOTO(EMP_ID) values (129)
1443: insert into EMP_PHOTO(EMP_ID) values (130)
1444: insert into EMP_PHOTO(EMP_ID) values (131)
1445: insert into EMP_PHOTO(EMP_ID) values (132)
1446: insert into EMP_PHOTO(EMP_ID) values (133)
1447: insert into EMP_PHOTO(EMP_ID) values (134)
1448: insert into EMP_PHOTO(EMP_ID) values (135)
1449: insert into EMP_PHOTO(EMP_ID) values (136)
1450: insert into EMP_PHOTO(EMP_ID) values (137)
1451: insert into EMP_PHOTO(EMP_ID) values (138)
1452: insert into EMP_PHOTO(EMP_ID) values (139)
1453: insert into EMP_PHOTO(EMP_ID) values (140)
1454: insert into EMP_PHOTO(EMP_ID) values (141)
1455: insert into EMP_PHOTO(EMP_ID) values (142)
1456: insert into EMP_PHOTO(EMP_ID) values (143)
1457: insert into EMP_PHOTO(EMP_ID) values (144)
1458: insert into EMP_PHOTO(EMP_ID) values (145)
1459: insert into EMP_PHOTO(EMP_ID) values (146)
1460: insert into EMP_PHOTO(EMP_ID) values (147)
1461: insert into EMP_PHOTO(EMP_ID) values (148)
1462: insert into EMP_PHOTO(EMP_ID) values (149)
1463: insert into EMP_PHOTO(EMP_ID) values (150)
1464: insert into EMP_PHOTO(EMP_ID) values (151)
1465: insert into EMP_PHOTO(EMP_ID) values (152)
1466: insert into EMP_PHOTO(EMP_ID) values (153)
1467: insert into EMP_PHOTO(EMP_ID) values (154)
1468: insert into EMP_PHOTO(EMP_ID) values (155)
1469: insert into EMP_PHOTO(EMP_ID) values (156)
1470: insert into EMP_PHOTO(EMP_ID) values (157)
1471: insert into EMP_PHOTO(EMP_ID) values (158)
1472: insert into EMP_PHOTO(EMP_ID) values (159)
1473: insert into EMP_PHOTO(EMP_ID) values (160)
1474: insert into EMP_PHOTO(EMP_ID) values (161)
1475: insert into EMP_PHOTO(EMP_ID) values (162)
1476: insert into EMP_PHOTO(EMP_ID) values (163)
1477: insert into EMP_PHOTO(EMP_ID) values (164)
1478: insert into EMP_PHOTO(EMP_ID) values (165)
1479: insert into EMP_PHOTO(EMP_ID) values (166)
1480: insert into EMP_PHOTO(EMP_ID) values (167)
1481: insert into EMP_PHOTO(EMP_ID) values (168)
1482: insert into EMP_PHOTO(EMP_ID) values (169)
1483: insert into EMP_PHOTO(EMP_ID) values (170)
1484: insert into EMP_PHOTO(EMP_ID) values (171)
1485: insert into EMP_PHOTO(EMP_ID) values (172)
1486: insert into EMP_PHOTO(EMP_ID) values (173)
1487: insert into EMP_PHOTO(EMP_ID) values (174)
1488: insert into EMP_PHOTO(EMP_ID) values (175)
1489: insert into EMP_PHOTO(EMP_ID) values (176)
1490: insert into EMP_PHOTO(EMP_ID) values (177)
1491: insert into EMP_PHOTO(EMP_ID) values (178)
1492: insert into EMP_PHOTO(EMP_ID) values (179)
1493: insert into EMP_PHOTO(EMP_ID) values (180)
1494: insert into EMP_PHOTO(EMP_ID) values (181)
1495: insert into EMP_PHOTO(EMP_ID) values (182)
1496: insert into EMP_PHOTO(EMP_ID) values (183)
1497: insert into EMP_PHOTO(EMP_ID) values (184)
1498: insert into EMP_PHOTO(EMP_ID) values (185)
1499: insert into EMP_PHOTO(EMP_ID) values (186)
1500: insert into EMP_PHOTO(EMP_ID) values (187)
1501: insert into EMP_PHOTO(EMP_ID) values (188)
1502: insert into EMP_PHOTO(EMP_ID) values (189)
1503: insert into EMP_PHOTO(EMP_ID) values (190)
1504: insert into EMP_PHOTO(EMP_ID) values (191)
1505: insert into EMP_PHOTO(EMP_ID) values (192)
1506: insert into EMP_PHOTO(EMP_ID) values (193)
1507: insert into EMP_PHOTO(EMP_ID) values (194)
1508: insert into EMP_PHOTO(EMP_ID) values (195)
1509: insert into EMP_PHOTO(EMP_ID) values (196)
1510: insert into EMP_PHOTO(EMP_ID) values (197)
1511: insert into EMP_PHOTO(EMP_ID) values (198)
1512: insert into EMP_PHOTO(EMP_ID) values (199)
1513: insert into EMP_PHOTO(EMP_ID) values (200)
1514: insert into EMP_PHOTO(EMP_ID) values (201)
1515: insert into EMP_PHOTO(EMP_ID) values (202)
1516: insert into EMP_PHOTO(EMP_ID) values (203)
1517: insert into EMP_PHOTO(EMP_ID) values (204)
1518: insert into EMP_PHOTO(EMP_ID) values (205)
1519: insert into EMP_PHOTO(EMP_ID) values (206)
1520: insert into EMP_PHOTO(EMP_ID) values (207)
1521: insert into EMP_PHOTO(EMP_ID) values (208)
1522: insert into EMP_PHOTO(EMP_ID) values (209)
1523: insert into EMP_PHOTO(EMP_ID) values (210)
1524: insert into EMP_PHOTO(EMP_ID) values (211)
1525: insert into EMP_PHOTO(EMP_ID) values (212)
1526: insert into EMP_PHOTO(EMP_ID) values (213)
1527: insert into EMP_PHOTO(EMP_ID) values (214)
1528: insert into EMP_PHOTO(EMP_ID) values (215)
1529: insert into EMP_PHOTO(EMP_ID) values (216)
1530: insert into EMP_PHOTO(EMP_ID) values (217)
1531: insert into EMP_PHOTO(EMP_ID) values (218)
1532: insert into EMP_PHOTO(EMP_ID) values (219)
1533: insert into EMP_PHOTO(EMP_ID) values (220)
1534: insert into EMP_PHOTO(EMP_ID) values (221)
1535: insert into EMP_PHOTO(EMP_ID) values (222)
1536: insert into EMP_PHOTO(EMP_ID) values (223)
1537: insert into EMP_PHOTO(EMP_ID) values (224)
1538: insert into EMP_PHOTO(EMP_ID) values (225)
1539: go
1540:
1541:
1542:
1543:
1544: insert into EMP_EQUIPMENT values (1100, 'NeXTstation 8/105', '984-9749', 119)
1545: go
1546:
1547: insert into EMP_EQUIPMENT values (1101, 'NeXTstation 8/105', '929-22249', 149)
1548: go
1549:
1550: insert into EMP_EQUIPMENT values (1102, 'NeXTstation Color 8/105', '397-40272', 166)
1551: go
1552:
1553: insert into EMP_EQUIPMENT values (1103, 'NeXTstation Color 16/200', '233-86445', 127)
1554: go
1555:
1556: insert into EMP_EQUIPMENT values (1104, 'NeXTstation 16/400', '207-53910', 131)
1557: go
1558:
1559: insert into EMP_EQUIPMENT values (1105, 'NeXTstation Color Turbo 16/200', '508-67548', 147)
1560: go
1561:
1562: insert into EMP_EQUIPMENT values (1106, 'NeXTstation 16/200', '436-80755', 161)
1563: go
1564:
1565: insert into EMP_EQUIPMENT values (1107, 'NeXTstation Color Turbo 16/200', '543-37393', 156)
1566: go
1567:
1568: insert into EMP_EQUIPMENT values (1108, 'NeXTstation 16/200', '547-30645', 218)
1569: go
1570:
1571: insert into EMP_EQUIPMENT values (1109, 'NeXTstation 8/105', '476-93085', 178)
1572: go
1573:
1574: insert into EMP_EQUIPMENT values (1110, 'NeXTDimension', '336-24689', 137)
1575: go
1576:
1577: insert into EMP_EQUIPMENT values (1111, 'NeXTstation Turbo 16/400', '549-35596', 193)
1578: go
1579:
1580: insert into EMP_EQUIPMENT values (1112, 'NeXTstation Color 8/105', '26-33143', 144)
1581: go
1582:
1583: insert into EMP_EQUIPMENT values (1113, 'NeXTstation Color Turbo 8/105', '393-60933', 164)
1584: go
1585:
1586: insert into EMP_EQUIPMENT values (1114, 'NeXTstation Color 8/105', '748-91478', 184)
1587: go
1588:
1589: insert into EMP_EQUIPMENT values (1115, 'NeXTDimension', '754-23106', 140)
1590: go
1591:
1592: insert into EMP_EQUIPMENT values (1116, 'NeXTstation Color Turbo 16/400', '372-28680', 152)
1593: go
1594:
1595: insert into EMP_EQUIPMENT values (1117, 'NeXTstation Color 16/400', '13-44241', 211)
1596: go
1597:
1598: insert into EMP_EQUIPMENT values (1118, 'NeXTstation Color Turbo 16/200', '539-51330', 214)
1599: go
1600:
1601: insert into EMP_EQUIPMENT values (1119, 'NeXTstation Color 16/200', '418-68918', 103)
1602: go
1603:
1604: insert into EMP_EQUIPMENT values (1120, 'NeXTstation 16/200', '809-46727', 143)
1605: go
1606:
1607: insert into EMP_EQUIPMENT values (1121, 'NeXTstation 8/105', '279-2385', 118)
1608: go
1609:
1610: insert into EMP_EQUIPMENT values (1122, 'NeXTstation Color Turbo 16/200', '414-69939', 179)
1611: go
1612:
1613: insert into EMP_EQUIPMENT values (1123, 'NeXTstation Color Turbo 16/200', '796-69543', 188)
1614: go
1615:
1616: insert into EMP_EQUIPMENT values (1124, 'NeXTstation Color Turbo 16/200', '537-89239', 154)
1617: go
1618:
1619: insert into EMP_EQUIPMENT values (1125, 'NeXTstation 16/400', '541-23964', 198)
1620: go
1621:
1622: insert into EMP_EQUIPMENT values (1126, 'NeXTstation Turbo 16/400', '178-21075', 113)
1623: go
1624:
1625: insert into EMP_EQUIPMENT values (1127, 'NeXTstation 16/200', '243-74685', 183)
1626: go
1627:
1628: insert into EMP_EQUIPMENT values (1128, 'NeXTstation 16/400', '702-51108', 138)
1629: go
1630:
1631: insert into EMP_EQUIPMENT values (1129, 'NeXTstation 16/200', '193-79563', 171)
1632: go
1633:
1634: insert into EMP_EQUIPMENT values (1130, 'NeXTstation Color 16/200', '595-86545', 160)
1635: go
1636:
1637: insert into EMP_EQUIPMENT values (1131, 'NeXTstation Color 16/200', '226-22739', 210)
1638: go
1639:
1640: insert into EMP_EQUIPMENT values (1132, 'NeXTstation Turbo 16/400', '98-6934', 204)
1641: go
1642:
1643: insert into EMP_EQUIPMENT values (1133, 'NeXTstation 16/400', '513-28929', 134)
1644: go
1645:
1646: insert into EMP_EQUIPMENT values (1134, 'NeXTstation 8/105', '349-4738', 163)
1647: go
1648:
1649: insert into EMP_EQUIPMENT values (1135, 'NeXTstation Color Turbo 16/200', '941-66087', 132)
1650: go
1651:
1652: insert into EMP_EQUIPMENT values (1136, 'NeXTstation Color 16/400', '382-65389', 114)
1653: go
1654:
1655: insert into EMP_EQUIPMENT values (1137, 'NeXTstation 16/400', '664-62232', 117)
1656: go
1657:
1658: insert into EMP_EQUIPMENT values (1138, 'NeXTstation Color 8/105', '5-36913', 136)
1659: go
1660:
1661: insert into EMP_EQUIPMENT values (1139, 'NeXTstation Color 16/400', '370-90496', 153)
1662: go
1663:
1664: insert into EMP_EQUIPMENT values (1140, 'NeXTDimension', '984-7872', 169)
1665: go
1666:
1667: insert into EMP_EQUIPMENT values (1141, 'NeXTstation Color 16/400', '277-34231', 145)
1668: go
1669:
1670: insert into EMP_EQUIPMENT values (1142, 'NeXTstation 16/400', '753-51711', 150)
1671: go
1672:
1673: insert into EMP_EQUIPMENT values (1143, 'NeXTstation Color Turbo 8/105', '123-7629', 155)
1674: go
1675:
1676: insert into EMP_EQUIPMENT values (1144, 'NeXTstation 16/400', '800-3038', 124)
1677: go
1678:
1679: insert into EMP_EQUIPMENT values (1145, 'NeXTstation Color 8/105', '486-77628', 180)
1680: go
1681:
1682: insert into EMP_EQUIPMENT values (1146, 'NeXTstation 8/105', '824-13576', 187)
1683: go
1684:
1685: insert into EMP_EQUIPMENT values (1147, 'NeXTstation Color 8/105', '626-42240', 209)
1686: go
1687:
1688: insert into EMP_EQUIPMENT values (1148, 'NeXTstation Color Turbo 8/105', '781-27064', 129)
1689: go
1690:
1691: insert into EMP_EQUIPMENT values (1149, 'NeXTstation Color Turbo 16/200', '914-13130', 162)
1692: go
1693:
1694: insert into EMP_EQUIPMENT values (1150, 'NeXTstation Turbo 16/400', '95-49295', 174)
1695: go
1696:
1697: insert into EMP_EQUIPMENT values (1151, 'NeXTstation Color 8/105', '647-96907', 221)
1698: go
1699:
1700: insert into EMP_EQUIPMENT values (1152, 'NeXTDimension', '117-87463', 224)
1701: go
1702:
1703: insert into EMP_EQUIPMENT values (1153, 'NeXTstation Color Turbo 16/200', '670-29606', 106)
1704: go
1705:
1706: insert into EMP_EQUIPMENT values (1154, 'NeXTstation 16/400', '332-52077', 148)
1707: go
1708:
1709: insert into EMP_EQUIPMENT values (1155, 'NeXTstation Color 16/200', '852-63799', 199)
1710: go
1711:
1712: insert into EMP_EQUIPMENT values (1156, 'NeXTstation Color 8/105', '440-37613', 115)
1713: go
1714:
1715: insert into EMP_EQUIPMENT values (1157, 'NeXTstation Color Turbo 16/400', '298-58959', 122)
1716: go
1717:
1718: insert into EMP_EQUIPMENT values (1158, 'NeXTstation Color Turbo 8/105', '164-40348', 165)
1719: go
1720:
1721: insert into EMP_EQUIPMENT values (1159, 'NeXTstation Color Turbo 8/105', '975-497', 151)
1722: go
1723:
1724: insert into EMP_EQUIPMENT values (1160, 'NeXTstation Color 16/200', '741-12300', 186)
1725: go
1726:
1727: insert into EMP_EQUIPMENT values (1161, 'NeXTstation 8/105', '126-40700', 135)
1728: go
1729:
1730: insert into EMP_EQUIPMENT values (1162, 'NeXTstation 16/200', '923-50658', 102)
1731: go
1732:
1733: insert into EMP_EQUIPMENT values (1163, 'NeXTstation Color Turbo 16/200', '705-40124', 105)
1734: go
1735:
1736: insert into EMP_EQUIPMENT values (1164, 'NeXTstation Color 16/400', '985-27011', 128)
1737: go
1738:
1739: insert into EMP_EQUIPMENT values (1165, 'NeXTstation 16/400', '83-84294', 142)
1740: go
1741:
1742: insert into EMP_EQUIPMENT values (1166, 'NeXTstation 16/400', '233-32050', 215)
1743: go
1744:
1745: insert into EMP_EQUIPMENT values (1167, 'NeXTstation 16/400', '226-34036', 107)
1746: go
1747:
1748: insert into EMP_EQUIPMENT values (1168, 'NeXTDimension', '524-60536', 176)
1749: go
1750:
1751: insert into EMP_EQUIPMENT values (1169, 'NeXTstation 8/105', '104-65265', 205)
1752: go
1753:
1754: insert into EMP_EQUIPMENT values (1170, 'NeXTstation Color Turbo 16/400', '794-54450', 222)
1755: go
1756:
1757: insert into EMP_EQUIPMENT values (1171, 'NeXTstation Color 16/200', '550-87024', 190)
1758: go
1759:
1760: insert into EMP_EQUIPMENT values (1172, 'NeXTstation 16/200', '75-57330', 175)
1761: go
1762:
1763: insert into EMP_EQUIPMENT values (1173, 'NeXTstation 16/200', '709-24372', 217)
1764: go
1765:
1766: insert into EMP_EQUIPMENT values (1174, 'NeXTstation Color Turbo 16/200', '388-38271', 173)
1767: go
1768:
1769: insert into EMP_EQUIPMENT values (1175, 'NeXTstation 8/105', '98-76041', 197)
1770: go
1771:
1772: insert into EMP_EQUIPMENT values (1176, 'NeXTstation Color Turbo 8/105', '767-36932', 158)
1773: go
1774:
1775: insert into EMP_EQUIPMENT values (1177, 'NeXTstation 8/105', '595-13623', 139)
1776: go
1777:
1778: insert into EMP_EQUIPMENT values (1178, 'NeXTstation 8/105', '664-82207', 104)
1779: go
1780:
1781: insert into EMP_EQUIPMENT values (1179, 'NeXTDimension', '830-38108', 225)
1782: go
1783:
1784: insert into EMP_EQUIPMENT values (1180, 'NeXTstation Color 16/200', '281-5023', 141)
1785: go
1786:
1787: insert into EMP_EQUIPMENT values (1181, 'NeXTstation Color Turbo 16/200', '388-51896', 208)
1788: go
1789:
1790: insert into EMP_EQUIPMENT values (1182, 'NeXTDimension', '813-75150', 109)
1791: go
1792:
1793: insert into EMP_EQUIPMENT values (1183, 'NeXTstation Color 8/105', '576-43283', 112)
1794: go
1795:
1796: insert into EMP_EQUIPMENT values (1184, 'NeXTstation 16/200', '563-21410', 146)
1797: go
1798:
1799: insert into EMP_EQUIPMENT values (1185, 'NeXTstation Color 8/105', '384-26683', 219)
1800: go
1801:
1802: insert into EMP_EQUIPMENT values (1186, 'NeXTDimension', '449-97816', 157)
1803: go
1804:
1805: insert into EMP_EQUIPMENT values (1187, 'NeXTstation 8/105', '853-64862', 206)
1806: go
1807:
1808: insert into EMP_EQUIPMENT values (1188, 'NeXTstation 8/105', '621-8809', 207)
1809: go
1810:
1811: insert into EMP_EQUIPMENT values (1189, 'NeXTstation 16/200', '162-25658', 111)
1812: go
1813:
1814: insert into EMP_EQUIPMENT values (1190, 'NeXTstation Color 8/105', '621-29151', 120)
1815: go
1816:
1817: insert into EMP_EQUIPMENT values (1191, 'NeXTstation Color Turbo 16/400', '63-38117', 192)
1818: go
1819:
1820: insert into EMP_EQUIPMENT values (1192, 'NeXTstation Color Turbo 16/200', '704-39748', 181)
1821: go
1822:
1823: insert into EMP_EQUIPMENT values (1193, 'NeXTstation 8/105', '785-84375', 201)
1824: go
1825:
1826: insert into EMP_EQUIPMENT values (1194, 'NeXTstation Color 16/400', '652-37816', 213)
1827: go
1828:
1829: insert into EMP_EQUIPMENT values (1195, 'NeXTstation Color 16/200', '886-84102', 172)
1830: go
1831:
1832: insert into EMP_EQUIPMENT values (1196, 'NeXTstation Color Turbo 16/200', '831-87177', 108)
1833: go
1834:
1835: insert into EMP_EQUIPMENT values (1197, 'NeXTstation Color Turbo 16/200', '739-26210', 177)
1836: go
1837:
1838: insert into EMP_EQUIPMENT values (1198, 'NeXTstation 16/200', '396-71735', 125)
1839: go
1840:
1841: insert into EMP_EQUIPMENT values (1199, 'NeXTstation 16/400', '34-79809', 126)
1842: go
1843:
1844: insert into EMP_EQUIPMENT values (1200, 'NeXTstation Color 8/105', '334-59161', 185)
1845: go
1846:
1847: insert into EMP_EQUIPMENT values (1201, 'NeXTDimension', '524-41124', 212)
1848: go
1849:
1850: insert into EMP_EQUIPMENT values (1202, 'NeXTstation Color 8/105', '836-89146', 110)
1851: go
1852:
1853: insert into EMP_EQUIPMENT values (1203, 'NeXTstation Color 16/400', '608-57474', 223)
1854: go
1855:
1856: insert into EMP_EQUIPMENT values (1204, 'NeXTstation Color Turbo 16/200', '722-85049', 202)
1857: go
1858:
1859: insert into EMP_EQUIPMENT values (1205, 'NeXTstation Color Turbo 16/400', '532-78167', 189)
1860: go
1861:
1862: insert into EMP_EQUIPMENT values (1206, 'NeXTstation Turbo 16/400', '16-926', 196)
1863: go
1864:
1865: insert into EMP_EQUIPMENT values (1207, 'NeXTstation Turbo 16/400', '518-18514', 133)
1866: go
1867:
1868: insert into EMP_EQUIPMENT values (1208, 'NeXTDimension', '384-72591', 167)
1869: go
1870:
1871: insert into EMP_EQUIPMENT values (1209, 'NeXTDimension', '334-21983', 203)
1872: go
1873:
1874: insert into EMP_EQUIPMENT values (1210, 'NeXTstation Color Turbo 16/200', '391-49812', 194)
1875: go
1876:
1877: insert into EMP_EQUIPMENT values (1211, 'NeXTstation Turbo 16/400', '6-87480', 121)
1878: go
1879:
1880: insert into EMP_EQUIPMENT values (1212, 'NeXTstation Color Turbo 16/200', '197-13972', 130)
1881: go
1882:
1883: insert into EMP_EQUIPMENT values (1213, 'NeXTstation Color 16/400', '33-39584', 200)
1884: go
1885:
1886: insert into EMP_EQUIPMENT values (1214, 'NeXTstation Color 16/200', '992-3848', 195)
1887: go
1888:
1889: insert into EMP_EQUIPMENT values (1215, 'NeXTstation Color Turbo 8/105', '277-10448', 101)
1890: go
1891:
1892: insert into EMP_EQUIPMENT values (1216, 'NeXTstation Color Turbo 16/400', '975-77088', 191)
1893: go
1894:
1895: insert into EMP_EQUIPMENT values (1217, 'NeXTstation Turbo 16/400', '294-32339', 220)
1896: go
1897:
1898: insert into EMP_EQUIPMENT values (1218, 'NeXTDimension', '618-27833', 182)
1899: go
1900:
1901: insert into EMP_EQUIPMENT values (1219, 'NeXTstation 16/400', '103-83650', 123)
1902: go
1903:
1904: insert into EMP_EQUIPMENT values (1220, 'NeXTstation Color Turbo 16/200', '756-14950', 170)
1905: go
1906:
1907: insert into EMP_EQUIPMENT values (1221, 'NeXTstation 16/400', '436-91312', 216)
1908: go
1909:
1910: insert into EMP_EQUIPMENT values (1222, 'NeXTstation Color Turbo 16/200', '489-13117', 159)
1911: go
1912:
1913: insert into EMP_EQUIPMENT values (1223, 'NeXTstation Color Turbo 8/105', '579-12221', 168)
1914: go
1915:
1916: insert into EMP_EQUIPMENT values (1224, 'NeXTstation 16/400', '551-13204', 116)
1917: go
1918:
1919: insert into EMP_QUOTE(EMP_ID) select EMP_ID from EMPLOYEE
1920: go
1921:
1922: commit transaction
1923: go
1924:
1925:
1926: /******************************************************************************
1927: * Create table indexes.
1928: ******************************************************************************/
1929: create unique INDEX EMP_INDEX1 on EMPLOYEE(EMP_ID)
1930: go
1931:
1932: create unique INDEX DEPT_INDEX1 on DEPARTMENT(DEPT_ID)
1933: go
1934:
1935: create unique INDEX FACILITY_INDEX1 on FACILITY(LOCATION_ID)
1936: go
1937:
1938: create unique INDEX EMPPROJ_INDEX1 on EMP_PROJECT(EMP_ID,PROJECT_ID)
1939: go
1940:
1941: create unique INDEX PROJ_INDEX1 on PROJECT(PROJECT_ID)
1942: go
1943:
1944: create unique INDEX EMP_PHOTO_INDEX1 on EMP_PHOTO(EMP_ID)
1945: go
1946:
1947: create unique INDEX EMP_QUOTE_INDEX1 on EMP_QUOTE(EMP_ID)
1948: go
1949:
1950: create unique INDEX JOB_TITLE_INDEX1 on JOB_TITLE(TITLE_ID)
1951: go
1952:
1953: create unique INDEX ASSET_INDEX1 on EMP_EQUIPMENT(ASSET_TAG)
1954: go
1955:
1956:
1957: /******************************************************************************
1958: * Create the UNIQUE_KEY table, which stores the MAX_KEY for each ENTITY_NAME.
1959: ******************************************************************************/
1960: create table UNIQUE_KEY (
1961: ENTITY_NAME varchar(100),
1962: MAX_KEY int
1963: )
1964: go
1965:
1966: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMPLOYEE',max(EMP_ID) from EMPLOYEE
1967: go
1968: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'DEPARTMENT',max(DEPT_ID) from DEPARTMENT
1969: go
1970: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'FACILITY',max(LOCATION_ID) from FACILITY
1971: go
1972: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'PROJECT',max(PROJECT_ID) from PROJECT
1973: go
1974: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'JOB_TITLE',max(TITLE_ID) from JOB_TITLE
1975: go
1976: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMP_EQUIPMENT',max(ASSET_TAG) from EMP_EQUIPMENT
1977: go
1978:
1979: create unique INDEX UNIQUE_KEY_INDEX1 on UNIQUE_KEY(ENTITY_NAME)
1980: go
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.