· 6 years ago · Apr 09, 2019, 05:28 PM
1DROP TABLE IF EXISTS Uses_T CASCADE ;
2
3DROP TABLE IF EXISTS WorksIn_T CASCADE;
4
5DROP TABLE IF EXISTS WorkCenter_T CASCADE ;
6
7DROP TABLE IF EXISTS DoesBusinessIn_T CASCADE ;
8
9DROP TABLE IF EXISTS EmployeeSkills_T CASCADE ;
10
11DROP TABLE IF EXISTS Supplies_T CASCADE ;
12
13DROP TABLE IF EXISTS ProducedIn_T CASCADE ;
14
15DROP TABLE IF EXISTS OrderLine_T CASCADE ;
16
17DROP TABLE IF EXISTS Product_T CASCADE ;
18
19DROP TABLE IF EXISTS ProductLine_T CASCADE ;
20
21DROP TABLE IF EXISTS Order_T CASCADE ;
22
23DROP TABLE IF EXISTS Salesperson_T CASCADE ;
24
25DROP TABLE IF EXISTS Vendor_T CASCADE ;
26
27DROP TABLE IF EXISTS Skill_T CASCADE ;
28
29DROP TABLE IF EXISTS RawMaterial_T CASCADE ;
30
31DROP TABLE IF EXISTS Territory_T CASCADE ;
32
33DROP TABLE IF EXISTS Employee_T CASCADE ;
34
35DROP TABLE IF EXISTS Customer_T CASCADE ;
36
37SET FOREIGN_KEY_CHECKS=0;
38
39
40
41CREATE TABLE Customer_T
42
43 (CustomerID NUMERIC(11,0) NOT NULL,
44
45 CustomerName VARCHAR(25) NOT NULL,
46
47 CustomerAddress VARCHAR(30) ,
48
49 CustomerCity VARCHAR(20) ,
50
51 CustomerState CHAR(2) ,
52
53 CustomerPostalCode VARCHAR(10) ,
54
55CONSTRAINT Customer_PK PRIMARY KEY (CustomerID));
56
57
58
59
60
61CREATE TABLE Territory_T
62
63 (TerritoryID NUMERIC(11,0) NOT NULL,
64
65 TerritoryName VARCHAR(50) ,
66
67CONSTRAINT Territory_PK PRIMARY KEY (TerritoryID));
68
69
70
71CREATE TABLE DoesBusinessIn_T
72
73 (CustomerID NUMERIC(11,0) NOT NULL,
74
75 TerritoryID NUMERIC(11,0) NOT NULL,
76
77CONSTRAINT DoesBusinessIn_PK PRIMARY KEY (CustomerID, TerritoryID),
78
79CONSTRAINT DoesBusinessIn_FK1 FOREIGN KEY (CustomerID) REFERENCES Customer_T(CustomerID),
80
81CONSTRAINT DoesBusinessIn_FK2 FOREIGN KEY (TerritoryID) REFERENCES Territory_T(TerritoryID));
82
83
84
85
86
87CREATE TABLE Employee_T
88
89 (EmployeeID VARCHAR(10) NOT NULL,
90
91 EmployeeName VARCHAR(25) ,
92
93 EmployeeAddress VARCHAR(30) ,
94
95 EmployeeBirthDate DATE ,
96
97 EmployeeCity VARCHAR(20) ,
98
99 EmployeeState CHAR(2) ,
100
101 EmployeeZipCode VARCHAR(10) ,
102
103 EmployeeDateHired DATE ,
104
105 EmployeeSupervisor VARCHAR(10) ,
106
107CONSTRAINT Employee_PK PRIMARY KEY (EmployeeID));
108
109
110
111
112
113CREATE TABLE Skill_T
114
115 (SkillID VARCHAR(12) NOT NULL,
116
117 SkillDescription VARCHAR(30) ,
118
119CONSTRAINT Skill_PK PRIMARY KEY (SkillID));
120
121
122
123
124
125CREATE TABLE EmployeeSkills_T
126
127 (EmployeeID VARCHAR(10) NOT NULL,
128
129 SkillID VARCHAR(12) NOT NULL,
130
131CONSTRAINT EmployeeSkills_PK PRIMARY KEY (EmployeeID, SkillID),
132
133CONSTRAINT EmployeeSkills_FK1 FOREIGN KEY (EmployeeID) REFERENCES Employee_T(EmployeeID),
134
135CONSTRAINT EmployeeSkills_FK2 FOREIGN KEY (SkillID) REFERENCES Skill_T(SkillID));
136
137
138
139CREATE TABLE Order_T
140
141 (OrderID NUMERIC(11,0) NOT NULL,
142
143 CustomerID NUMERIC(11,0) ,
144
145 OrderDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
146
147CONSTRAINT Order_PK PRIMARY KEY (OrderID) ,
148
149CONSTRAINT Order_FK1 FOREIGN KEY (CustomerID) REFERENCES Customer_T(CustomerID));
150
151
152
153
154
155CREATE TABLE WorkCenter_T
156
157 (WorkCenterID VARCHAR(12) NOT NULL,
158
159 WorkCenterLocation VARCHAR(30) ,
160
161CONSTRAINT WorkCenter_PK PRIMARY KEY (WorkCenterID));
162
163
164
165
166
167CREATE TABLE ProductLine_T
168
169 (ProductLineID NUMERIC(11,0) NOT NULL,
170
171 ProductLineName VARCHAR(50) ,
172
173CONSTRAINT ProductLine_PK PRIMARY KEY (ProductLineID));
174
175
176
177
178
179CREATE TABLE Product_T
180
181 (ProductID NUMERIC(11,0) NOT NULL,
182
183 ProductLineID NUMERIC(11,0) ,
184
185 ProductDescription VARCHAR(50) ,
186
187 ProductFinish VARCHAR(20) ,
188
189 ProductStandardPrice DECIMAL(6,2) ,
190
191CONSTRAINT Product_PK PRIMARY KEY (ProductID) ,
192
193CONSTRAINT Product_FK1 FOREIGN KEY (ProductLineID) REFERENCES ProductLine_T(ProductLineID));
194
195
196
197
198
199CREATE TABLE ProducedIn_T
200
201 (ProductID NUMERIC(11,0) NOT NULL,
202
203 WorkCenterID VARCHAR(12) NOT NULL,
204
205CONSTRAINT ProducedIn_PK PRIMARY KEY (ProductID, WorkCenterID),
206
207CONSTRAINT ProducedIn_FK1 FOREIGN KEY (ProductID) REFERENCES Product_T(ProductID),
208
209CONSTRAINT ProducedIn_FK2 FOREIGN KEY (WorkCenterID) REFERENCES WorkCenter_T(WorkCenterID));
210
211
212
213
214
215CREATE TABLE OrderLine_T
216
217 (OrderID NUMERIC(11,0) NOT NULL,
218
219 ProductID NUMERIC(11,0) NOT NULL,
220
221 OrderedQuantity NUMERIC(11,0) ,
222
223CONSTRAINT OrderLine_PK PRIMARY KEY (OrderID, ProductID),
224
225CONSTRAINT OrderLine_FK1 FOREIGN KEY (OrderID) REFERENCES Order_T(OrderID),
226
227CONSTRAINT OrderLine_FK2 FOREIGN KEY (ProductID) REFERENCES Product_T(ProductID));
228
229
230
231
232
233CREATE TABLE RawMaterial_T
234
235 (MaterialID VARCHAR(12) NOT NULL,
236
237 MaterialName VARCHAR(30) ,
238
239 MaterialStandardCost DECIMAL(6,2) ,
240
241 UnitOfMeasure VARCHAR(10) ,
242
243CONSTRAINT RawMaterial_PK PRIMARY KEY (MaterialID));
244
245
246
247
248
249CREATE TABLE Salesperson_T
250
251 (SalespersonID NUMERIC(11,0) NOT NULL,
252
253 SalespersonName VARCHAR(25) ,
254
255 SalespersonPhone VARCHAR(50) ,
256
257 SalespersonFax VARCHAR(50) ,
258
259 TerritoryID NUMERIC(11,0) ,
260
261CONSTRAINT Salesperson_PK PRIMARY KEY (SalesPersonID),
262
263CONSTRAINT Salesperson_FK1 FOREIGN KEY (TerritoryID) REFERENCES Territory_T(TerritoryID));
264
265
266
267
268
269CREATE TABLE Vendor_T
270
271 (VendorID NUMERIC(11,0) NOT NULL,
272
273 VendorName VARCHAR(25) ,
274
275 VendorAddress VARCHAR(30) ,
276
277 VendorCity VARCHAR(20) ,
278
279 VendorState CHAR(2) ,
280
281 VendorZipcode VARCHAR(50) ,
282
283 VendorFax VARCHAR(10) ,
284
285 VendorPhone VARCHAR(10) ,
286
287 VendorContact VARCHAR(50) ,
288
289 VendorTaxID VARCHAR(50) ,
290
291CONSTRAINT Vendor_PK PRIMARY KEY (VendorID));
292
293
294
295
296
297CREATE TABLE Supplies_T
298
299 (VendorID NUMERIC(11,0) NOT NULL,
300
301 MaterialID VARCHAR(12) NOT NULL,
302
303 SuppliesUnitPrice DECIMAL(6,2) ,
304
305CONSTRAINT Supplies_PK PRIMARY KEY (VendorID, MaterialID),
306
307CONSTRAINT Supplies_FK1 FOREIGN KEY (MaterialId) REFERENCES RawMaterial_T(MaterialID),
308
309CONSTRAINT Supplies_FK2 FOREIGN KEY (VendorID) REFERENCES Vendor_T(VendorID));
310
311
312
313
314
315CREATE TABLE Uses_T
316
317 (ProductID NUMERIC(11,0) NOT NULL,
318
319 MaterialID VARCHAR(12) NOT NULL,
320
321 GoesIntoQuantity INTEGER ,
322
323CONSTRAINT Uses_PK PRIMARY KEY (ProductID, MaterialID),
324
325CONSTRAINT Uses_FK1 FOREIGN KEY (ProductID) REFERENCES Product_T(ProductID),
326
327CONSTRAINT Uses_FK2 FOREIGN KEY (MaterialID) REFERENCES RawMaterial_T(MaterialID));
328
329
330
331
332
333CREATE TABLE WorksIn_T
334
335 (EmployeeID VARCHAR(10) NOT NULL,
336
337 WorkCenterID VARCHAR(12) NOT NULL,
338
339CONSTRAINT WorksIn_PK PRIMARY KEY (EmployeeID, WorkCenterID),
340
341CONSTRAINT WorksIn_FK1 FOREIGN KEY (EmployeeID) REFERENCES Employee_T(EmployeeID),
342
343CONSTRAINT WorksIn_FK2 FOREIGN KEY (WorkCenterID) REFERENCES WorkCenter_T(WorkCenterID));
344
345
346
347
348
349delete from Uses_T;
350
351delete from WorksIn_T;
352
353delete from WorkCenter_T;
354
355delete from DoesBusinessIn_T;
356
357delete from EmployeeSkills_T;
358
359delete from Supplies_T;
360
361delete from ProducedIn_T;
362
363delete from OrderLine_T;
364
365delete from Product_T;
366
367delete from ProductLine_T;
368
369delete from Order_T;
370
371delete from Salesperson_T;
372
373delete from Vendor_T;
374
375delete from Skill_T;
376
377delete from RawMaterial_T;
378
379delete from Territory_T;
380
381delete from Employee_T;
382
383delete from Customer_T;
384
385
386
387INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
388
389VALUES (1, 'Contemporary Casuals', '1355 S Hines Blvd', 'Gainesville', 'FL', '32601-2871');
390
391
392
393INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
394
395VALUES (2, 'Value Furniture', '15145 S.W. 17th St.', 'Plano', 'TX', '75094-7743');
396
397
398
399INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
400
401VALUES (3, 'Home Furnishings', '1900 Allard Ave.', 'Albany', 'NY', '12209-1125');
402
403
404
405INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
406
407VALUES (4, 'Eastern Furniture', '1925 Beltline Rd.', 'Carteret', 'NJ', '07008-3188');
408
409
410
411INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
412
413VALUES (5, 'Impressions', '5585 Westcott Ct.', 'Sacramento', 'CA', '94206-4056');
414
415
416
417INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
418
419VALUES (6, 'Furniture Gallery', '325 Flatiron Dr.', 'Boulder', 'CO', '80514-4432');
420
421
422
423INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
424
425VALUES (7, 'Period Furniture', '394 Rainbow Dr.', 'Seattle', 'WA', '97954-5589');
426
427
428
429INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
430
431VALUES (8, 'California Classics', '816 Peach Rd.', 'Santa Clara', 'CA', '96915-7754');
432
433
434
435INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
436
437VALUES (9, 'M and H Casual Furniture', '3709 First Street', 'Clearwater', 'FL', '34620-2314');
438
439
440
441INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
442
443VALUES (10, 'Seminole Interiors', '2400 Rocky Point Dr.', 'Seminole', 'FL', '34646-4423');
444
445
446
447INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
448
449VALUES (11, 'American Euro Lifestyles', '2424 Missouri Ave N.', 'Prospect Park', 'NJ', '07508-5621');
450
451
452
453INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
454
455VALUES (12, 'Battle Creek Furniture', '345 Capitol Ave. SW', 'Battle Creek', 'MI', '49015-3401');
456
457
458
459INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
460
461VALUES (13, 'Heritage Furnishings', '66789 College Ave.', 'Carlisle', 'PA', '17013-8834');
462
463
464
465INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
466
467VALUES (14, 'Kaneohe Homes', '112 Kiowai St.', 'Kaneohe', 'HI', '96744-2537');
468
469
470
471INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
472
473VALUES (15, 'Mountain Scenes', '4132 Main Street', 'Ogden', 'UT', '84403-4432');
474
475
476
477
478
479INSERT INTO Territory_T (TerritoryID, TerritoryName)
480
481VALUES (1, 'SouthEast');
482
483INSERT INTO Territory_T (TerritoryID, TerritoryName)
484
485VALUES (2, 'SouthWest');
486
487INSERT INTO Territory_T (TerritoryID, TerritoryName)
488
489VALUES (3, 'NorthEast');
490
491INSERT INTO Territory_T (TerritoryID, TerritoryName)
492
493VALUES (4, 'NorthWest');
494
495INSERT INTO Territory_T (TerritoryID, TerritoryName)
496
497VALUES (5, 'Central');
498
499
500
501INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
502
503VALUES (1, 1);
504
505INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
506
507VALUES (1, 2);
508
509INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
510
511VALUES (2, 2);
512
513INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
514
515VALUES (3, 3);
516
517INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
518
519VALUES (4, 3);
520
521INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
522
523VALUES (5, 2);
524
525INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
526
527VALUES (6, 5);
528
529
530
531INSERT INTO Employee_T (EmployeeID, EmployeeName, EmployeeAddress, EmployeeCity, EmployeeState, EmployeeZipCode, EmployeeDateHired, EmployeeBirthDate, EmployeeSupervisor)
532
533VALUES ('123-44-345', 'Jim Jason', '2134 Hilltop Rd', '', 'TN', '', '1999-06-12', NULL, '454-56-768');
534
535
536
537INSERT INTO Employee_T (EmployeeID, EmployeeName, EmployeeAddress, EmployeeCity, EmployeeState, EmployeeZipCode, EmployeeDateHired, EmployeeBirthDate, EmployeeSupervisor)
538
539VALUES ('454-56-768', 'Robert Lewis', '17834 Deerfield Ln', 'Nashville', 'TN', '', '1999-01-01', NULL, '');
540
541
542
543INSERT INTO Skill_T (SkillID, SkillDescription)
544
545VALUES ('BS12', '12in Band Saw');
546
547INSERT INTO Skill_T (SkillID, SkillDescription)
548
549VALUES ('QC1', 'Quality Control');
550
551INSERT INTO Skill_T (SkillID, SkillDescription)
552
553VALUES ('RT1', 'Router');
554
555INSERT INTO Skill_T (SkillID, SkillDescription)
556
557VALUES ('SO1', 'Sander-Orbital');
558
559INSERT INTO Skill_T (SkillID, SkillDescription)
560
561VALUES ('SB1', 'Sander-Belt');
562
563INSERT INTO Skill_T (SkillID, SkillDescription)
564
565VALUES ('TS10', '10in Table Saw');
566
567INSERT INTO Skill_T (SkillID, SkillDescription)
568
569VALUES ('TS12', '12in Table Saw');
570
571INSERT INTO Skill_T (SkillID, SkillDescription)
572
573VALUES ('UC1', 'Upholstery Cutter');
574
575INSERT INTO Skill_T (SkillID, SkillDescription)
576
577VALUES ('US1', 'Upholstery Sewer');
578
579INSERT INTO Skill_T (SkillID, SkillDescription)
580
581VALUES ('UT1', 'Upholstery Tacker');
582
583
584
585
586
587INSERT INTO EmployeeSkills_T (EmployeeID, SkillID)
588
589VALUES ('123-44-345', 'BS12');
590
591INSERT INTO EmployeeSkills_T (EmployeeID, SkillID)
592
593VALUES ('123-44-345', 'RT1');
594
595INSERT INTO EmployeeSkills_T (EmployeeID, SkillID)
596
597VALUES ('454-56-768', 'BS12');
598
599
600
601INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
602
603VALUES (1001, '2010-10-21', 1);
604
605INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
606
607VALUES (1002, '2010-10-21', 8);
608
609INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
610
611VALUES (1003, '2010-10-22', 15);
612
613INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
614
615VALUES (1004, '2010-10-22', 5);
616
617INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
618
619VALUES (1005, '2010-10-24', 3);
620
621INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
622
623VALUES (1006, '2010-10-24', 2);
624
625INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
626
627VALUES (1007, '2010-10-27', 11);
628
629INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
630
631VALUES (1008, '2010-10-30', 12);
632
633INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
634
635VALUES (1009, '2010-11-05', 4);
636
637INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
638
639VALUES (1010, '2010-11-05', 1);
640
641
642
643
644
645INSERT INTO ProductLine_T (ProductLineID, ProductLineName)
646
647VALUES (1, 'Cherry Tree');
648
649INSERT INTO ProductLine_T (ProductLineID, ProductLineName)
650
651VALUES (2, 'Scandinavia');
652
653INSERT INTO ProductLine_T (ProductLineID, ProductLineName)
654
655VALUES (3, 'Country Look');
656
657
658
659INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
660
661VALUES (1, 'End Table', 'Cherry', 175, 1);
662
663
664
665INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
666
667VALUES (2, 'Coffee Table', 'Natural Ash', 200, 2);
668
669
670
671INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
672
673VALUES (3, 'Computer Desk', 'Natural Ash', 375, 2);
674
675
676
677INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
678
679VALUES (4, 'Entertainment Center', 'Natural Maple', 650, 3);
680
681
682
683INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
684
685VALUES (5, 'Writers Desk', 'Cherry', 325, 1);
686
687
688
689INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
690
691VALUES (6, '8-Drawer Desk', 'White Ash', 750, 2);
692
693
694
695INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
696
697VALUES (7, 'Dining Table', 'Natural Ash', 800, 2);
698
699
700
701INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
702
703VALUES (8, 'Computer Desk', 'Walnut', 250, 3);
704
705
706
707INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
708
709VALUES (1001, 1, 2);
710
711INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
712
713VALUES (1001, 2, 2);
714
715INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
716
717VALUES (1001, 4, 1);
718
719INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
720
721VALUES (1002, 3, 5);
722
723INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
724
725VALUES (1003, 3, 3);
726
727INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
728
729VALUES (1004, 6, 2);
730
731INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
732
733VALUES (1004, 8, 2);
734
735INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
736
737VALUES (1005, 4, 3);
738
739INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
740
741VALUES (1006, 4, 1);
742
743INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
744
745VALUES (1006, 5, 2);
746
747INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
748
749VALUES (1006, 7, 2);
750
751INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
752
753VALUES (1007, 1, 3);
754
755INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
756
757VALUES (1007, 2, 2);
758
759INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
760
761VALUES (1008, 3, 3);
762
763INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
764
765VALUES (1008, 8, 3);
766
767INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
768
769VALUES (1009, 4, 2);
770
771INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
772
773VALUES (1009, 7, 3);
774
775INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
776
777VALUES (1010, 8, 10);
778
779
780
781INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
782
783VALUES (1, 'Doug Henny', '8134445555', '', 1);
784
785
786
787INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
788
789VALUES (2, 'Robert Lewis', '8139264006', '', 2);
790
791
792
793INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
794
795VALUES (3, 'William Strong', '5053821212', '', 3);
796
797
798
799INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
800
801VALUES (4, 'Julie Dawson', '4355346677', '', 4);
802
803
804
805INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
806
807VALUES (5, 'Jacob Winslow', '2238973498', '', 5);
808
809
810
811INSERT INTO WorkCenter_T (WorkCenterID, WorkCenterLocation)
812
813VALUES ('SM1', 'Main Saw Mill');
814
815INSERT INTO WorkCenter_T (WorkCenterID, WorkCenterLocation)
816
817VALUES ('WR1', 'Warehouse and Receiving');
818
819INSERT INTO WorksIn_T (EmployeeID, WorkCenterID)
820
821VALUES ('123-44-345', 'SM1');
822
823
824
825describe Uses_T;
826
827describe WorksIn_T;
828
829describe WorkCenter_T;
830
831describe DoesBusinessIn_T;
832
833describe EmployeeSkills_T;
834
835describe Supplies_T;
836
837describe ProducedIn_T;
838
839describe OrderLine_T;
840
841describe Product_T;
842
843describe ProductLine_T;
844
845describe Order_T;
846
847describe Salesperson_T;
848
849describe Vendor_T;
850
851describe Skill_T;
852
853describe RawMaterial_T;
854
855describe Territory_T;
856
857describe Employee_T;
858
859describe Customer_T;
860
861
862
863select * from Uses_T;
864
865select * from WorksIn_T;
866
867select * from WorkCenter_T;
868
869select * from DoesBusinessIn_T;
870
871select * from EmployeeSkills_T;
872
873select * from Supplies_T;
874
875select * from ProducedIn_T;
876
877select * from OrderLine_T;
878
879select * from Product_T;
880
881select * from ProductLine_T;
882
883select * from Order_T;
884
885select * from Salesperson_T;
886
887select * from Vendor_T;
888
889select * from Skill_T;
890
891select * from RawMaterial_T;
892
893select * from Territory_T;
894
895select * from Employee_T;
896
897select * from Customer_T;
898
899
900
901COMMIT;