-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdatabase.sql
283 lines (259 loc) · 27.2 KB
/
database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
-- Table for predefined questions
CREATE TABLE Question (
id INT AUTO_INCREMENT PRIMARY KEY,
possible_questions VARCHAR(255) NOT NULL
);
-- Table for responses to the questions
CREATE TABLE Response (
id INT AUTO_INCREMENT PRIMARY KEY,
response VARCHAR(255) NOT NULL
);
CREATE TABLE Location (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
link LONGTEXT NOT NULL
);
INSERT INTO Question VALUES ("where can i find the head of department's(HOD) office of the computer science department?");
INSERT INTO Question VALUES ("where can i find the secretary's office of the computer science department?");
INSERT INTO Question VALUES ("where can i find the workshop at the physics department?");
INSERT INTO Question VALUES ("where can i find P205 at the physics department?");
INSERT INTO Question VALUES ("where can i find P206 at the physics department?");
INSERT INTO Question VALUES ("where can i find P207 at the physics department?";
INSERT INTO Question VALUES ("where can i find the solid state physics laboratory at the physics department?");
INSERT INTO Question VALUES ("where can i find the classical mechanical laboratory at the physics department?");
INSERT INTO Question VALUES ("where can i find the optics laboratory at the physics department?");
INSERT INTO Question VALUES ("where can i find the maths laboratory at the physics department?");
INSERT INTO Question VALUES ("where can i find the advanced physics at the physics department?");
INSERT INTO Question VALUES ("where can i find the second year laboratory B. physics at the physics department?");
INSERT INTO Question VALUES ("where can i find the head of department's(HOD) of the physics department?");
INSERT INTO Question VALUES ("where can i find the secretary's office of the physics department?");
INSERT INTO Question VALUES ("where can i find the solar energy center at the physics department?");
INSERT INTO Question VALUES ("where can i find the seminar room at the physics department?");
INSERT INTO Question VALUES ("where can i find the dean's office at the physics department?");
INSERT INTO Question VALUES ("where can i find the assistant dean's office at the physics department?");
INSERT INTO Question VALUES ("where can i find the energy and environmental reseach center at the physics department?");
INSERT INTO Question VALUES ("where can i find the registry's office at the physics department?");
INSERT INTO Question VALUES ("where can i find the accounts office at the physics department?");
INSERT INTO Question VALUES ("where can i find the secretary's office at the physics department?");
INSERT INTO Question VALUES ("where can i find the senior adim officer's office at the physics department?");
INSERT INTO Question VALUES ("where can i find the natural science lecture theater(NSLT) at the physics department?");
INSERT INTO Question VALUES ("where can i find the computer studies postgraduate laboratory room at the geography and environmental studies department?");
INSERT INTO Question VALUES ("where can i find the computer room at the geography and environmental studies department?");
INSERT INTO Question VALUES ("where can i find the demonstrators office at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the resource room at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the gas chromatography laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the spectroscopic analysis laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the morphological and structural characterization laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the organic photovoltaic and chemicalsesor room at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the nanomaterial science room at the chemisty department?";
INSERT INTO Question VALUES ("where can i find the physical and inorganic chemisty laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the biochemistry laboratory at the chemisty department?";
INSERT INTO Question VALUES ("where can i find the organic and industrial organic technical laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the analytical inorganic laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the electrical property characterization room at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the industrial inorganic technology laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the room 15 at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the room 10 at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the store room at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the instrument room at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the cheif scientists office at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the lecture theater at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the technician's room at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the physical chemisty laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the analytical services laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the chemisty laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the biochemistry/organic laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the analytical/organic/physical laboratory at the chemisty department?");
INSERT INTO Question VALUES ("where can i find the postgraduate room at the biology department?");
INSERT INTO Question VALUES ("where can i find the biology sciences room at the biology department?");
INSERT INTO Question VALUES ("where can i find the laboratory 107 at the biology department?");
INSERT INTO Question VALUES ("where can i find the microbiology room at the biology department?");
INSERT INTO Question VALUES ("where can i find the laboratory 104 at the biology department?");
INSERT INTO Question VALUES ("where can i find the laboratory 110 at the biology department?");
INSERT INTO Question VALUES ("where can i find the laboratory 102/B at the biology department?");
INSERT INTO Question VALUES ("where can i find the botanical museum at the biology department?");
INSERT INTO Question VALUES ("where can i find the herbarium computer room at the biology department?");
INSERT INTO Question VALUES ("where can i find the herbarium room at the biology department?");
INSERT INTO Question VALUES ("where can i find the zoological museum at the biology department?");
INSERT INTO Question VALUES ("where can i find the plant pathology research laboratory at the biology department?");
INSERT INTO Question VALUES ("where can i find the lecture room 307 at the biology department?");
INSERT INTO Question VALUES ("where can i find the laboratory 302 at the biology department?");
INSERT INTO Question VALUES ("where can i find the laboratory 301 at the biology department?");
INSERT INTO Question VALUES ("where can i find the lecture room 310 at the biology department?");
INSERT INTO Question VALUES ("where can i find the cheif scientist's office at the biology department?");
INSERT INTO Question VALUES ("where can i find the laboratory 303 at the biology department?");
INSERT INTO Question VALUES ("where can i find the prep room at the biology department?");
INSERT INTO Question VALUES ("where can i find the head of department office(HOD) at the biology department?");
INSERT INTO Question VALUES ("where can i find the research laboratory at the biology department?");
INSERT INTO Question VALUES ("where can i find the secretary's office at the biology department?");
INSERT INTO Question VALUES ("where can i find the seminar room at the biology department?");
INSERT INTO Question VALUES ("where can i find the computer room at the biology department?");
INSERT INTO Question VALUES ("where can i find the research center at the biology department?");
INSERT INTO Question VALUES ("where can i find the electrical engineering research telecommunication laboratory at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the micro processor room at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the lecture theater at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the electrical mechanics laboratory at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the junior electric laboratory at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the dark room at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the metrology laboratory at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the measurements room at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the advanced mechanic laboratory at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the bord room at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the dean's office at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the secretary to the dean's office at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the confidential room duplicator at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the assitant registrar office at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the assistant dean's office at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the accounts office at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the seminar room 3 (S3) at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the seminar room 4 (S4) at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the seminar room 5(S5) at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the head of department (HOD) electrical and electronic engineering at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the secretary to the HOD of electrical and electronic engineering at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the zagis' room at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the drawing room 3 (D3) at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the drawing room 4 (D4) at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the head of department(HOD) of civil and environmental engineering at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the secretary of civil and environmental engineering's office at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the drawing room 1 (D1) junioor drawiong office at the school of engineering main building?");
INSERT INTO Question VALUES ("where can i find the electrical and electronic engineering workshop at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the lecture room 1 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the lecture room 2 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the janitor's room at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the duct room at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the computer room at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the library at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the L1 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the L2 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the L3 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the L4 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the L5 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the SR1 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the SR2 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the SR3 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the SR4 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the SR5 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the SR6 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the SR7 at the school of engineering annex building?");
INSERT INTO Question VALUES ("where can i find the lecture room G01 at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the instrument store at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the mining technology at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the cartology at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the photogrammetry laboratory at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the G02 at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the D.B 2 at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the F01 at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the laboratory F10 at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the EPM center at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the lounge G20 at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the EPM accounts/IT at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the UNU/INRA computer room at the department of geomatic engineering?");
INSERT INTO Question VALUES ("where can i find the dean's office at the school of mines?");
INSERT INTO Question VALUES ("where can i find the conference room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the general office room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the lecture theater at the school of mines?");
INSERT INTO Question VALUES ("where can i find the seminar room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the museum room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the rock mechanics laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the preparation room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the drilling and blasting laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the microscope room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the research laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the ore crushing room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the geology rock store room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the ore sample room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the minireal dressing laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the seminar room A at the school of mines?");
INSERT INTO Question VALUES ("where can i find the general laboratory room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the mapping room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the petrographic laboratory room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the sedimentology hydrgeology room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the advanced laboratory room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the accounts office at the school of mines?");
INSERT INTO Question VALUES ("where can i find the department of metallurgical engineering at the school of mines?");
INSERT INTO Question VALUES ("where can i find the secretary's office at the school of mines?");
INSERT INTO Question VALUES ("where can i find the special microscope room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the NET scanner room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the geo-chemical laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the pyro metallurgy laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the instrumental analytical laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the hydro metallurgy laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the preparation room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the illumination laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the cheif's office at the school of mines?");
INSERT INTO Question VALUES ("where can i find the ventilation laboratory at the school of mines?");
INSERT INTO Question VALUES ("where can i find the mineral dressing pilot plant-gallery at the school of mines?");
INSERT INTO Question VALUES ("where can i find the srore room at the school of mines?");
INSERT INTO Question VALUES ("where can i find the library at the school of mines?");
INSERT INTO Question VALUES ("where can i find the head of department(HOD) geology department at the school of mines?");
INSERT INTO Question VALUES ("where can i find the secretary geology department's office at the school of mines?");
INSERT INTO Question VALUES ("where can i find the secretary mining engineering's office at the school of mines?");
INSERT INTO Question VALUES ("where can i find the head of department(HOD) of mining enginering at the school of mines?");
INSERT INTO Question VALUES ("where can i find the umzaprograsa office at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the computer room at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the assitant registrar-graduate studies at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the senior administrative officer at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the accounts officer at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the postgraduate material/resource centre at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the regisrtry's office at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the store room at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the stenographyer at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the senior administrative office at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the assistant registrar research at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the director DRGS at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the conference room at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the management secretary/director at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the directorate of research and graduate studies at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the secretary's office at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the assistance director research at the directorate of research and graduate studies?");
INSERT INTO Question VALUES ("where can i find the assistant registrar at the school of law?");
INSERT INTO Question VALUES ("where can i find the DRFS LT1 at the school of law?");
INSERT INTO Question VALUES ("where can i find the DRFS LT2 at the school of law?");
INSERT INTO Question VALUES ("where can i find the DRFS LT3 at the school of law?");
INSERT INTO Question VALUES ("where can i find the computer room at the school of law?");
INSERT INTO Response VALUES ("the head of department's(HOD) office of the computer science department is room 1");
INSERT INTO Response VALUES ("the secretary's office of the computer science department is room 1");
INSERT INTO Response VALUES ("the workshop at the physics department is on the ground floor");
INSERT INTO Response VALUES ("P205 at the physics department is on the ground floor");
INSERT INTO Response VALUES ("P206 at the physics department is on the ground floor");
INSERT INTO Response VALUES ("P207 at the physics department is on the ground floor");
INSERT INTO Response VALUES ("the solid state physics laboratory at the physics department is on the ground floor, room 219");
INSERT INTO Response VALUES ("the classical mechanical laboratory at the physics department is on the ground floor, room p250");
INSERT INTO Response VALUES ("the optics laboratory at the physics department is on the groung floor, room 308");
INSERT INTO Response VALUES ("the maths laboratory at the physics department is on the first floor, room 417");
INSERT INTO Response VALUES ("the advanced physics at the physics department is on the first floor, room 404");
INSERT INTO Response VALUES ("the second year laboratory B. physics at the physics department is on the first floor, room 2611");
INSERT INTO Response VALUES ("the head of department's(HOD) of the physics department is on the second floor, room 523");
INSERT INTO Response VALUES ("the secretary's office of the physics department is on the second floor, room 523");
INSERT INTO Response VALUES ("the solar energy center at the physics department is on the second floor, room 525");
INSERT INTO Response VALUES ("the seminar room at the physics department is on the second floor, room 504 ");
INSERT INTO Responee VALUES ("the dean's office at the physics department is on the third floor, room 611");
INSERT INTO Response VALUES ("the assistant dean's office at the physics department is on the third floor, room 609");
INSERT INTO Response VALUES ("the energy and environmental reseach center at the physics department is on the third floor, room 602");
INSERT INTO Response VALUES ("the registry's office at the physics department is on the third floor, room 608");
INSERT INTO Response VALUES ("the accounts office at the physics department is on the third floor, room 604");
INSERT INTO Response VALUES ("the secretary's office at the physics department is on the third floor room 610");
INSERT INTO Response VALUES ("the senior adim officer's office at the physics department is on the third floor room 605");
INSERT INTO Response VALUES ("the natural science lecture theater(NSLT) at the physics department is on the ground floor");
INSERT INTO Response VALUES ("the computer studies postgraduate laboratory room at the geography and environmental studies department is on the second floor, room 416");
INSERT INTO Response VALUES ("the computer room at the geography and environmental studies department is on the second floor, room 412");
INSERT INTO Response VALUES ("the demonstrators office at the chemisty department is on the ground floor, room 010");
INSERT INTO Response VALUES ("the resource room at the chemisty department is on the ground floor, room 036");
INSERT INTO Response VALUES ("the gas chromatography laboratory at the chemisty department is on the ground floor, room 042");
INSERT INTO Response VALUES ("the spectroscopic analysis laboratory at the chemisty department is on the ground floor, room 041");
INSERT INTO Response VALUES ("the morphological and structural characterization laboratory at the chemisty department is on the ground floor, room 040");
INSERT INTO Response VALUES ("the organic photovoltaic and chemicalsesor room at the chemisty department is on the ground floor, room 039);
INSERT INTO Response VALUES ("the nanomaterial science room at the chemisty department is on the ground floor, room 032");
INSERT INTO Response VALUES ("the physical and inorganic chemisty laboratory at the chemisty department is on the ground floor, room 034");
INSERT INTO Response VALUES ("the biochemistry laboratory at the chemisty department is on the ground floor, room 035");
INSERT INTO Response VALUES ("the organic and industrial organic technical laboratory at the chemisty department is on the ground floor, room 029");
INSERT INTO Response VALUES ("the analytical inorganic laboratory at the chemisty department is on the ground floor, room 030");
INSERT INTO Response VALUES ("the botanical museum at the biology department is on the second level");
INSERT INTO Response VALUES ("the dean's office at the school of engineering main building is on the ground floor, room 005");
INSERT INTO Response VALUES ("the secretary to the dean's office at the school of engineering main building is on the ground floor, room 006");
INSERT INTO Response VALUES ("the photogrammetry laboratory at the department of geomatic engineering is on the ground floor, room G06");
INSERT INTO Response VALUES ("the dean's office at the school of mines is on the ground floor, room 007");
INSERT INTO Response VALUES ("the conference room at the school of mines is on the ground floor room 014");
INSERT INTO Response VALUES ("the regisrtry's office at the directorate of research and graduate studies is in room 6, first floor");
INSERT INTO Response VALUES ("the assistant registrar at the school of law is in room 2, DRGS building");
INSERT INTO Response VALUES "where can i find the DRFS LT1 at the school of law is on the first first floor");