· 6 years ago · Apr 09, 2019, 05:18 PM
1DROP TABLE IF EXISTS Uses_T CASCADE ;
2DROP TABLE IF EXISTS WorksIn_T CASCADE;
3DROP TABLE IF EXISTS WorkCenter_T CASCADE ;
4DROP TABLE IF EXISTS DoesBusinessIn_T CASCADE ;
5DROP TABLE IF EXISTS EmployeeSkills_T CASCADE ;
6DROP TABLE IF EXISTS Supplies_T CASCADE ;
7DROP TABLE IF EXISTS ProducedIn_T CASCADE ;
8DROP TABLE IF EXISTS OrderLine_T CASCADE ;
9DROP TABLE IF EXISTS Product_T CASCADE ;
10DROP TABLE IF EXISTS ProductLine_T CASCADE ;
11DROP TABLE IF EXISTS Order_T CASCADE ;
12DROP TABLE IF EXISTS Salesperson_T CASCADE ;
13DROP TABLE IF EXISTS Vendor_T CASCADE ;
14DROP TABLE IF EXISTS Skill_T CASCADE ;
15DROP TABLE IF EXISTS RawMaterial_T CASCADE ;
16DROP TABLE IF EXISTS Territory_T CASCADE ;
17DROP TABLE IF EXISTS Employee_T CASCADE ;
18DROP TABLE IF EXISTS Customer_T CASCADE ;
19SET FOREIGN_KEY_CHECKS=0;
20
21CREATE TABLE Customer_T
22 (CustomerID NUMERIC(11,0) NOT NULL,
23 CustomerName VARCHAR(25) NOT NULL,
24 CustomerAddress VARCHAR(30) ,
25 CustomerCity VARCHAR(20) ,
26 CustomerState CHAR(2) ,
27 CustomerPostalCode VARCHAR(10) ,
28CONSTRAINT Customer_PK PRIMARY KEY (CustomerID));
29
30
31CREATE TABLE Territory_T
32 (TerritoryID NUMERIC(11,0) NOT NULL,
33 TerritoryName VARCHAR(50) ,
34CONSTRAINT Territory_PK PRIMARY KEY (TerritoryID));
35
36CREATE TABLE DoesBusinessIn_T
37 (CustomerID NUMERIC(11,0) NOT NULL,
38 TerritoryID NUMERIC(11,0) NOT NULL,
39CONSTRAINT DoesBusinessIn_PK PRIMARY KEY (CustomerID, TerritoryID),
40CONSTRAINT DoesBusinessIn_FK1 FOREIGN KEY (CustomerID) REFERENCES Customer_T(CustomerID),
41CONSTRAINT DoesBusinessIn_FK2 FOREIGN KEY (TerritoryID) REFERENCES Territory_T(TerritoryID));
42
43
44CREATE TABLE Employee_T
45 (EmployeeID VARCHAR(10) NOT NULL,
46 EmployeeName VARCHAR(25) ,
47 EmployeeAddress VARCHAR(30) ,
48 EmployeeBirthDate DATE ,
49 EmployeeCity VARCHAR(20) ,
50 EmployeeState CHAR(2) ,
51 EmployeeZipCode VARCHAR(10) ,
52 EmployeeDateHired DATE ,
53 EmployeeSupervisor VARCHAR(10) ,
54CONSTRAINT Employee_PK PRIMARY KEY (EmployeeID));
55
56
57CREATE TABLE Skill_T
58 (SkillID VARCHAR(12) NOT NULL,
59 SkillDescription VARCHAR(30) ,
60CONSTRAINT Skill_PK PRIMARY KEY (SkillID));
61
62
63CREATE TABLE EmployeeSkills_T
64 (EmployeeID VARCHAR(10) NOT NULL,
65 SkillID VARCHAR(12) NOT NULL,
66CONSTRAINT EmployeeSkills_PK PRIMARY KEY (EmployeeID, SkillID),
67CONSTRAINT EmployeeSkills_FK1 FOREIGN KEY (EmployeeID) REFERENCES Employee_T(EmployeeID),
68CONSTRAINT EmployeeSkills_FK2 FOREIGN KEY (SkillID) REFERENCES Skill_T(SkillID));
69
70CREATE TABLE Order_T
71 (OrderID NUMERIC(11,0) NOT NULL,
72 CustomerID NUMERIC(11,0) ,
73 OrderDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
74CONSTRAINT Order_PK PRIMARY KEY (OrderID) ,
75CONSTRAINT Order_FK1 FOREIGN KEY (CustomerID) REFERENCES Customer_T(CustomerID));
76
77
78CREATE TABLE WorkCenter_T
79 (WorkCenterID VARCHAR(12) NOT NULL,
80 WorkCenterLocation VARCHAR(30) ,
81CONSTRAINT WorkCenter_PK PRIMARY KEY (WorkCenterID));
82
83
84CREATE TABLE ProductLine_T
85 (ProductLineID NUMERIC(11,0) NOT NULL,
86 ProductLineName VARCHAR(50) ,
87CONSTRAINT ProductLine_PK PRIMARY KEY (ProductLineID));
88
89
90CREATE TABLE Product_T
91 (ProductID NUMERIC(11,0) NOT NULL,
92 ProductLineID NUMERIC(11,0) ,
93 ProductDescription VARCHAR(50) ,
94 ProductFinish VARCHAR(20) ,
95 ProductStandardPrice DECIMAL(6,2) ,
96CONSTRAINT Product_PK PRIMARY KEY (ProductID) ,
97CONSTRAINT Product_FK1 FOREIGN KEY (ProductLineID) REFERENCES ProductLine_T(ProductLineID));
98
99
100CREATE TABLE ProducedIn_T
101 (ProductID NUMERIC(11,0) NOT NULL,
102 WorkCenterID VARCHAR(12) NOT NULL,
103CONSTRAINT ProducedIn_PK PRIMARY KEY (ProductID, WorkCenterID),
104CONSTRAINT ProducedIn_FK1 FOREIGN KEY (ProductID) REFERENCES Product_T(ProductID),
105CONSTRAINT ProducedIn_FK2 FOREIGN KEY (WorkCenterID) REFERENCES WorkCenter_T(WorkCenterID));
106
107
108CREATE TABLE OrderLine_T
109 (OrderID NUMERIC(11,0) NOT NULL,
110 ProductID NUMERIC(11,0) NOT NULL,
111 OrderedQuantity NUMERIC(11,0) ,
112CONSTRAINT OrderLine_PK PRIMARY KEY (OrderID, ProductID),
113CONSTRAINT OrderLine_FK1 FOREIGN KEY (OrderID) REFERENCES Order_T(OrderID),
114CONSTRAINT OrderLine_FK2 FOREIGN KEY (ProductID) REFERENCES Product_T(ProductID));
115
116
117CREATE TABLE RawMaterial_T
118 (MaterialID VARCHAR(12) NOT NULL,
119 MaterialName VARCHAR(30) ,
120 MaterialStandardCost DECIMAL(6,2) ,
121 UnitOfMeasure VARCHAR(10) ,
122CONSTRAINT RawMaterial_PK PRIMARY KEY (MaterialID));
123
124
125CREATE TABLE Salesperson_T
126 (SalespersonID NUMERIC(11,0) NOT NULL,
127 SalespersonName VARCHAR(25) ,
128 SalespersonPhone VARCHAR(50) ,
129 SalespersonFax VARCHAR(50) ,
130 TerritoryID NUMERIC(11,0) ,
131CONSTRAINT Salesperson_PK PRIMARY KEY (SalesPersonID),
132CONSTRAINT Salesperson_FK1 FOREIGN KEY (TerritoryID) REFERENCES Territory_T(TerritoryID));
133
134
135CREATE TABLE Vendor_T
136 (VendorID NUMERIC(11,0) NOT NULL,
137 VendorName VARCHAR(25) ,
138 VendorAddress VARCHAR(30) ,
139 VendorCity VARCHAR(20) ,
140 VendorState CHAR(2) ,
141 VendorZipcode VARCHAR(50) ,
142 VendorFax VARCHAR(10) ,
143 VendorPhone VARCHAR(10) ,
144 VendorContact VARCHAR(50) ,
145 VendorTaxID VARCHAR(50) ,
146CONSTRAINT Vendor_PK PRIMARY KEY (VendorID));
147
148
149CREATE TABLE Supplies_T
150 (VendorID NUMERIC(11,0) NOT NULL,
151 MaterialID VARCHAR(12) NOT NULL,
152 SuppliesUnitPrice DECIMAL(6,2) ,
153CONSTRAINT Supplies_PK PRIMARY KEY (VendorID, MaterialID),
154CONSTRAINT Supplies_FK1 FOREIGN KEY (MaterialId) REFERENCES RawMaterial_T(MaterialID),
155CONSTRAINT Supplies_FK2 FOREIGN KEY (VendorID) REFERENCES Vendor_T(VendorID));
156
157
158CREATE TABLE Uses_T
159 (ProductID NUMERIC(11,0) NOT NULL,
160 MaterialID VARCHAR(12) NOT NULL,
161 GoesIntoQuantity INTEGER ,
162CONSTRAINT Uses_PK PRIMARY KEY (ProductID, MaterialID),
163CONSTRAINT Uses_FK1 FOREIGN KEY (ProductID) REFERENCES Product_T(ProductID),
164CONSTRAINT Uses_FK2 FOREIGN KEY (MaterialID) REFERENCES RawMaterial_T(MaterialID));
165
166
167CREATE TABLE WorksIn_T
168 (EmployeeID VARCHAR(10) NOT NULL,
169 WorkCenterID VARCHAR(12) NOT NULL,
170CONSTRAINT WorksIn_PK PRIMARY KEY (EmployeeID, WorkCenterID),
171CONSTRAINT WorksIn_FK1 FOREIGN KEY (EmployeeID) REFERENCES Employee_T(EmployeeID),
172CONSTRAINT WorksIn_FK2 FOREIGN KEY (WorkCenterID) REFERENCES WorkCenter_T(WorkCenterID));
173
174
175delete from Uses_T;
176delete from WorksIn_T;
177delete from WorkCenter_T;
178delete from DoesBusinessIn_T;
179delete from EmployeeSkills_T;
180delete from Supplies_T;
181delete from ProducedIn_T;
182delete from OrderLine_T;
183delete from Product_T;
184delete from ProductLine_T;
185delete from Order_T;
186delete from Salesperson_T;
187delete from Vendor_T;
188delete from Skill_T;
189delete from RawMaterial_T;
190delete from Territory_T;
191delete from Employee_T;
192delete from Customer_T;
193
194INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
195VALUES (1, 'Contemporary Casuals', '1355 S Hines Blvd', 'Gainesville', 'FL', '32601-2871');
196
197INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
198VALUES (2, 'Value Furniture', '15145 S.W. 17th St.', 'Plano', 'TX', '75094-7743');
199
200INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
201VALUES (3, 'Home Furnishings', '1900 Allard Ave.', 'Albany', 'NY', '12209-1125');
202
203INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
204VALUES (4, 'Eastern Furniture', '1925 Beltline Rd.', 'Carteret', 'NJ', '07008-3188');
205
206INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
207VALUES (5, 'Impressions', '5585 Westcott Ct.', 'Sacramento', 'CA', '94206-4056');
208
209INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
210VALUES (6, 'Furniture Gallery', '325 Flatiron Dr.', 'Boulder', 'CO', '80514-4432');
211
212INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
213VALUES (7, 'Period Furniture', '394 Rainbow Dr.', 'Seattle', 'WA', '97954-5589');
214
215INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
216VALUES (8, 'California Classics', '816 Peach Rd.', 'Santa Clara', 'CA', '96915-7754');
217
218INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
219VALUES (9, 'M and H Casual Furniture', '3709 First Street', 'Clearwater', 'FL', '34620-2314');
220
221INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
222VALUES (10, 'Seminole Interiors', '2400 Rocky Point Dr.', 'Seminole', 'FL', '34646-4423');
223
224INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
225VALUES (11, 'American Euro Lifestyles', '2424 Missouri Ave N.', 'Prospect Park', 'NJ', '07508-5621');
226
227INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
228VALUES (12, 'Battle Creek Furniture', '345 Capitol Ave. SW', 'Battle Creek', 'MI', '49015-3401');
229
230INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
231VALUES (13, 'Heritage Furnishings', '66789 College Ave.', 'Carlisle', 'PA', '17013-8834');
232
233INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
234VALUES (14, 'Kaneohe Homes', '112 Kiowai St.', 'Kaneohe', 'HI', '96744-2537');
235
236INSERT INTO Customer_T (CustomerID, CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode)
237VALUES (15, 'Mountain Scenes', '4132 Main Street', 'Ogden', 'UT', '84403-4432');
238
239
240INSERT INTO Territory_T (TerritoryID, TerritoryName)
241VALUES (1, 'SouthEast');
242INSERT INTO Territory_T (TerritoryID, TerritoryName)
243VALUES (2, 'SouthWest');
244INSERT INTO Territory_T (TerritoryID, TerritoryName)
245VALUES (3, 'NorthEast');
246INSERT INTO Territory_T (TerritoryID, TerritoryName)
247VALUES (4, 'NorthWest');
248INSERT INTO Territory_T (TerritoryID, TerritoryName)
249VALUES (5, 'Central');
250
251INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
252VALUES (1, 1);
253INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
254VALUES (1, 2);
255INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
256VALUES (2, 2);
257INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
258VALUES (3, 3);
259INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
260VALUES (4, 3);
261INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
262VALUES (5, 2);
263INSERT INTO DoesBusinessIn_T (CustomerID, TerritoryID)
264VALUES (6, 5);
265
266INSERT INTO Employee_T (EmployeeID, EmployeeName, EmployeeAddress, EmployeeCity, EmployeeState, EmployeeZipCode, EmployeeDateHired, EmployeeBirthDate, EmployeeSupervisor)
267VALUES ('123-44-345', 'Jim Jason', '2134 Hilltop Rd', '', 'TN', '', '1999-06-12', '', '454-56-768');
268
269INSERT INTO Employee_T (EmployeeID, EmployeeName, EmployeeAddress, EmployeeCity, EmployeeState, EmployeeZipCode, EmployeeDateHired, EmployeeBirthDate, EmployeeSupervisor)
270VALUES ('454-56-768', 'Robert Lewis', '17834 Deerfield Ln', 'Nashville', 'TN', '', '1999-01-01', '', '');
271
272INSERT INTO Skill_T (SkillID, SkillDescription)
273VALUES ('BS12', '12in Band Saw');
274INSERT INTO Skill_T (SkillID, SkillDescription)
275VALUES ('QC1', 'Quality Control');
276INSERT INTO Skill_T (SkillID, SkillDescription)
277VALUES ('RT1', 'Router');
278INSERT INTO Skill_T (SkillID, SkillDescription)
279VALUES ('SO1', 'Sander-Orbital');
280INSERT INTO Skill_T (SkillID, SkillDescription)
281VALUES ('SB1', 'Sander-Belt');
282INSERT INTO Skill_T (SkillID, SkillDescription)
283VALUES ('TS10', '10in Table Saw');
284INSERT INTO Skill_T (SkillID, SkillDescription)
285VALUES ('TS12', '12in Table Saw');
286INSERT INTO Skill_T (SkillID, SkillDescription)
287VALUES ('UC1', 'Upholstery Cutter');
288INSERT INTO Skill_T (SkillID, SkillDescription)
289VALUES ('US1', 'Upholstery Sewer');
290INSERT INTO Skill_T (SkillID, SkillDescription)
291VALUES ('UT1', 'Upholstery Tacker');
292
293
294INSERT INTO EmployeeSkills_T (EmployeeID, SkillID)
295VALUES ('123-44-345', 'BS12');
296INSERT INTO EmployeeSkills_T (EmployeeID, SkillID)
297VALUES ('123-44-345', 'RT1');
298INSERT INTO EmployeeSkills_T (EmployeeID, SkillID)
299VALUES ('454-56-768', 'BS12');
300
301INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
302VALUES (1001, '2010-10-21', 1);
303INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
304VALUES (1002, '2010-10-21', 8);
305INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
306VALUES (1003, '2010-10-22', 15);
307INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
308VALUES (1004, '2010-10-22', 5);
309INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
310VALUES (1005, '2010-10-24', 3);
311INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
312VALUES (1006, '2010-10-24', 2);
313INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
314VALUES (1007, '2010-10-27', 11);
315INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
316VALUES (1008, '2010-10-30', 12);
317INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
318VALUES (1009, '2010-11-05', 4);
319INSERT INTO Order_T (OrderID, OrderDate, CustomerID)
320VALUES (1010, '2010-11-05', 1);
321
322
323INSERT INTO ProductLine_T (ProductLineID, ProductLineName)
324VALUES (1, 'Cherry Tree');
325INSERT INTO ProductLine_T (ProductLineID, ProductLineName)
326VALUES (2, 'Scandinavia');
327INSERT INTO ProductLine_T (ProductLineID, ProductLineName)
328VALUES (3, 'Country Look');
329
330INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
331VALUES (1, 'End Table', 'Cherry', 175, 1);
332
333INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
334VALUES (2, 'Coffee Table', 'Natural Ash', 200, 2);
335
336INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
337VALUES (3, 'Computer Desk', 'Natural Ash', 375, 2);
338
339INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
340VALUES (4, 'Entertainment Center', 'Natural Maple', 650, 3);
341
342INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
343VALUES (5, 'Writers Desk', 'Cherry', 325, 1);
344
345INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
346VALUES (6, '8-Drawer Desk', 'White Ash', 750, 2);
347
348INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
349VALUES (7, 'Dining Table', 'Natural Ash', 800, 2);
350
351INSERT INTO Product_T (ProductID, ProductDescription, ProductFinish, ProductStandardPrice, ProductLineID)
352VALUES (8, 'Computer Desk', 'Walnut', 250, 3);
353
354INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
355VALUES (1001, 1, 2);
356INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
357VALUES (1001, 2, 2);
358INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
359VALUES (1001, 4, 1);
360INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
361VALUES (1002, 3, 5);
362INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
363VALUES (1003, 3, 3);
364INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
365VALUES (1004, 6, 2);
366INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
367VALUES (1004, 8, 2);
368INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
369VALUES (1005, 4, 3);
370INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
371VALUES (1006, 4, 1);
372INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
373VALUES (1006, 5, 2);
374INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
375VALUES (1006, 7, 2);
376INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
377VALUES (1007, 1, 3);
378INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
379VALUES (1007, 2, 2);
380INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
381VALUES (1008, 3, 3);
382INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
383VALUES (1008, 8, 3);
384INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
385VALUES (1009, 4, 2);
386INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
387VALUES (1009, 7, 3);
388INSERT INTO OrderLine_T (OrderID, ProductID, OrderedQuantity)
389VALUES (1010, 8, 10);
390
391INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
392VALUES (1, 'Doug Henny', '8134445555', '', 1);
393
394INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
395VALUES (2, 'Robert Lewis', '8139264006', '', 2);
396
397INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
398VALUES (3, 'William Strong', '5053821212', '', 3);
399
400INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
401VALUES (4, 'Julie Dawson', '4355346677', '', 4);
402
403INSERT INTO Salesperson_T (SalesPersonID, SalesPersonName, SalesPersonPhone, SalesPersonFax, TerritoryID)
404VALUES (5, 'Jacob Winslow', '2238973498', '', 5);
405
406INSERT INTO WorkCenter_T (WorkCenterID, WorkCenterLocation)
407VALUES ('SM1', 'Main Saw Mill');
408INSERT INTO WorkCenter_T (WorkCenterID, WorkCenterLocation)
409VALUES ('WR1', 'Warehouse and Receiving');
410INSERT INTO WorksIn_T (EmployeeID, WorkCenterID)
411VALUES ('123-44-345', 'SM1');
412
413describe Uses_T;
414describe WorksIn_T;
415describe WorkCenter_T;
416describe DoesBusinessIn_T;
417describe EmployeeSkills_T;
418describe Supplies_T;
419describe ProducedIn_T;
420describe OrderLine_T;
421describe Product_T;
422describe ProductLine_T;
423describe Order_T;
424describe Salesperson_T;
425describe Vendor_T;
426describe Skill_T;
427describe RawMaterial_T;
428describe Territory_T;
429describe Employee_T;
430describe Customer_T;
431
432select * from Uses_T;
433select * from WorksIn_T;
434select * from WorkCenter_T;
435select * from DoesBusinessIn_T;
436select * from EmployeeSkills_T;
437select * from Supplies_T;
438select * from ProducedIn_T;
439select * from OrderLine_T;
440select * from Product_T;
441select * from ProductLine_T;
442select * from Order_T;
443select * from Salesperson_T;
444select * from Vendor_T;
445select * from Skill_T;
446select * from RawMaterial_T;
447select * from Territory_T;
448select * from Employee_T;
449select * from Customer_T;
450
451COMMIT;