-
Notifications
You must be signed in to change notification settings - Fork 0
/
db-first edition.sql
694 lines (608 loc) · 90.8 KB
/
db-first edition.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
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
DROP DATABASE mydb;
CREATE DATABASE IF NOT EXISTS `mydb`;
USE `mydb` ;
CREATE TABLE IF NOT EXISTS `mydb`.`College` (
`collegeID` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(60) NOT NULL,
`addr1` VARCHAR(50) NOT NULL,
`addr2` VARCHAR(50) NOT NULL,
`postalCode`VARCHAR(45) NOT NULL,
`county` VARCHAR(45) NULL,
`contactNum` VARCHAR(45) NULL,
PRIMARY KEY (`collegeID`)
);
CREATE TABLE IF NOT EXISTS `mydb`.`Course` (
`collegeID` INT NOT NULL,
`courseCode` VARCHAR(20) NOT NULL,
`courseName` VARCHAR(999) NOT NULL,
PRIMARY KEY (`courseCode`),
FOREIGN KEY (`collegeID`)
REFERENCES `mydb`.`College` (`collegeID`)
);
CREATE TABLE IF NOT EXISTS `mydb`.`Student` (
`studentNumber` VARCHAR(45) NOT NULL,
`fname` VARCHAR(90) NOT NULL,
`lname` VARCHAR(90) NOT NULL,
`pass` VARCHAR(100) NOT NULL,
`email` VARCHAR(100) NOT NULL,
`addr1` VARCHAR(90) NOT NULL,
`addr2` VARCHAR(90) NULL,
`county` VARCHAR(45) NOT NULL,
`country` VARCHAR(45) NOT NULL,
`nationality` VARCHAR(45) NOT NULL,
`courseCode` VARCHAR(20) NOT NULL,
PRIMARY KEY (`studentNumber`),
FOREIGN KEY (`courseCode`)
REFERENCES `mydb`.`Course` (`courseCode`)
);
CREATE TABLE IF NOT EXISTS `mydb`.`Classes` (
`className` VARCHAR(100) NOT NULL,
`lecturer` VARCHAR(100) NOT NULL,
`assistant` VARCHAR(100) NULL,
`courseCode` VARCHAR(20) NOT NULL,
PRIMARY KEY (`className` , `courseCode`),
FOREIGN KEY (`courseCode`)
REFERENCES `mydb`.`Course` (`courseCode`)
);
CREATE TABLE IF NOT EXISTS `mydb`.`Grade` (
`ClassName` VARCHAR(100) NOT NULL,
`studentNumber` VARCHAR(45) NOT NULL,
`grade` VARCHAR(45) NOT NULL,
PRIMARY KEY (`studentNumber`, `ClassName`),
CONSTRAINT `className`
FOREIGN KEY (`ClassName`)
REFERENCES `mydb`.`Classes` (`className`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `studentNumber`
FOREIGN KEY (`studentNumber`)
REFERENCES `mydb`.`Student` (`studentNumber`)
ON DELETE NO ACTION
ON UPDATE NO ACTION
);
CREATE TABLE IF NOT EXISTS `mydb`.`TimeSlot` (
`slotID` INT NOT NULL AUTO_INCREMENT,
`timeStart` TIME NOT NULL,
`timeEnd` TIME NOT NULL,
PRIMARY KEY (`slotID`)
);
CREATE TABLE IF NOT EXISTS `mydb`.`Timetable` (
`she_Day` VARCHAR(10) NOT NULL,
`she_TimeSlot` INT NOT NULL,
`className` VARCHAR(100) NOT NULL,
`courseCode` VARCHAR(20) NOT NULL,
PRIMARY KEY (`she_TimeSlot` , `className` , `courseCode`),
FOREIGN KEY (`she_TimeSlot`)
REFERENCES `mydb`.`TimeSlot` (`slotID`),
FOREIGN KEY (`className`)
REFERENCES `mydb`.`Classes` (`className`),
FOREIGN KEY (`courseCode`)
REFERENCES `mydb`.`Course` (`courseCode`)
);
CREATE TABLE IF NOT EXISTS `mydb`.`Library` (
`bookID` VARCHAR(45) NOT NULL ,
`collegeID` INT NOT NULL,
`title` VARCHAR(45) NULL,
`author` VARCHAR(45) NULL,
`description` VARCHAR(500) NULL,
`image` VARCHAR(900) NULL,
`category` VARCHAR(45) NULL,
PRIMARY KEY (`bookID` , `collegeID`),
FOREIGN KEY (`collegeID`)
REFERENCES `mydb`.`College` (`collegeID`)
);
CREATE TABLE IF NOT EXISTS `mydb`.`MyBooks` (
`bookID` VARCHAR(45) NOT NULL,
`studentID` VARCHAR(45) NOT NULL,
PRIMARY KEY (`bookID` , `studentID`),
FOREIGN KEY (`studentID`)
REFERENCES `mydb`.`Student` (`studentNumber`),
FOREIGN KEY (`bookID`)
REFERENCES `mydb`.`Library` (`bookID`)
);
CREATE TABLE IF NOT EXISTS `mydb`.`News` (
`newsId` INT NOT NULL,
`title` VARCHAR(999) NULL,
`description` TEXT NULL,
`location` VARCHAR(999) NULL,
`image` VARCHAR(999) NULL,
`date` LONGBLOB NULL,
`collegeID` INT NOT NULL,
PRIMARY KEY (`newsId`),
FOREIGN KEY (`collegeID`)
REFERENCES `mydb`.`College` (`collegeID`)
);
CREATE TABLE IF NOT EXISTS `mydb`.`Support` (
`supportName` VARCHAR(50) NOT NULL,
`desc` VARCHAR(999) NOT NULL,
`contactNum` VARCHAR(50) NOT NULL,
`location` VARCHAR(999) NOT NULL,
`collegeID` INT NOT NULL,
PRIMARY KEY (`supportName` , `collegeID`),
FOREIGN KEY (`collegeID`)
REFERENCES `mydb`.`College` (`collegeID`)
);
INSERT INTO college (`name`,`addr1`,`addr2`,`postalCode`,`county`,`contactNum`) VALUES ('National College of Ireland', 'Mayor Street', 'IFSC', 'D1', 'Dublin', '+353134123213');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (2, 'Universidad Abierta Interamericana', '0590 Springview Circle', 'Unquillo', 'D7', 'Argentina', '54-(781)459-0795');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (3, 'Centro Regional Universitário de Espiríto Santo do Pinhal', '9 Sunbrook Way', 'Macau', 'D3', 'Brazil', '55-(299)483-6927');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (4, 'Southern Yangtze University', '41717 Schlimgen Street', 'Yandian', 'D12', 'China', '86-(360)984-0353');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (5, 'Internationle Akademie für Philosophie', '6 Sachtjen Place', 'Triesenberg', 'D20', 'Liechtenstein', '423-(876)701-3578');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (6, 'Universidad de Occidente', '7376 Autumn Leaf Street', 'La Guadalupe', 'D16', 'Mexico', '52-(880)339-0455');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (7, 'Universitas Nasional Jakarta', '9 Reindahl Crossing', 'Talangbetutu', 'D24', 'Indonesia', '62-(605)822-2494');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (8, 'Karaganda State Buketov University', '876 Fieldstone Trail', 'Shu', 'D3', 'Kazakhstan', '7-(807)685-4208');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (9, 'Centro Universitário Adventista de São Paulo', '6606 Portage Alley', 'Cerquilho', 'D5', 'Brazil', '55-(839)827-1457');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (10, 'Al-Azhar University of Gaza', '5 Dahle Pass', 'Majdal Banī Fāḑil', 'D11', 'Palestinian Territory', '970-(446)695-6923');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (11, 'Universidad Autónoma de Bucaramanga', '4 High Crossing Hill', 'Villanueva', 'D15', 'Colombia', '57-(440)710-1440');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (12, 'Medical Academy of Latvia', '038 Parkside Point', 'Vaiņode', 'D15', 'Latvia', '371-(723)936-3325');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (13, 'Beijing Union University', '132 Susan Point', 'Tatou', 'D1', 'China', '86-(332)898-0167');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (14, 'Universidad de Palermo', '25495 Menomonie Alley', 'General San Martín', 'D14', 'Argentina', '54-(551)444-8852');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (15, 'Universitas Katolik Widya Manadala', '548 Thackeray Road', 'Banjar', 'D12', 'Indonesia', '62-(653)358-4476');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (16, 'Universidad de Hermosillo', '551 Glendale Trail', 'Lindavista', 'D3', 'Mexico', '52-(294)543-9530');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (17, 'University of the Philippines Visayas', '99128 Twin Pines Avenue', 'Payao', 'D10', 'Philippines', '63-(238)467-9562');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (18, 'Kunmimg University of Science and Technology', '36 Burrows Trail', 'Lop', 'D22', 'China', '86-(183)498-9944');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (19, 'Kenya Medical Training College', '16001 Florence Circle', 'Garissa', 'D12', 'Kenya', '254-(952)503-4642');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (20, 'Notre Dame University', '4958 Mallory Place', 'Burgos', 'D9', 'Philippines', '63-(271)614-4091');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (21, 'Palawan State University', '19872 3rd Road', 'Paitan Norte', 'D7', 'Philippines', '63-(737)991-3348');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (22, 'Agricultural University of Szczecin', '53780 Alpine Street', 'Libiąż', 'D11', 'Poland', '48-(821)798-6965');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (23, 'Fomic Polytechnic', '7326 Evergreen Avenue', 'Ndom', 'D1', 'Cameroon', '237-(206)654-3201');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (24, 'Universitas Muhammadiyah Malang', '93632 Surrey Drive', 'Feondari', 'D8', 'Indonesia', '62-(665)952-0916');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (25, 'Universitas Negeri Yogyakarta', '4 Macpherson Alley', 'Kedungdowo', 'D17', 'Indonesia', '62-(157)792-7988');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (26, 'Volgograd State University', '71 Dakota Alley', 'Pavlogradka', 'D24', 'Russia', '7-(808)743-1754');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (27, 'Universidad Autónoma de Centro América', '9 Meadow Ridge Street', 'Pocora', 'D18', 'Costa Rica', '506-(489)847-5075');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (28, 'Ningbo University of Technology', '138 Roth Plaza', 'Shuangmiao', 'D22', 'China', '86-(160)249-3051');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (29, 'Universitas Syiah Kuala', '58 Fairfield Junction', 'Neglasari', 'D19', 'Indonesia', '62-(499)412-3758');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (30, 'Universidade Tecnica de Lisboa', '33 Oneill Place', 'Pobral', 'D21', 'Portugal', '351-(955)215-5758');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (31, 'Yan''an University', '79 Mesta Plaza', 'Yanmen', 'D9', 'China', '86-(787)219-6338');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (32, 'Far Eastern State Technical University', '275 Wayridge Center', 'Muchkapskiy', 'D5', 'Russia', '7-(418)893-5821');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (33, 'Danang College Of Technology', '4 Anthes Road', 'Anh Son', 'D18', 'Vietnam', '84-(982)437-5380');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (34, 'European Academy of Arts in Warsaw', '807 Red Cloud Plaza', 'Pokrzywnica', 'D15', 'Poland', '48-(835)576-8144');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (35, 'Xinjiang Agriculture University', '610 Hayes Trail', 'Shouxihu', 'D17', 'China', '86-(554)182-5407');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (36, 'Instituto Superior de Entre Douro e Vouga', '583 International Drive', 'Gândara de Aquém', 'D20', 'Portugal', '351-(833)108-7911');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (37, 'Notre Dame of Marbel University', '964 Melrose Park', 'San Diego', 'D22', 'Philippines', '63-(755)185-3828');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (38, 'Liaocheng Teachers University', '11247 Shoshone Avenue', 'Fengjiang', 'D18', 'China', '86-(197)676-4041');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (39, 'The Superior College ', '39452 Bartillon Hill', 'Khairpur', 'D10', 'Pakistan', '92-(615)440-8875');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (40, 'South China Agricultural University', '7 Aberg Drive', 'Tingsiqiao', 'D23', 'China', '86-(277)522-4965');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (41, 'Asian University of Science and Technology', '486 Thierer Hill', 'Bang Mun Nak', 'D20', 'Thailand', '66-(300)394-8464');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (42, 'University of the Philippines Manila', '68 Parkside Terrace', 'Navatat', 'D15', 'Philippines', '63-(847)964-2108');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (43, 'Tanta University', '566 6th Street', '‘Izbat al Burj', 'D16', 'Egypt', '20-(772)866-7032');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (44, 'Universidad Blas Pascal', '46 Bayside Parkway', 'La Rioja', 'D23', 'Argentina', '54-(324)310-6018');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (45, 'Arab American University - Jenin', '87179 East Road', 'Ḩablah', 'D20', 'Palestinian Territory', '970-(669)696-4632');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (46, 'Universidad Señor de Sipán', '3 Browning Lane', 'Coalaque', 'D13', 'Peru', '51-(268)785-0864');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (47, 'Shanghai Lixin University of Commerce', '60 Meadow Ridge Street', 'Huarong', 'D6', 'China', '86-(391)252-7144');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (48, 'Göteborg University', '26488 David Street', 'Falun', 'D20', 'Sweden', '46-(969)334-6916');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (49, 'Universitas Semarang', '45290 Carioca Junction', 'Puamata', 'D4', 'Indonesia', '62-(736)374-6637');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (50, 'University College of Arts, Crafts and Design', '2602 Utah Avenue', 'Falun', 'D5', 'Sweden', '46-(888)507-1079');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (51, 'Universitas Kristen Indonesia Tomohon', '054 Fisk Park', 'Gajrug', 'D14', 'Indonesia', '62-(902)594-0118');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (52, 'Universidad Mariano Gálvez', '8608 Pierstorff Way', 'Sacapulas', 'D7', 'Guatemala', '502-(437)962-5419');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (53, 'Colorado State University-Pueblo', '15374 Talisman Street', 'Reno', 'D16', 'United States', '1-(775)425-0348');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (54, 'Jishou University', '43123 Duke Terrace', 'Sunduan', 'D19', 'China', '86-(736)731-2969');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (55, 'Chengdu Institute University', '02 Roxbury Alley', 'Liujiage', 'D17', 'China', '86-(128)524-6857');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (56, 'Orenburg State University', '83983 Emmet Junction', 'Galitsy', 'D17', 'Russia', '7-(829)904-7778');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (57, 'Capital University of Economics and Business', '3 Jana Junction', 'Jiuzhen', 'D19', 'China', '86-(913)698-6115');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (58, 'Faculdades Integradas Curitiba', '8 Hooker Court', 'Itaperuna', 'D9', 'Brazil', '55-(180)319-2314');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (59, 'Université Catholique de l'' Ouest', '7728 Del Sol Street', 'Boé', 'D7', 'France', '33-(361)489-5081');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (60, 'Murmansk State Technical University', '5 Rusk Way', 'Bayangol', 'D8', 'Russia', '7-(562)912-9169');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (61, 'Carlow Institute of Technology', '08 Elka Point', 'Monkstown', 'D22', 'Ireland', '353-(378)199-8961');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (62, 'Neijiang Teacher University', '8 Springview Hill', 'Mulong', 'D18', 'China', '86-(565)303-4791');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (63, 'Jiangxi University of Traditional Chinese Medicine', '31451 Westridge Circle', 'Sanzao', 'D24', 'China', '86-(404)278-8042');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (64, 'Universidad Popular Autonóma del Estado de Puebla', '29474 Golden Leaf Circle', 'Vicente Guerrero', 'D9', 'Mexico', '52-(410)909-0199');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (65, 'Fine Arts Academy in Gdansk', '3606 Armistice Road', 'Biała Piska', 'D18', 'Poland', '48-(263)287-2323');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (66, 'Universidade de Lisboa', '6 Hintze Avenue', 'Baratã', 'D6', 'Portugal', '351-(455)384-2969');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (67, 'Nayanova University', '4798 Debs Drive', 'Meshcherino', 'D13', 'Russia', '7-(247)614-7352');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (68, 'Universidad Nacional de Formosa', '076 Fulton Junction', 'Libertador General San Martín', 'D10', 'Argentina', '54-(656)298-5023');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (69, 'Universitas Ahmad Dahlan', '3317 West Terrace', 'Rahayu', 'D19', 'Indonesia', '62-(821)913-4189');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (70, 'Universidad Salesiana', '6 Jana Junction', 'San Marcos', 'D12', 'Mexico', '52-(780)515-4286');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (71, 'Universidade da Madeira', '5 Iowa Center', 'Macedo de Cavaleiros', 'D24', 'Portugal', '351-(103)776-8491');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (72, 'Gnesins Russian Academy of Music', '15 Harper Junction', 'Primorskiy', 'D20', 'Russia', '7-(502)654-0736');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (73, 'Saratov State Agrarian University', '01 Grasskamp Lane', 'Syktyvkar', 'D3', 'Russia', '7-(180)504-0604');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (74, 'Kerman University of Medical Sciences', '70 Eastlawn Trail', 'Kelīshād va Sūdarjān', 'D13', 'Iran', '98-(448)631-6354');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (75, 'Engineering College of Aarhus', '1 Pawling Lane', 'København', 'D15', 'Denmark', '45-(416)260-1046');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (76, 'Al-Nasser University', '4570 Sycamore Park', 'Sayyān', 'D19', 'Yemen', '967-(637)370-3500');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (77, 'Escuela Superior Politécnica del Litoral', '3 High Crossing Terrace', 'La Libertad', 'D16', 'Ecuador', '593-(470)808-0638');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (78, 'Universitas Bakrie', '085 Atwood Lane', 'Cigadog', 'D24', 'Indonesia', '62-(874)409-1256');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (79, 'Instituto Politécnico Nacional', '965 Mitchell Center', 'La Cruz', 'D2', 'Mexico', '52-(124)798-0064');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (80, 'University of Vlora "Ismail Qemali"', '0299 Village Terrace', 'Peza e Madhe', 'D24', 'Albania', '355-(965)576-3045');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (81, 'Vongchavalitkul University', '18 Glendale Road', 'Bang Nam Priao', 'D2', 'Thailand', '66-(328)677-9348');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (82, 'Ecole Nationale Supérieure de Chimie de Lille', '023 Mayer Place', 'Angoulême', 'D21', 'France', '33-(103)411-5662');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (83, 'Universitas Islam Indonesia', '9 Hauk Trail', 'Serang', 'D22', 'Indonesia', '62-(748)886-3213');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (84, 'Xi''an International Studies University', '94 Sloan Parkway', 'Nanjie', 'D10', 'China', '86-(548)650-1199');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (85, 'Communication University of China', '9556 John Wall Plaza', 'Yanjiang', 'D6', 'China', '86-(291)370-2883');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (86, 'Universitas 17 Agustus 1945 Surabaya', '7967 1st Terrace', 'Pakusari', 'D3', 'Indonesia', '62-(771)454-5136');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (87, 'University of Batangas', '272 Parkside Court', 'Balibagan Oeste', 'D9', 'Philippines', '63-(561)960-2109');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (88, 'East Kazakhstan State University', '90 Welch Crossing', 'Kokshetau', 'D24', 'Kazakhstan', '7-(386)857-7707');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (89, 'Chongqing Medical University', '1193 Pearson Plaza', 'Lushikeng', 'D10', 'China', '86-(499)890-6657');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (90, 'Universidad de Piura', '271 Mallard Lane', 'Antabamba', 'D1', 'Peru', '51-(347)316-4580');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (91, 'Victoria University Toronto, University of Toronto', '4329 Chinook Street', 'Grand Bank', 'D15', 'Canada', '1-(448)907-3961');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (92, 'Trinity College Carmarthen', '40 Merry Road', 'Merton', 'D9', 'United Kingdom', '44-(648)474-6433');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (93, 'Universidad Católica de Salta', '88133 Mosinee Court', 'Tres Isletas', 'D4', 'Argentina', '54-(269)388-6204');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (94, 'Bogor Agricultural University', '567 Carey Terrace', 'Barusuda', 'D14', 'Indonesia', '62-(451)639-7967');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (95, 'Manuel L. Quezon University', '3951 Butternut Plaza', 'Tiguha', 'D5', 'Philippines', '63-(378)961-1169');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (96, 'Kursk State Medical University', '4 Little Fleur Terrace', 'Krasnofarfornyy', 'D2', 'Russia', '7-(659)252-8432');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (97, 'University of Modern Sciences', '536 Hagan Hill', 'Al Ḩumaydāt', 'D9', 'Yemen', '967-(383)954-0548');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (98, 'Universitas Darma Agung', '2158 Algoma Trail', 'Pasirbatang', 'D23', 'Indonesia', '62-(323)675-7149');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (99, 'Silesian University', '2 Merrick Court', 'Želešice', 'D14', 'Czech Republic', '420-(937)270-7303');
insert into College (collegeID, name, addr1, addr2, postalCode, county, contactNum) values (100, 'Universitas Sultan Ageng Tirtayasa', '36 Dayton Court', 'Jatirejo', 'D13', 'Indonesia', '62-(749)518-0665');
insert into course (collegeID, courseCode, courseName) values (1, 1, 'BA (Honours) in Business');
insert into course (collegeID, courseCode, courseName) values (1, 2, 'BA (Honours) in Human Resource Management');
insert into course (collegeID, courseCode, courseName) values (1, 3, 'BA (Honours) in Marketing Practice');
insert into course (collegeID, courseCode, courseName) values (1, 4, 'BA (Hons) in Early Childhood Education');
insert into course (collegeID, courseCode, courseName) values (1, 5, 'BA (Hons) Psychology - Evening');
insert into course (collegeID, courseCode, courseName) values (1, 6, 'BA Honours in Adult and Workforce Education');
insert into course (collegeID, courseCode, courseName) values (1, 7, 'BA Honours in Business Management');
insert into course (collegeID, courseCode, courseName) values (1, 8, 'Bachelor of Arts (Hons) Psychology');
insert into course (collegeID, courseCode, courseName) values (1, 9, 'BSc (Honours) in Computing');
insert into course (collegeID, courseCode, courseName) values (1, 10, 'BSc (Honours) in Computing - Evening');
insert into course (collegeID, courseCode, courseName) values (1, 11, 'BSc (Hons) in Business Information Systems');
insert into course (collegeID, courseCode, courseName) values (1, 12, 'BSc (Hons) in Business Information Systems - Part-time');
insert into course (collegeID, courseCode, courseName) values (1, 13, 'BSc (Hons) in Technology Management');
insert into course (collegeID, courseCode, courseName) values (1, 14, 'BSc (Hons) in Technology Management Evening');
insert into course (collegeID, courseCode, courseName) values (1, 15, 'Certificate in Business Analysis');
insert into course (collegeID, courseCode, courseName) values (1, 16, 'Certificate in Credit Union Compliance and Risk');
insert into course (collegeID, courseCode, courseName) values (1, 17, 'Certificate in Digital Marketing');
insert into course (collegeID, courseCode, courseName) values (1, 18, 'Certificate in Financial Regulation');
insert into course (collegeID, courseCode, courseName) values (1, 19, 'Certificate in First Line Management');
insert into course (collegeID, courseCode, courseName) values (1, 20, 'Certificate in Personal Financial Planning');
insert into course (collegeID, courseCode, courseName) values (1, 21, 'CIPD Award in Digital and Blended Learning');
insert into course (collegeID, courseCode, courseName) values (1, 22, 'CIPD Award in Employment Law and Employee Relations');
insert into course (collegeID, courseCode, courseName) values (1, 23, 'CIPD Certificate in HRM');
insert into course (collegeID, courseCode, courseName) values (1, 24, 'CIPD Certificate in Learning and Development');
insert into course (collegeID, courseCode, courseName) values (1, 25, 'CIPD Diploma in HRM');
insert into course (collegeID, courseCode, courseName) values (1, 26, 'CIPD Diploma in Learning and Development');
insert into course (collegeID, courseCode, courseName) values (1, 27, 'Diploma in Marketing Advertising Public Relations and Sales');
insert into course (collegeID, courseCode, courseName) values (1, 28, 'Diploma in Pensions Management & Policy - Online');
insert into course (collegeID, courseCode, courseName) values (1, 29, 'Higher Certificate in Business');
insert into course (collegeID, courseCode, courseName) values (1, 30, 'Higher Certificate in Science in Business Computing');
insert into course (collegeID, courseCode, courseName) values (1, 31, 'Higher Certificate in Science in Computing Applications and Business Support');
insert into course (collegeID, courseCode, courseName) values (1, 32, 'Higher Diploma in Business in Finance -part time');
insert into course (collegeID, courseCode, courseName) values (1, 33, 'Higher Diploma in Science in Computing');
insert into course (collegeID, courseCode, courseName) values (1, 34, 'Higher Diploma in Science in Data Analytics');
insert into course (collegeID, courseCode, courseName) values (1, 35, 'Higher Diploma in Science in Fintech');
insert into course (collegeID, courseCode, courseName) values (1, 36, 'Higher Diploma in Science in Web Technologies');
insert into Classes (className, lecturer, assistant, courseCode) values ('The Computing Industry', 'Jesse Wheeler', 'Michelle Wright', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('The Computing Industry', 'Terry Nelson', 'Irene Owens', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Managing Your Learning', 'Martha Foster', 'Raymond Butler', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Managing Your Learning', 'Elizabeth Burton', 'Joe Ruiz', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Problem Solving and Programming Concepts', 'Joseph Sanders', 'Barbara Harper', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Problem Solving and Programming Concepts', 'Jack Jacobs', 'Adam Sullivan', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Introduction to Mathematics for Business & Computing', 'Marilyn Kim', 'Karen Roberts', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Introduction to Mathematics for Business & Computing', 'Lori West', 'Russell Bennett', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Web Design', 'Judy Ward', 'Julie Smith', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Web Design', 'Margaret Moore', 'Ernest Ferguson', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Digital Multimedia', 'Patricia Garcia', 'Terry Lawrence', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Digital Multimedia', 'Shirley Duncan', 'Anne Palmer', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Software Applications for Business', 'Gregory Arnold', 'Christopher Stewart', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Software Applications for Business', 'Elizabeth Dean', 'Steven Edwards', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Introduction to Programming', 'Billy Cole', 'Ryan Marshall', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Introduction to Programming', 'Keith Gomez', 'Brenda Oliver', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Computer Architecture', 'Virginia Bell', 'Annie Butler', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Computer Architecture', 'Sharon Murphy', 'Lawrence Palmer', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Introduction to Marketing', 'Patrick Gardner', 'Emily Little', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Introduction to Marketing', 'Rose Allen', 'Johnny Lawson', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Operating Systems', 'Diane Hansen', 'Robin Roberts', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Operating Systems', 'Roger Rivera', 'William Phillips', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Web Application Development', 'Patricia Morgan', 'Ruby Perez', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Web Application Development', 'Patricia Kennedy', 'Robert Wilson', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Fundamentals of Business Analysis', 'Diana Morris', 'Patricia Morgan', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Fundamentals of Business Analysis', 'Kevin Henderson', 'Charles Meyer', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Object Oriented Programming', 'Jerry Nelson', 'Keith Andrews', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Object Oriented Programming', 'Earl Richardson', 'Craig Anderson', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('IT Project Management', 'Amy Sanchez', 'Anna Burns', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('IT Project Management', 'Peter Harvey', 'John Edwards', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Introduction to Databases', 'John James', 'Christina Little', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Introduction to Databases', 'Alan Butler', 'Jennifer Carpenter', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Data Communications and Networking', 'Mary Fields', 'Phillip Nichols', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Data Communications and Networking', 'Julie Mason', 'Carolyn Watson', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Interdisciplinary Team Project', 'Donna Carter', 'Jimmy Bradley', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Interdisciplinary Team Project', 'Louis Ellis', 'Sarah Montgomery', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Business Entrepreneurship', 'Kimberly Morgan', 'Jimmy Henry', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Business Entrepreneurship', 'Ernest Nguyen', 'Melissa Hansen', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Software Engineering', 'Joe Alexander', 'Irene Duncan', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Software Engineering', 'Harold Hill', 'Debra Frazier', 31);
insert into Classes (className, lecturer, assistant, courseCode) values ('Data Structures', 'Deborah Medina', 'Shirley Wagner', 9);
insert into Classes (className, lecturer, assistant, courseCode) values ('Data Structures', 'Ruby Hansen', 'Jeffrey Gilbert', 31);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x16822375', 'Emily', 'Hunter', 'qdgnWP1JtdK', '[email protected]', '23 Chinook Park', 'Ohio', 'Cincinnati', 'United States', 'United States', 9);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x16389847', 'Larry', 'Reed', '6cFeRTFsb60', '[email protected]', '9830 Boyd Way', 'California', 'Sacramento', 'United States', 'United States', 31);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x14023074', 'Benjamin', 'Mcdonald', 'ZKAFYo5rgMhx', '[email protected]', '51 Bellgrove Junction', 'Minnesota', 'Minneapolis', 'United States', 'United States', 9);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x15534742', 'Melissa', 'Hall', '42HUXU', '[email protected]', '87 Delaware Court', 'District of Columbia', 'Washington', 'United States', 'United States', 31);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x13785934', 'Andrea', 'Kelly', 'SBA2q082aAjz', '[email protected]', '4 Cody Way', 'Florida', 'Miami', 'United States', 'United States', 9);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x15075302', 'Margaret', 'Long', 'Yn2ZvYL0l7rF', '[email protected]', '9 Oakridge Street', 'Oklahoma', 'Oklahoma City', 'United States', 'United States', 31);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x15661896', 'Christina', 'Daniels', '5bAqMs0', '[email protected]', '8543 Coleman Parkway', 'Missouri', 'Kansas City', 'United States', 'United States', 9);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x13101474', 'Steven', 'Collins', '7Fdv9dA', '[email protected]', '4 Stephen Circle', 'Utah', 'Salt Lake City', 'United States', 'United States', 31);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x13672956', 'Steven', 'Daniels', 'upvedyCti', '[email protected]', '01 Elgar Terrace', 'Illinois', 'Rockford', 'United States', 'United States', 9);
insert into Student (studentNumber, fname, lname, pass, email, addr1, addr2, county, country, nationality, courseCode) values ('x15181499', 'Angela', 'Ferguson', 'wMd40qBAjDd', '[email protected]', '2 Charing Cross Parkway', 'Kentucky', 'Louisville', 'United States', 'United States', 31);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x16822375', 25);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x16822375', 73);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x16822375', 29);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x16822375', 68);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x16822375', 90);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x16822375', 82);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x16822375', 55);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x16822375', 61);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x16822375', 68);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x16822375', 10);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x16822375', 6);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x16389847', 75);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x16389847', 14);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x16389847', 43);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x16389847', 99);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x16389847', 62);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x16389847', 47);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x16389847', 38);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x16389847', 38);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x16389847', 14);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x16389847', 17);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x16389847', 73);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x14023074', 27);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x14023074', 6);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x14023074', 6);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x14023074', 18);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x14023074', 68);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x14023074', 71);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x14023074', 92);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x14023074', 25);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x14023074', 86);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x14023074', 8);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x14023074', 62);
insert into Grade (ClassName, studentNumber, grade) values ('Web Application Development', 'x14023074', 100);
insert into Grade (ClassName, studentNumber, grade) values ('Fundamentals of Business Analysis', 'x14023074', 7);
insert into Grade (ClassName, studentNumber, grade) values ('Object Oriented Programming', 'x14023074', 88);
insert into Grade (ClassName, studentNumber, grade) values ('IT Project Management', 'x14023074', 70);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Databases', 'x14023074', 91);
insert into Grade (ClassName, studentNumber, grade) values ('Data Communications and Networking', 'x14023074', 27);
insert into Grade (ClassName, studentNumber, grade) values ('Interdisciplinary Team Project', 'x14023074', 93);
insert into Grade (ClassName, studentNumber, grade) values ('Business Entrepreneurship', 'x14023074', 67);
insert into Grade (ClassName, studentNumber, grade) values ('Software Engineering', 'x14023074', 83);
insert into Grade (ClassName, studentNumber, grade) values ('Data Structures', 'x14023074', 94);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x15534742', 54);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x15534742', 21);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x15534742', 45);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x15534742', 38);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x15534742', 76);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x15534742', 80);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x15534742', 5);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x15534742', 16);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x15534742', 35);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x15534742', 99);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x15534742', 100);
insert into Grade (ClassName, studentNumber, grade) values ('Web Application Development', 'x15534742', 50);
insert into Grade (ClassName, studentNumber, grade) values ('Fundamentals of Business Analysis', 'x15534742', 92);
insert into Grade (ClassName, studentNumber, grade) values ('Object Oriented Programming', 'x15534742', 47);
insert into Grade (ClassName, studentNumber, grade) values ('IT Project Management', 'x15534742', 97);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Databases', 'x15534742', 16);
insert into Grade (ClassName, studentNumber, grade) values ('Data Communications and Networking', 'x15534742', 68);
insert into Grade (ClassName, studentNumber, grade) values ('Interdisciplinary Team Project', 'x15534742', 35);
insert into Grade (ClassName, studentNumber, grade) values ('Business Entrepreneurship', 'x15534742', 66);
insert into Grade (ClassName, studentNumber, grade) values ('Software Engineering', 'x15534742', 69);
insert into Grade (ClassName, studentNumber, grade) values ('Data Structures', 'x15534742', 50);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x13785934', 87);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x13785934', 12);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x13785934', 11);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x13785934', 4);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x13785934', 28);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x13785934', 75);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x13785934', 27);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x13785934', 92);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x13785934', 37);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x13785934', 82);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x13785934', 55);
insert into Grade (ClassName, studentNumber, grade) values ('Web Application Development', 'x13785934', 48);
insert into Grade (ClassName, studentNumber, grade) values ('Fundamentals of Business Analysis', 'x13785934', 86);
insert into Grade (ClassName, studentNumber, grade) values ('Object Oriented Programming', 'x13785934', 27);
insert into Grade (ClassName, studentNumber, grade) values ('IT Project Management', 'x13785934', 20);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Databases', 'x13785934', 13);
insert into Grade (ClassName, studentNumber, grade) values ('Data Communications and Networking', 'x13785934', 23);
insert into Grade (ClassName, studentNumber, grade) values ('Interdisciplinary Team Project', 'x13785934', 64);
insert into Grade (ClassName, studentNumber, grade) values ('Business Entrepreneurship', 'x13785934', 51);
insert into Grade (ClassName, studentNumber, grade) values ('Software Engineering', 'x13785934', 99);
insert into Grade (ClassName, studentNumber, grade) values ('Data Structures', 'x13785934', 81);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x15075302', 62);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x15075302', 96);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x15075302', 60);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x15075302', 44);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x15075302', 55);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x15075302', 78);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x15075302', 15);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x15075302', 30);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x15075302', 64);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x15075302', 79);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x15075302', 46);
insert into Grade (ClassName, studentNumber, grade) values ('Web Application Development', 'x15075302', 77);
insert into Grade (ClassName, studentNumber, grade) values ('Fundamentals of Business Analysis', 'x15075302', 59);
insert into Grade (ClassName, studentNumber, grade) values ('Object Oriented Programming', 'x15075302', 15);
insert into Grade (ClassName, studentNumber, grade) values ('IT Project Management', 'x15075302', 16);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Databases', 'x15075302', 28);
insert into Grade (ClassName, studentNumber, grade) values ('Data Communications and Networking', 'x15075302', 60);
insert into Grade (ClassName, studentNumber, grade) values ('Interdisciplinary Team Project', 'x15075302', 34);
insert into Grade (ClassName, studentNumber, grade) values ('Business Entrepreneurship', 'x15075302', 56);
insert into Grade (ClassName, studentNumber, grade) values ('Software Engineering', 'x15075302', 99);
insert into Grade (ClassName, studentNumber, grade) values ('Data Structures', 'x15075302', 23);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x15661896', 6);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x15661896', 67);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x15661896', 75);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x15661896', 54);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x15661896', 94);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x15661896', 11);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x15661896', 15);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x15661896', 35);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x15661896', 41);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x15661896', 21);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x15661896', 38);
insert into Grade (ClassName, studentNumber, grade) values ('Web Application Development', 'x15661896', 63);
insert into Grade (ClassName, studentNumber, grade) values ('Fundamentals of Business Analysis', 'x15661896', 31);
insert into Grade (ClassName, studentNumber, grade) values ('Object Oriented Programming', 'x15661896', 51);
insert into Grade (ClassName, studentNumber, grade) values ('IT Project Management', 'x15661896', 6);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Databases', 'x15661896', 97);
insert into Grade (ClassName, studentNumber, grade) values ('Data Communications and Networking', 'x15661896', 80);
insert into Grade (ClassName, studentNumber, grade) values ('Interdisciplinary Team Project', 'x15661896', 94);
insert into Grade (ClassName, studentNumber, grade) values ('Business Entrepreneurship', 'x15661896', 20);
insert into Grade (ClassName, studentNumber, grade) values ('Software Engineering', 'x15661896', 66);
insert into Grade (ClassName, studentNumber, grade) values ('Data Structures', 'x15661896', 84);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x13101474', 6);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x13101474', 36);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x13101474', 65);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x13101474', 19);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x13101474', 47);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x13101474', 38);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x13101474', 59);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x13101474', 70);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x13101474', 72);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x13101474', 77);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x13101474', 98);
insert into Grade (ClassName, studentNumber, grade) values ('Web Application Development', 'x13101474', 33);
insert into Grade (ClassName, studentNumber, grade) values ('Fundamentals of Business Analysis', 'x13101474', 50);
insert into Grade (ClassName, studentNumber, grade) values ('Object Oriented Programming', 'x13101474', 98);
insert into Grade (ClassName, studentNumber, grade) values ('IT Project Management', 'x13101474', 85);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Databases', 'x13101474', 9);
insert into Grade (ClassName, studentNumber, grade) values ('Data Communications and Networking', 'x13101474', 37);
insert into Grade (ClassName, studentNumber, grade) values ('Interdisciplinary Team Project', 'x13101474', 64);
insert into Grade (ClassName, studentNumber, grade) values ('Business Entrepreneurship', 'x13101474', 95);
insert into Grade (ClassName, studentNumber, grade) values ('Software Engineering', 'x13101474', 72);
insert into Grade (ClassName, studentNumber, grade) values ('Data Structures', 'x13101474', 13);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x13672956', 16);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x13672956', 55);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x13672956', 60);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x13672956', 7);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x13672956', 74);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x13672956', 42);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x13672956', 18);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x13672956', 86);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x13672956', 69);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x13672956', 56);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x13672956', 21);
insert into Grade (ClassName, studentNumber, grade) values ('Web Application Development', 'x13672956', 18);
insert into Grade (ClassName, studentNumber, grade) values ('Fundamentals of Business Analysis', 'x13672956', 20);
insert into Grade (ClassName, studentNumber, grade) values ('Object Oriented Programming', 'x13672956', 93);
insert into Grade (ClassName, studentNumber, grade) values ('IT Project Management', 'x13672956', 50);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Databases', 'x13672956', 98);
insert into Grade (ClassName, studentNumber, grade) values ('Data Communications and Networking', 'x13672956', 60);
insert into Grade (ClassName, studentNumber, grade) values ('Interdisciplinary Team Project', 'x13672956', 51);
insert into Grade (ClassName, studentNumber, grade) values ('Business Entrepreneurship', 'x13672956', 54);
insert into Grade (ClassName, studentNumber, grade) values ('Software Engineering', 'x13672956', 7);
insert into Grade (ClassName, studentNumber, grade) values ('Data Structures', 'x13672956', 90);
insert into Grade (ClassName, studentNumber, grade) values ('The Computing Industry', 'x15181499', 54);
insert into Grade (ClassName, studentNumber, grade) values ('Managing Your Learning', 'x15181499', 25);
insert into Grade (ClassName, studentNumber, grade) values ('Problem Solving and Programming Concepts', 'x15181499', 70);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Mathematics for Business & Computing', 'x15181499', 78);
insert into Grade (ClassName, studentNumber, grade) values ('Web Design', 'x15181499', 45);
insert into Grade (ClassName, studentNumber, grade) values ('Digital Multimedia', 'x15181499', 44);
insert into Grade (ClassName, studentNumber, grade) values ('Software Applications for Business', 'x15181499', 25);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Programming', 'x15181499', 11);
insert into Grade (ClassName, studentNumber, grade) values ('Computer Architecture', 'x15181499', 28);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Marketing', 'x15181499', 93);
insert into Grade (ClassName, studentNumber, grade) values ('Operating Systems', 'x15181499', 92);
insert into Grade (ClassName, studentNumber, grade) values ('Web Application Development', 'x15181499', 38);
insert into Grade (ClassName, studentNumber, grade) values ('Fundamentals of Business Analysis', 'x15181499', 60);
insert into Grade (ClassName, studentNumber, grade) values ('Object Oriented Programming', 'x15181499', 60);
insert into Grade (ClassName, studentNumber, grade) values ('IT Project Management', 'x15181499', 81);
insert into Grade (ClassName, studentNumber, grade) values ('Introduction to Databases', 'x15181499', 53);
insert into Grade (ClassName, studentNumber, grade) values ('Data Communications and Networking', 'x15181499', 53);
insert into Grade (ClassName, studentNumber, grade) values ('Interdisciplinary Team Project', 'x15181499', 93);
insert into Grade (ClassName, studentNumber, grade) values ('Business Entrepreneurship', 'x15181499', 25);
insert into Grade (ClassName, studentNumber, grade) values ('Software Engineering', 'x15181499', 25);
insert into Grade (ClassName, studentNumber, grade) values ('Data Structures', 'x15181499', 18);
insert into Library (bookID, collegeID, title, author, description, image, category) values ('541720477', 1, 'ut', 'Irene Perez', 'Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est.', 'http://dummyimage.com/178x120.png/5fa2dd/ffffff', 'Computer science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('826260812', 1, 'ante ipsum primis', 'Kimberly Kelly', 'In congue. Etiam justo. Etiam pretium iaculis justo.', 'http://dummyimage.com/129x238.jpg/5fa2dd/ffffff', 'information and general works');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('114325639', 1, 'blandit', 'David Kelley', 'Nam ultrices, libero non mattis pulvinar, nulla pede ullamcorper augue, a suscipit nulla elit ac nulla. Sed vel enim sit amet nunc viverra dapibus. Nulla suscipit ligula in lacus.
Curabitur at ipsum ac tellus semper interdum. Mauris ullamcorper purus sit amet nulla. Quisque arcu libero, rutrum ac, lobortis vel, dapibus at, diam.', 'http://dummyimage.com/207x247.jpg/dddddd/000000', 'Philosophy and psychology');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('021886458', 1, 'leo', 'Melissa Mason', 'Praesent blandit. Nam nulla. Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede.
Morbi porttitor lorem id ligula. Suspendisse ornare consequat lectus. In est risus, auctor sed, tristique in, tempus sit amet, sem.', 'http://dummyimage.com/245x158.jpg/cc0000/ffffff', 'Religion');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('676783042', 1, 'phasellus sit', 'Antonio Mills', 'Fusce consequat. Nulla nisl. Nunc nisl.
Duis bibendum, felis sed interdum venenatis, turpis enim blandit mi, in porttitor pede justo eu massa. Donec dapibus. Duis at velit eu est congue elementum.', 'http://dummyimage.com/236x113.jpg/dddddd/000000', 'Social Sciences');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('407085073', 1, 'eu tincidunt in', 'Catherine Lawrence', 'Nullam porttitor lacus at turpis. Donec posuere metus vitae ipsum. Aliquam non mauris.', 'http://dummyimage.com/237x243.jpg/ff4444/ffffff', 'Language');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('196995201', 1, 'cubilia', 'Louis Rodriguez', 'Aenean fermentum. Donec ut mauris eget massa tempor convallis. Nulla neque libero, convallis eget, eleifend luctus, ultricies eu, nibh.
Quisque id justo sit amet sapien dignissim vestibulum. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla dapibus dolor vel est. Donec odio justo, sollicitudin ut, suscipit a, feugiat et, eros.', 'http://dummyimage.com/152x113.png/5fa2dd/ffffff', 'Science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('097686060', 1, 'praesent blandit nam', 'Martha Rodriguez', 'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus vestibulum sagittis sapien. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.
Etiam vel augue. Vestibulum rutrum rutrum neque. Aenean auctor gravida sem.', 'http://dummyimage.com/142x216.jpg/ff4444/ffffff', 'Technology and applied science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('802642880', 1, 'varius integer ac', 'Cheryl Green', 'Morbi porttitor lorem id ligula. Suspendisse ornare consequat lectus. In est risus, auctor sed, tristique in, tempus sit amet, sem.
Fusce consequat. Nulla nisl. Nunc nisl.', 'http://dummyimage.com/236x176.bmp/5fa2dd/ffffff', 'Arts and recreation');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('748467404', 1, 'etiam pretium iaculis', 'Wanda Medina', 'Aenean lectus. Pellentesque eget nunc. Donec quis orci eget orci vehicula condimentum.
Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est.', 'http://dummyimage.com/147x199.jpg/ff4444/ffffff', 'Literature');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('947847262', 1, 'nulla', 'Susan Pierce', 'Aliquam quis turpis eget elit sodales scelerisque. Mauris sit amet eros. Suspendisse accumsan tortor quis turpis.', 'http://dummyimage.com/205x236.jpg/cc0000/ffffff', 'History and geography');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('672524594', 1, 'hac', 'Kenneth Baker', 'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus vestibulum sagittis sapien. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.
Etiam vel augue. Vestibulum rutrum rutrum neque. Aenean auctor gravida sem.', 'http://dummyimage.com/151x162.png/ff4444/ffffff', 'Computer science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('803389276', 1, 'porta', 'Michael Berry', 'Sed ante. Vivamus tortor. Duis mattis egestas metus.', 'http://dummyimage.com/118x233.png/5fa2dd/ffffff', 'information and general works');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('148953823', 1, 'et eros', 'Harold Robinson', 'Maecenas leo odio, condimentum id, luctus nec, molestie sed, justo. Pellentesque viverra pede ac diam. Cras pellentesque volutpat dui.', 'http://dummyimage.com/240x105.bmp/cc0000/ffffff', 'Philosophy and psychology');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('338553622', 1, 'ante nulla', 'Joan Hudson', 'Fusce posuere felis sed lacus. Morbi sem mauris, laoreet ut, rhoncus aliquet, pulvinar sed, nisl. Nunc rhoncus dui vel sem.
Sed sagittis. Nam congue, risus semper porta volutpat, quam pede lobortis ligula, sit amet eleifend pede libero quis orci. Nullam molestie nibh in lectus.', 'http://dummyimage.com/132x183.bmp/5fa2dd/ffffff', 'Religion');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('702548287', 1, 'congue vivamus', 'Annie Murphy', 'Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit.', 'http://dummyimage.com/149x110.bmp/ff4444/ffffff', 'Social Sciences');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('638359919', 1, 'diam', 'Jerry Rogers', 'Suspendisse potenti. In eleifend quam a odio. In hac habitasse platea dictumst.', 'http://dummyimage.com/186x175.bmp/ff4444/ffffff', 'Language');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('054199233', 1, 'mattis egestas', 'Robin Anderson', 'Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum.', 'http://dummyimage.com/116x138.png/cc0000/ffffff', 'Science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('104989036', 1, 'pellentesque', 'Roger Price', 'Duis consequat dui nec nisi volutpat eleifend. Donec ut dolor. Morbi vel lectus in quam fringilla rhoncus.', 'http://dummyimage.com/235x122.png/5fa2dd/ffffff', 'Technology and applied science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('016939088', 1, 'velit id', 'Virginia Kennedy', 'Integer ac leo. Pellentesque ultrices mattis odio. Donec vitae nisi.
Nam ultrices, libero non mattis pulvinar, nulla pede ullamcorper augue, a suscipit nulla elit ac nulla. Sed vel enim sit amet nunc viverra dapibus. Nulla suscipit ligula in lacus.', 'http://dummyimage.com/182x214.png/cc0000/ffffff', 'Arts and recreation');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('396364721', 1, 'vivamus vel', 'Marie Watkins', 'Proin leo odio, porttitor id, consequat in, consequat ut, nulla. Sed accumsan felis. Ut at dolor quis odio consequat varius.', 'http://dummyimage.com/212x230.bmp/cc0000/ffffff', 'Literature');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('624538872', 1, 'dui', 'Earl Lynch', 'Sed sagittis. Nam congue, risus semper porta volutpat, quam pede lobortis ligula, sit amet eleifend pede libero quis orci. Nullam molestie nibh in lectus.
Pellentesque at nulla. Suspendisse potenti. Cras in purus eu magna vulputate luctus.', 'http://dummyimage.com/102x238.jpg/5fa2dd/ffffff', 'History and geography');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('225375092', 1, 'in', 'Ashley Stanley', 'Quisque porta volutpat erat. Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla. Nunc purus.
Phasellus in felis. Donec semper sapien a libero. Nam dui.', 'http://dummyimage.com/180x183.png/cc0000/ffffff', 'Computer science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('746178279', 1, 'est lacinia nisi', 'Angela Garza', 'Suspendisse potenti. In eleifend quam a odio. In hac habitasse platea dictumst.
Maecenas ut massa quis augue luctus tincidunt. Nulla mollis molestie lorem. Quisque ut erat.', 'http://dummyimage.com/250x114.jpg/5fa2dd/ffffff', 'information and general works');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('305973776', 1, 'volutpat dui maecenas', 'Carl Harrison', 'Integer ac leo. Pellentesque ultrices mattis odio. Donec vitae nisi.
Nam ultrices, libero non mattis pulvinar, nulla pede ullamcorper augue, a suscipit nulla elit ac nulla. Sed vel enim sit amet nunc viverra dapibus. Nulla suscipit ligula in lacus.', 'http://dummyimage.com/169x186.jpg/dddddd/000000', 'Philosophy and psychology');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('093176878', 1, 'turpis elementum', 'Steven Hughes', 'In congue. Etiam justo. Etiam pretium iaculis justo.
In hac habitasse platea dictumst. Etiam faucibus cursus urna. Ut tellus.', 'http://dummyimage.com/124x238.png/5fa2dd/ffffff', 'Religion');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('908455829', 1, 'tortor id', 'Nicole Sims', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin risus. Praesent lectus.
Vestibulum quam sapien, varius ut, blandit non, interdum in, ante. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Duis faucibus accumsan odio. Curabitur convallis.', 'http://dummyimage.com/141x188.png/5fa2dd/ffffff', 'Social Sciences');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('686500366', 1, 'tortor sollicitudin mi', 'Roger Warren', 'Duis bibendum, felis sed interdum venenatis, turpis enim blandit mi, in porttitor pede justo eu massa. Donec dapibus. Duis at velit eu est congue elementum.
In hac habitasse platea dictumst. Morbi vestibulum, velit id pretium iaculis, diam erat fermentum justo, nec condimentum neque sapien placerat ante. Nulla justo.', 'http://dummyimage.com/115x223.png/cc0000/ffffff', 'Language');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('548457373', 1, 'tristique est', 'Jerry Phillips', 'Morbi porttitor lorem id ligula. Suspendisse ornare consequat lectus. In est risus, auctor sed, tristique in, tempus sit amet, sem.', 'http://dummyimage.com/103x138.png/ff4444/ffffff', 'Science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('492229268', 1, 'sapien dignissim vestibulum', 'Paul Barnes', 'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus vestibulum sagittis sapien. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.
Etiam vel augue. Vestibulum rutrum rutrum neque. Aenean auctor gravida sem.', 'http://dummyimage.com/231x176.png/cc0000/ffffff', 'Technology and applied science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('656320618', 1, 'duis', 'Robert Gardner', 'Mauris enim leo, rhoncus sed, vestibulum sit amet, cursus id, turpis. Integer aliquet, massa id lobortis convallis, tortor risus dapibus augue, vel accumsan tellus nisi eu orci. Mauris lacinia sapien quis libero.', 'http://dummyimage.com/157x122.jpg/cc0000/ffffff', 'Arts and recreation');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('047274893', 1, 'tincidunt eu', 'Howard Hicks', 'Integer ac leo. Pellentesque ultrices mattis odio. Donec vitae nisi.', 'http://dummyimage.com/164x124.png/5fa2dd/ffffff', 'Literature');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('539853072', 1, 'nibh in quis', 'Jimmy Lawson', 'Fusce posuere felis sed lacus. Morbi sem mauris, laoreet ut, rhoncus aliquet, pulvinar sed, nisl. Nunc rhoncus dui vel sem.', 'http://dummyimage.com/214x201.bmp/cc0000/ffffff', 'History and geography');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('343719703', 1, 'suscipit nulla', 'Marilyn Arnold', 'Fusce posuere felis sed lacus. Morbi sem mauris, laoreet ut, rhoncus aliquet, pulvinar sed, nisl. Nunc rhoncus dui vel sem.', 'http://dummyimage.com/213x163.bmp/5fa2dd/ffffff', 'Computer science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('079521948', 1, 'velit vivamus vel', 'Laura Lee', 'In sagittis dui vel nisl. Duis ac nibh. Fusce lacus purus, aliquet at, feugiat non, pretium quis, lectus.', 'http://dummyimage.com/169x193.bmp/cc0000/ffffff', 'information and general works');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('670711424', 1, 'rhoncus aliquam', 'Brandon Snyder', 'In hac habitasse platea dictumst. Morbi vestibulum, velit id pretium iaculis, diam erat fermentum justo, nec condimentum neque sapien placerat ante. Nulla justo.
Aliquam quis turpis eget elit sodales scelerisque. Mauris sit amet eros. Suspendisse accumsan tortor quis turpis.', 'http://dummyimage.com/186x151.jpg/5fa2dd/ffffff', 'Philosophy and psychology');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('231156200', 1, 'nec', 'Frances Larson', 'Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue. Vivamus metus arcu, adipiscing molestie, hendrerit at, vulputate vitae, nisl.', 'http://dummyimage.com/219x248.png/dddddd/000000', 'Religion');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('673781863', 1, 'mauris non ligula', 'Donna Payne', 'Fusce posuere felis sed lacus. Morbi sem mauris, laoreet ut, rhoncus aliquet, pulvinar sed, nisl. Nunc rhoncus dui vel sem.', 'http://dummyimage.com/198x186.jpg/5fa2dd/ffffff', 'Social Sciences');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('289102371', 1, 'lacus curabitur', 'Paul Gonzales', 'Nullam sit amet turpis elementum ligula vehicula consequat. Morbi a ipsum. Integer a nibh.', 'http://dummyimage.com/214x137.bmp/ff4444/ffffff', 'Language');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('431184257', 1, 'sed', 'Patrick Watson', 'Maecenas leo odio, condimentum id, luctus nec, molestie sed, justo. Pellentesque viverra pede ac diam. Cras pellentesque volutpat dui.
Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Mauris viverra diam vitae quam. Suspendisse potenti.', 'http://dummyimage.com/168x120.bmp/dddddd/000000', 'Science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('864673761', 1, 'ligula pellentesque', 'Walter James', 'Aenean fermentum. Donec ut mauris eget massa tempor convallis. Nulla neque libero, convallis eget, eleifend luctus, ultricies eu, nibh.', 'http://dummyimage.com/116x130.png/ff4444/ffffff', 'Technology and applied science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('282740586', 1, 'orci luctus', 'Brian Crawford', 'Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum.', 'http://dummyimage.com/182x100.png/5fa2dd/ffffff', 'Arts and recreation');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('040865516', 1, 'quis', 'Ashley Dean', 'In hac habitasse platea dictumst. Morbi vestibulum, velit id pretium iaculis, diam erat fermentum justo, nec condimentum neque sapien placerat ante. Nulla justo.', 'http://dummyimage.com/137x212.bmp/cc0000/ffffff', 'Literature');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('361494312', 1, 'nullam porttitor', 'Brandon Bryant', 'Fusce consequat. Nulla nisl. Nunc nisl.
Duis bibendum, felis sed interdum venenatis, turpis enim blandit mi, in porttitor pede justo eu massa. Donec dapibus. Duis at velit eu est congue elementum.', 'http://dummyimage.com/219x100.bmp/cc0000/ffffff', 'History and geography');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('593867461', 1, 'vitae mattis', 'Angela Henderson', 'Morbi non lectus. Aliquam sit amet diam in magna bibendum imperdiet. Nullam orci pede, venenatis non, sodales sed, tincidunt eu, felis.', 'http://dummyimage.com/172x173.bmp/ff4444/ffffff', 'Computer science');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('355201927', 1, 'donec ut mauris', 'Barbara Martinez', 'Nullam porttitor lacus at turpis. Donec posuere metus vitae ipsum. Aliquam non mauris.', 'http://dummyimage.com/154x169.png/5fa2dd/ffffff', 'information and general works');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('603249040', 1, 'lacus', 'Jane Stewart', 'Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum.
Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem.', 'http://dummyimage.com/204x117.jpg/5fa2dd/ffffff', 'Philosophy and psychology');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('729474228', 1, 'est quam', 'Nicholas Stewart', 'Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat.
Praesent blandit. Nam nulla. Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede.', 'http://dummyimage.com/167x223.jpg/5fa2dd/ffffff', 'Religion');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('004876602', 1, 'vel', 'Ronald Gray', 'Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit.
Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque.', 'http://dummyimage.com/198x186.png/ff4444/ffffff', 'Social Sciences');
insert into Library (bookID, collegeID, title, author, description, image, category) values ('361417513', 1, 'nisi nam', 'Ruby Spencer', 'Aenean fermentum. Donec ut mauris eget massa tempor convallis. Nulla neque libero, convallis eget, eleifend luctus, ultricies eu, nibh.
Quisque id justo sit amet sapien dignissim vestibulum. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla dapibus dolor vel est. Donec odio justo, sollicitudin ut, suscipit a, feugiat et, eros.', 'http://dummyimage.com/212x130.png/ff4444/ffffff', 'Language');
insert into MyBooks (bookID, studentID) values ('541720477', 'x13101474');
insert into MyBooks (bookID, studentID) values ('826260812', 'x13672956');
insert into MyBooks (bookID, studentID) values ('114325639', 'x13785934');
insert into MyBooks (bookID, studentID) values ('021886458', 'x13101474');
insert into MyBooks (bookID, studentID) values ('676783042', 'x13672956');
insert into MyBooks (bookID, studentID) values ('407085073', 'x13785934');
insert into MyBooks (bookID, studentID) values ('196995201', 'x13101474');
insert into MyBooks (bookID, studentID) values ('541720477', 'x13672956');
insert into MyBooks (bookID, studentID) values ('826260812', 'x13785934');
insert into MyBooks (bookID, studentID) values ('114325639', 'x13101474');
insert into News (newsId, title, description, location, image, date, collegeID) values (1, 'new1', 'Duis consequat dui nec nisi volutpat eleifend. Donec ut dolor. Morbi vel lectus in quam fringilla rhoncus.', '76724 Rockefeller Plaza', 'http://dummyimage.com/204x186.jpg/dddddd/000000', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAJMSURBVDjLpVPPaxNBGH3ZJCQkVSEkJJja0MSCabHoSUEKerAgggRy0ZP9F4QeDAhepKeeBA8GPFQCEutdCMRSSYkimouIVqUkNW1iyJZN0mR/zvrNwtbUGjw48JiZb773vvfN7jhM08T/DNfwplgsekjwBuEWY+wMzVMEWrKPNH+j+QmhmEqlDJvjsB0QeZrWz0Kh0GwkEoHf74fP5wM/lyQJ3W4XtVoNrVarRLGb6XS6bhF5AkehUFirVqu8nDlqaJpmVioVM5/Pr9g8wbZCm5lwOPzPnqPRKKjItSN3QEFLsdlswuv1wuPxwO12W7F+vw9RFFGv15FIJKzckQIulwt7e3uQZdna67qOTqcDRVGsMx77q4Ddk9PptBzwZA7q2xJZrWYw0PaRmXwBwzj4CL/vwHbAkzmJgydy8JiiqxgPJpF5eR0aUxwjW7AJD98swGQaVKZDpf3JwBSSkQvoyvtY/XE/+HT57tjrRbF3RMCurjMVV2duwzAZDGaATrEjbePs+CX01AHe19al2QdC4JAAB6/OIZNlTq62v5JlipEbzdDQUbo4d2oOPa0vvN0qtQ8EuHX+qehPRKPRIAEZuqEjfHyCyIYltivVEBiL4MP2Bja+l1qqjvlhBwvlcvl5Mpn0x2IxDHQFK+VlugPVchMPTuNifB7vqiWsbRbbso7LO0vmJ8fwa8zlcpMkdI+QFgThBH8LvB3u7LF4xzw/MedY33y1qzDzCpG/HHpMf45sNnuMyKcJjC718yNpUTSY0zdgRvznkrll5/0CZpfQA8IRXj8AAAAASUVORK5CYII=', 1);
insert into News (newsId, title, description, location, image, date, collegeID) values (2, 'new2', 'Nullam sit amet turpis elementum ligula vehicula consequat. Morbi a ipsum. Integer a nibh.
In quis justo. Maecenas rhoncus aliquam lacus. Morbi quis tortor id nulla ultrices aliquet.', '11336 John Wall Center', 'http://dummyimage.com/155x188.bmp/ff4444/ffffff', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAG2SURBVDjLrZNJKIRhGMdHxpTtwIUoRRxdlZvcJsuFcBAHFHGSSBKlbCUZOTgolLKXskyDshwsJWQLYx+DGcaSsWS+5+95Z5jQzJjirf/hfb9+v+d5l08GQPaXyP5NkFGnDuT0cF45cBENJ9KRYKRvdg9vFgmuxujSkZDscxR2AU/8OBaJCHdPhKsHgv6eoLslnJgIh9eEfYMErcEmr+hcEJKYr4KworYZ68dLBvV3hDOGj28IBx/wzqWELb1N0NC/IgQJDgXnDJ+aPmAjYe/KBm8yvK5zLrBvQbR/xFW1Rgm7DG9fSNhgeE0nBBaroLJ7UQhiHR6ikHwdopu1M8kq/nGI3s6u0fJ5ZR3qLbtIoyrARFoQpuLlGE70oZb0QM2vD4kl2guTGV3VmVgticXzWBNoWw1zbzGWC6NRk+o/7Qpuah/fFJ08DiX50RPDUCUBZQFAbTiMjXHoUyrIGRzBOeTkirlom1aGv53NbVUwJnndrfc+wJUeO3IAhl5KZTBxTvI9Maj0IrcErVkhcwt5UdCXhcNQ7oWDXA9MJctRn+I77/Zf15wdOtOvVEii7QGuzPCsWH8HCxz5pzmy7lQAAAAASUVORK5CYII=', 1);
insert into News (newsId, title, description, location, image, date, collegeID) values (3, 'new3', 'Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum.', '45359 South Avenue', 'http://dummyimage.com/130x207.bmp/ff4444/ffffff', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAGeSURBVDjLvZPPK4NxHMe/F4dFymE8hx2YpEn+gWcHR20au4gdbCcnu3l6TqL8yO9oYSJmYbNSFsraZCSlbHJANEabaZtFYUzW29cOojzyK4f37ft6vz71/XwIAPKbkD8r4Hkeb6PX66HVaqFSqSCXyyGTycAwDLKyJchk8vGjCTTjATHNPk2MpujDCT4zl7etot8ZwYDjAuqBg6ii01v0LXMfBV27McxthMGbDsByTvvrI2rmqJmjZo6aOWrmqJnLkZY0V/Rsh7uXgim4w+bH+PI5ajs3UayzTgtaEy7C+BfztHZLzeWw3f0O1rSsoaB6wpVbaRQJwcoHN4N7jxoJXxdi8+mw2EZTcFXTCijokigNIsFfiC8T9QucvFlHMjKCRNCK0Ewa+NZuUPAVFiy4XSKauEeDp8ggnk50SEbNuNqqR2OD4ugtLFhwbSd1t9463JyZ8BgYwZ1vAmFHGbyGDNWXVjk2R4YOF0oRXShEYJLsnI4R87GR9O71EbFgAcuyszRrcpZdt7VLE6EpMhYwkcJvH1PYSsQUFv/bNT4D22mzuYC6IhwAAAAASUVORK5CYII=', 1);
insert into News (newsId, title, description, location, image, date, collegeID) values (4, 'new4', 'Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est.
Phasellus sit amet erat. Nulla tempus. Vivamus in felis eu sapien cursus vestibulum.', '35 Lien Road', 'http://dummyimage.com/187x164.jpg/5fa2dd/ffffff', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAGkSURBVDjLpZM/T8JAGMZf/gRU0lgU1EZDok5KSIwOfgKJhsGlgyaOfAE/Abo7dNfQ1W9AmNk0kjYO6ISLk4tBDJb27nzfKyWNFhLjJZeXlnue5/feXWNCCPjPSEa9bLfbpud5Z67rJrECVjmHwyHVW13XTyMNbNueR8GNqqp6Oj0HDoqAc5CMSJrNqtBsNk7w6beBZVmHJM7lcquZTAa6L69A6ZwL4IKjkQCGZo7jRLeAixuFQkH+Hgy+wEXxo/2ABnw8D8pHso1IA+oxlUpBr9fzkxmD7eKOTBejdNrwiQTkzFBEi+hgCN227rEymU7/aZXj6QT+Xgm5mAyKpV2ZHlCIiD2IhwkCA2lCyczv/U3pQv3dAB5aF9nCWDwSBun152v4/PDk80QDQgtuJYn4CJnju/PFC+ALRMfHrUYS0CkkEgk/mXEpIAOfxN/cnwTxEMFdq9WCfr8PiqLAzGwab2BMGjHh0xDhRIJqtbpvGEal0+lcapq2t76xCUv5NSkIWltZzss7Eh6xqK+xVquVUXiFsxR8TFRp4hE/maa5NdXgL+Mbb/xsAcKofWEAAAAASUVORK5CYII=', 1);
insert into News (newsId, title, description, location, image, date, collegeID) values (5, 'new5', 'Duis bibendum. Morbi non quam nec dui luctus rutrum. Nulla tellus.', '75 Dayton Pass', 'http://dummyimage.com/132x207.png/dddddd/000000', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAI5SURBVDjLpVM5q1pREJ6r1w33qLihIgoS0Z8QYhRCAjapXBqrFCn8BQ9SBixs1N+RVyqBGBvttFELxUJxRwm4gc81ZwauaNp3YJhz7p2Zb7nnctfrFV6zRPDKxQubTqfz+3w+h1nA6XSC4/F4i8PhcIuXlxfM5VQqFcE+DiWw5vdSqbRiMpmo6P91L1MikUClUoHBYBBJp9NlYsAQv+t0OpjNZiCTyW5N9424H41GoNFowO12I+gTe1zmms0moRsMBliv1w90UQo2chwHYrGY0NVqNSiVSiiVStDr9SI8oiN11IpFcrmcQkC/Z4L5crnAfr+HYDAI7Xb7iUek3W4Hi8WCDBKK0EzMwll4hmee50GlUhFLHBDG6XjAAiaJKItEogcGwiCn00l1drsde8I8oqJWDHyBgzabDcmwWCzQ7/dBoVCQvO12C1qtFubzOaxWK2JMA7ARA31AI41GI8RiMZLm8XigVqsRQDKZJCOn0ynU63UCogH4BXBAo9GgwnfhMORyOZKDLNAwbMpms5QDgQBEo1G8C8AzR0vFYvETUq9Wq4RIV5QZhQzi8Tjo9Xqij0YXCgUYj8dUw+Rc+EQi8Vm4LPl8/hvT/oNtda1W6xcz7kMmk5Hgd8eFA9k6svyH5Y+TyWTN3d82v9//1uv1/gyFQhaHw3FhLN6gYd1ul26oy+UCs9mMMv8Oh0MRu9KzhwE+n09stVqDDPHZZrOZWJMY/9jlcvmV5TEz9xl/B+bbmaEvGJMv/wD5tI7A5/InTwAAAABJRU5ErkJggg==', 1);
insert into News (newsId, title, description, location, image, date, collegeID) values (6, 'new6', 'Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat.', '9865 Becker Road', 'http://dummyimage.com/172x217.bmp/dddddd/000000', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAJ/SURBVDjLpZNLiI1xGMZ/3/edOWZojjkiudbMuEVMM4SMBVlbSUpZyAIhG4qlkcJWycZOSslCMTNFuYVpRrkzLuMy5tA4xulcv//t/Vt80ZTLxltvz7N43vd5F+8TeO/5n0r9JNLTs9A7t8FbO0WsfSvWdtdv2VIAKJ45kxWtt4rWh5xSQ6LUyeldXVcAAu890t29zzt3hPp0ljBCyiVMofhMjNkmWldE64t1U5qWTpjXiiuVqDx8RDX35ZxTalfgrl7d6K2+HC5cQBBGYAyk05jhYWrPX350WpcbWpsX17e0QGEMwgiasnzv7eX7oyfHUmLt3mjWTIJqFXJfwAlYS13zHKKV7XN9rInqG6D/AYgkBo0TyXSuId/Xvz0lxiyJMhkYegfGghdwDl68JpycgSiAwTeAgLYJ5scIWgUXx5mUGJPGOYgVKJUs0CZZMpIDaxNnEfAOlAFxYDSilKRE66K3dlpgDcQ1sC4ZtjbB8dxacBZSIYQhTqkwFKWu28FBmD0TKmWo1SCOwagEdZxgrZYYlEowv4X8jVuIUudDp9SJyodP7+NPI9C2FNJRIipXk4FqDVQM1QrUhbB2FYXRMXJXusdE667Ae0/++PFlotTZhmzjiknLlxOO5mDgCQRBcnq1Cm2L8M3zGO3p5fPte0/FmN0d/f13gp+v/Pnw4clOqQOi1P5sR1tj46wZcPceFMuwdjXFbwXen7+gRevTYsyxjoGB/K9PHF/vduxY4ZQ61dQ8d/XUDevBWfJ37jJy/eaQaL2z/f79a+P1wZ/C9Grz5ian1FHRek92zozg68s3l0Trg+19fUO/ib33f+3H69ZtetjZuf9fmuB/4/wDFoO2ZVesLdkAAAAASUVORK5CYII=', 1);
insert into News (newsId, title, description, location, image, date, collegeID) values (7, 'new7', 'Mauris enim leo, rhoncus sed, vestibulum sit amet, cursus id, turpis. Integer aliquet, massa id lobortis convallis, tortor risus dapibus augue, vel accumsan tellus nisi eu orci. Mauris lacinia sapien quis libero.
Nullam sit amet turpis elementum ligula vehicula consequat. Morbi a ipsum. Integer a nibh.', '22092 Pawling Junction', 'http://dummyimage.com/142x122.jpg/5fa2dd/ffffff', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAJ7SURBVDjLjZNPSFRRFMZ/9/2Z90anRlKzMS1UjFyoWS3U2oVQ0KIWrXJRFC7KTdRCqUWQkBt34aKN1a5FEUkRLbKFiBAoVi4kUQIbtfwz0zjjezPv3ttCwyYr+jibs7g/vu+cc8XDwbE+pcT5TFa5fsB26fzWtsC1Gbh85vA1AEtp0X76WGWp67pCCJN/yVMggxxP30xfADYAGV85juOKR29X8VgmJaaoKvtK2E4SaMXK9zCT01EKdB0Wxdw4V4VUQvyEWtkADMPEEJA1Fqgq+YoT+kzSTxHIAMtxqK6MMTtTSFGoBKXyXVkACjAMga+/EbJXSawn8aVHNggIdBrHcUj7YYrDBhqdN5gtgBDoQOHLHF7gs57zyaoAqQCRQyuJZQi0zp+qAaD1BsCllFS6EI2NryR+IBEiRDoVIRIqxzQN0GJ7BK03IkTMvXxZWCTqzlNQaOCIgLWVAhYXYsSi1ViG2LYZS/8KsHdTHm5ibnyIokgcISW2V8q+mnYibgyp1O9nseVgarkDqRRSKQ7432ip3I8CZuYXebXWjZkoxFQRbj/wyHjezhfd87de3p3osbTWCODkxmEBYNYnyKSXceffU9LaQcP0GEuZKY7UHaViVy1Dk8/E6Mf4nebO8qLNVPnGZLgIv6SGZP1ZtGnzbvIthw42Ig1JY6wNKXI017cCXLVcWyRRuWhjWTMIsYnSPwuApeQitohwqu4SANdP3GfwQz/w3LVClnj8ZGimJSt1vdZ//gOJVCI6GR9hIj5MV9sAva8v4poOgCf03179oubO8p6KqujN1obj1O5p4tPCOCPvh5mbTfb9F2AT0gtcAXYAKaB/9F686wcCdBKN9UyNSAAAAABJRU5ErkJggg==', 1);
insert into News (newsId, title, description, location, image, date, collegeID) values (8, 'new8', 'Nullam sit amet turpis elementum ligula vehicula consequat. Morbi a ipsum. Integer a nibh.
In quis justo. Maecenas rhoncus aliquam lacus. Morbi quis tortor id nulla ultrices aliquet.', '4 Grasskamp Plaza', 'http://dummyimage.com/181x232.png/5fa2dd/ffffff', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAJlSURBVDjLpZNNSJRhEMd/z7u6666b6VaQFoohgYpYFHoKo2+SDnbo4smOHQUvfVy6CoHHTkUQHYLCgyAEK32AUUSHCqKMxYIs3ErXV3ff93memQ7FJhkdak7DMPPjz8z8jaryP1Hze8HNmKwqoyqcEKFPFVR4IsK0Clc2ndJwfb9Zr8DNmAEVrpnWsXbT2Icmc6AeLRfx354TvR0viDDSNKT3NwBc3gxp48CdYPswmtmMX3uNRF9QVwFTR1DXgbEB0fvbRJ/vn952Ru9WATZvcqrMJ3puZSUo4SsFsCuIi1Bf+QERxaRaSaR6WJ49G4rQ1jysXwMAFUaDtgtZTYJEBXCr5CeLIDH4mAf3QGyIK73AR+/IdF7IimcUIAAQYdA09SOVAurKqFgOnkyjYlFvOTAQohKhNsQtPaOmcTfiGVwP6CLVgLil6pCKRV2M+vhnblEfI1ERiPCe9uoZVSirqyTxDnxMuFzixdM5St9CEEd9xtDd3UAm5VECUEWExC8FngK2DCQJl1eYzb+iZUeWw8d3cehYG80taR4/WiBcKWOCDOJrsBFzVQUiTNni8z1BYyvp2rf0D3RSX1tGfAX1ETtbkuSae0n7j9Q09FIuzmNjptYrmFh7dTnEbSKR7SSbBpUIfFzdR9p/JFHfgaZ6WXh4ObQRE1VA02ldFGFkbe4G6A4SDf2YRA4VBVGC5FZqtx1BM4f48nISGzOy97wubnjlhZvmqHiu1neNtSe3dBPUBiAOF3lWF97waXa84Czn9l3U6T96AeDDdZMVz5gIJ7ynz8XgLE+cZdpZxvdf+ouZ/iW+AxEldjf3XZxpAAAAAElFTkSuQmCC', 1);
insert into News (newsId, title, description, location, image, date, collegeID) values (9, 'new9', 'Duis bibendum, felis sed interdum venenatis, turpis enim blandit mi, in porttitor pede justo eu massa. Donec dapibus. Duis at velit eu est congue elementum.', '0 Holy Cross Circle', 'http://dummyimage.com/246x115.bmp/cc0000/ffffff', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAJlSURBVDjLpZNrSJNRGMdlr7qat+zKaoYhjqYphRCWCtKFoCj60CeRpDB0djHUSMOZm0JhGEmlNhczXXunDgy7TNcVcsjGpk6dNsiJyyjWNg3ZnJfef69vMBBkFn34wXMu/995DocTBCDof1h1cvBJnM5RTsBVyYLzBgvfigjopbGDfyUwK+Nfu2RsTNcTDO5aAk4RC1/KQ2BqjetbU+AiOZip/xNyLndQSeCHmMBUIQFzTjDWFDiu0O0qzmJKU4OvPSmYuETAXhKM8WshsOYR0NZlRAUUtOXt+Dk99hYufSu+6x7D8fEAnLozmLEq0V3M8ww1F4QGFEhz+Aa3QQmHsQPeQZJGxdRuEwnp+SRjwCs0FpwIf3guwfayKBE+owxzI50M3oGn0JbuQW323vE7uac2rSpoFB6Pll/M0FjEofDZe2Go2ocu0VGG5dpjUWOEXpPlp72X5h/irhBIcrNYNunp5s+31gFTWmCsAfiQDWiOgXq2H1Q7H1TPSVCfmjBaHY4HFzJfNOQd5vgFZGHmo5n7bEBfQlPMBNGVCqgTQZGxWGjhwivbCKorHb/UybDf5UFekE76Bf3lu5ccz0uxpIgBOvgMlGoXPeZhvnkbHY7GbEMYnHVseKQb4OquQF+JYMEvMIsElFsroTfQL/TqCBYVOzHfsh0++RZ4mqIxJ98Kj2wzc7qtJhLTb6pguJ5A+QXDLZfLTGXxi45762G7TUs6BKtirWZjWByG/opkH52pWvEKEyphRK8oLan9aurkgCSGslRHYVTCwQjNkDgSpptcqrMwafZd2cGUyTZhRMDf+C/8Blefvm4GxFC9AAAAAElFTkSuQmCC', 1);
insert into News (newsId, title, description, location, image, date, collegeID) values (10, 'new10', 'In hac habitasse platea dictumst. Etiam faucibus cursus urna. Ut tellus.', '5 Anderson Junction', 'http://dummyimage.com/199x125.bmp/5fa2dd/ffffff', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAJoSURBVDjLhZJZTxNhFIbnRq/9E/4Rf4JRE+PChV4YYjQxLglRQkgDWhGXRo2VNJWu0IWh0hY6iEvpjl1AWuoImqFCO6V0uqRrzOt8H0mxBvQkTyYnOfOcd775mPn5+WMcx12dm5v74Ha7806ns+JwOOIsyyptNttxAMy/YDwejz6ZTKJQKKDZbKLdbkOSJKTTaVgslrX/CmZnZwu1Wg3VarUjID3BbDZD5d7GE+cWRhwZ3J8SoLD+wMDEOu4ZvqFP9zXMuFyuXLlcphszmQwEQUAwGESpVILBYEC13j6Um9pUg5mZmck2Gg3wPI9isYh4PE4hNT4+DlXkIUZDw3jgH4TC24+Bj324u3CbCq6//gJmenqaClZXV6kgEolQSGk0GhxWRND7MgHGbrdTQSKRwM7ODnw+H/x+Px1Sq9UwenMHQgSXVVEwVqtVarVaSKVS9PvD4TBisRgVqFSqzkZrINuVIF+qo+dxBMyEXCSyKIr095EDJUmI6OlzNeyhHFgZIiBPNpiFcymLje0yziqDYIxG41GdTtc7pp/CpMWCMa0eJpMJYyYXKpXKoQn4nyWcHvLvXQatVntEaV0Dv7GJCW4Ztk882MAm3i6JFHdUpAKaQk5gl1kTJJwaWty/UYOT31GsNOkwKS6e79roiYko19qdngh6HgX3Bf3mdSrwyC9yf/EukYfzs9gFEZxX+vcFffo0dmXBwvLe5vcr3QlsAbGrpwlG/hDcepNCodyAKNWxVahBEKvySVfAZ0p0+CAuKH2/OoIbmuTitVcr1SsvErj0LIqLoxGcU4ZwZjiAkwrvgZy4w7G/AXhUV4qmXai6AAAAAElFTkSuQmCC', 1);
INSERT INTO support (`supportName`, `desc`, `contactNum`, `location`, `collegeID`) VALUES ('College Office', 'tuition', '+353 1548945', 'NCI 1st Floor', 1);
INSERT INTO support (`supportName`, `desc`, `contactNum`, `location`, `collegeID`) VALUES ('International Students1', 'Contact the lecturer of business.', '+353 1672354', 'NCI 1st Floor', 1);
INSERT INTO support (`supportName`, `desc`, `contactNum`, `location`, `collegeID`) VALUES ('College Office2', 'Tuition fees cover the cost of your study and include charges for registration', '+353 1654983', 'NCI 3rd Floor', 1);
INSERT INTO support (`supportName`, `desc`, `contactNum`, `location`, `collegeID`) VALUES ('School of Business', 'Get help of study.', '+353 1648524', 'NCI 3rd Floor', 1);
INSERT INTO support (`supportName`, `desc`, `contactNum`, `location`, `collegeID`) VALUES ('College Office3', 'supervision', '+353 1648524', 'NCI 1st Floor', 1);
INSERT INTO support (`supportName`, `desc`, `contactNum`, `location`, `collegeID`) VALUES ('International Students2', 'The Computing Support Service provides additional support to computing students experiencing difficulties in technical computing modules.', '+353 1672354', 'NCI1st Floor', 1);
INSERT INTO support (`supportName`, `desc`, `contactNum`, `location`, `collegeID`) VALUES ('Fees Office', 'examinations and graduation.', '+353 1648524', 'NCI 1st Floor', 1);