1/*
2REM
3REM I-all.sql
4REM
5REM Insert into PC database tables.
6REM
7*/
8
9
10/*
11REM
12REM
13REM Product-ins.sql
14REM
15REM
16*/
17
18INSERT INTO Product
19 VALUES('A', '1001', 'pc');
20
21INSERT INTO Product
22 VALUES('A', '1002', 'pc');
23
24INSERT INTO Product
25 VALUES('A', '1003', 'pc');
26
27INSERT INTO Product
28 VALUES('B', '1004', 'pc');
29
30INSERT INTO Product
31 VALUES('B', '1006', 'pc');
32
33INSERT INTO Product
34 VALUES('B', '3002', 'printer');
35
36INSERT INTO Product
37 VALUES('B', '3004', 'printer');
38
39INSERT INTO Product
40 VALUES('C', '1005', 'pc');
41
42INSERT INTO Product
43 VALUES('C', '1007', 'pc');
44
45INSERT INTO Product
46 VALUES('D', '1008', 'pc');
47
48INSERT INTO Product
49 VALUES('D', '1009', 'pc');
50
51INSERT INTO Product
52 VALUES('D', '1010', 'pc');
53
54INSERT INTO Product
55 VALUES('D', '2001', 'laptop');
56
57INSERT INTO Product
58 VALUES('D', '2002', 'laptop');
59
60INSERT INTO Product
61 VALUES('D', '2003', 'laptop');
62
63INSERT INTO Product
64 VALUES('D', '3001', 'printer');
65
66INSERT INTO Product
67 VALUES('D', '3003', 'printer');
68
69INSERT INTO Product
70 VALUES('E', '2004', 'laptop');
71
72INSERT INTO Product
73 VALUES('E', '2008', 'laptop');
74
75INSERT INTO Product
76 VALUES('F', '2005', 'laptop');
77
78INSERT INTO Product
79 VALUES('G', '2006', 'laptop');
80
81INSERT INTO Product
82 VALUES('G', '2007', 'laptop');
83
84INSERT INTO Product
85 VALUES('H', '3005', 'printer');
86
87INSERT INTO Product
88 VALUES('I', '3006', 'printer');
89
90
91/*
92REM
93REM
94REM PC-ins.sql
95REM
96REM
97*/
98
99INSERT INTO PC
100 VALUES('1001', 133, 16, 1.6, '6x', 1595);
101
102INSERT INTO PC
103 VALUES('1002', 120, 16, 1.6, '6x', 1399);
104
105INSERT INTO PC
106 VALUES('1003', 166, 24, 2.5, '6x', 1899);
107
108INSERT INTO PC
109 VALUES('1004', 166, 32, 2.5, '8x', 1999);
110
111INSERT INTO PC
112 VALUES('1005', 166, 16, 2.0, '8x', 1999);
113
114INSERT INTO PC
115 VALUES('1006', 200, 32, 3.1, '8x', 2099);
116
117INSERT INTO PC
118 VALUES('1007', 200, 32, 3.2, '8x', 2349);
119
120INSERT INTO PC
121 VALUES('1008', 180, 32, 2.0, '8x', 3699);
122
123INSERT INTO PC
124 VALUES('1009', 200, 32, 2.5, '8x', 2599);
125
126INSERT INTO PC
127 VALUES('1010', 160, 16, 1.2, '8x', 2599);
128
129
130/*
131REM
132REM
133REM Laptop-ins.sql
134REM
135REM
136*/
137
138INSERT INTO Laptop
139 VALUES('2001', 100, 20, 1.10, 9.5, 1999);
140
141INSERT INTO Laptop
142 VALUES('2002', 117, 12, 0.75, 11.3, 2499);
143
144INSERT INTO Laptop
145 VALUES('2003', 117, 32, 1.00, 10.4, 3599);
146
147INSERT INTO Laptop
148 VALUES('2004', 133, 16, 1.10, 11.2, 3499);
149
150INSERT INTO Laptop
151 VALUES('2005', 133, 16, 1.00, 11.3, 2599);
152
153INSERT INTO Laptop
154 VALUES('2006', 120, 8, 0.81, 12.1, 1999);
155
156INSERT INTO Laptop
157 VALUES('2007', 150, 16, 1.35, 12.1, 4799);
158
159INSERT INTO Laptop
160 VALUES('2008', 120, 16, 1.10, 12.1, 2099);
161
162
163/*
164REM
165REM
166REM Printer-ins.sql
167REM
168REM
169*/
170
171INSERT INTO Printer
172 VALUES('3001', 'true', 'ink-jet', 275);
173
174INSERT INTO Printer
175 VALUES('3002', 'true', 'ink-jet', 269);
176
177INSERT INTO Printer
178 VALUES('3003', 'false', 'laser', 829);
179
180INSERT INTO Printer
181 VALUES('3004', 'false', 'laser', 879);
182
183INSERT INTO Printer
184 VALUES('3005', 'false', 'ink-jet', 180);
185
186INSERT INTO Printer
187 VALUES('3006', 'true', 'dry', 470);