-
Notifications
You must be signed in to change notification settings - Fork 0
/
spms.sql
1736 lines (1562 loc) · 61.8 KB
/
spms.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
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 04, 2023 at 08:20 PM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 8.0.25
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `spms`
--
-- --------------------------------------------------------
--
-- Table structure for table `answer_t`
--
CREATE TABLE `answer_t` (
`answerID` int(11) NOT NULL,
`answerDetails` mediumtext NOT NULL,
`answerNum` int(11) NOT NULL,
`markObtained` int(11) DEFAULT NULL,
`registrationID` int(11) NOT NULL,
`questionID` int(11) NOT NULL,
`examID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `answer_t`
--
INSERT INTO `answer_t` (`answerID`, `answerDetails`, `answerNum`, `markObtained`, `registrationID`, `questionID`, `examID`) VALUES
(100, 'aaa', 1, 6, 10, 0, 11),
(101, 'bbb', 2, 7, 10, 0, 11),
(102, 'ccc', 3, 8, 10, 0, 11),
(103, 'ami ayon', 1, 9, 19, 0, 11),
(104, 'ami ayon', 2, 9, 19, 0, 11),
(105, 'ami ayon', 3, 9, 19, 0, 11),
(106, 'EEE131', 1, 10, 1, 0, 12),
(107, 'Electronics 1', 2, 7, 1, 0, 12),
(108, 'xdxdxbxfb', 1, 6, 24, 0, 12),
(109, 'gdjdhd', 2, 7, 24, 0, 12),
(110, 'dcdcdcd', 1, 9, 20, 0, 13),
(111, 'tyybn', 1, 9, 25, 0, 15),
(112, 'kumh ', 2, 7, 25, 0, 15),
(113, 'hgf', 3, 8, 25, 0, 15),
(114, 'dfghj', 4, 6, 25, 0, 15),
(115, 'fgbfbg', 1, 6, 7, 0, 14),
(116, 'tntn', 2, 10, 7, 0, 14),
(117, 'kkj', 3, 7, 7, 0, 14),
(118, 'h k', 4, 7, 7, 0, 14),
(119, 'brbnfn', 1, 6, 25, 0, 16),
(120, 'rnrnr', 2, 6, 25, 0, 16),
(121, '', 0, 80, 47, 95, 0),
(122, '', 0, 45, 48, 96, 0),
(123, '', 0, 0, 49, 97, 0),
(124, '', 0, 85, 50, 98, 0),
(125, '', 0, 80, 51, 99, 0),
(126, '', 0, 80, 51, 100, 0),
(127, '', 0, 90, 53, 101, 0),
(130, '', 0, 45, 54, 102, 0),
(131, '', 0, 90, 57, 53, 0),
(132, '', 0, 80, 58, 54, 0),
(133, '', 0, 85, 59, 55, 0),
(134, '', 0, 80, 60, 105, 0),
(135, '', 0, 85, 61, 106, 0),
(136, '', 0, 85, 61, 107, 0),
(137, '', 0, 85, 61, 108, 0),
(138, '', 0, 90, 64, 109, 0),
(139, '', 0, 0, 65, 110, 0),
(140, '', 0, 65, 66, 111, 0),
(141, '', 0, 65, 66, 112, 0),
(142, '', 0, 45, 68, 113, 0),
(143, '', 0, 80, 69, 114, 0),
(144, '', 0, 80, 69, 115, 0),
(145, '', 0, 80, 69, 116, 0),
(146, '', 0, 80, 69, 117, 0),
(147, '', 0, 80, 69, 118, 0),
(148, '', 0, 80, 69, 119, 0),
(149, '', 0, 80, 69, 120, 0),
(150, '', 0, 65, 76, 121, 0),
(151, '', 0, 50, 77, 122, 0),
(152, '', 0, 45, 78, 123, 0),
(153, '', 0, 45, 78, 124, 0),
(154, '', 1, 85, 89, 125, 15),
(155, '', 4, 65, 90, 126, 14),
(156, '', 2, 80, 91, 127, 11),
(157, '', 2, 65, 92, 128, 10),
(158, '', 3, 65, 93, 129, 10),
(159, '', 2, 65, 97, 130, 12),
(160, '', 1, 80, 99, 132, 13),
(161, '', 4, 85, 100, 133, 13),
(162, '', 1, 65, 101, 134, 14),
(163, '', 1, 75, 102, 135, 11),
(164, '', 3, 80, 103, 136, 14),
(165, '', 3, 80, 103, 137, 16),
(166, '', 2, 45, 105, 138, 16),
(167, '', 4, 45, 105, 139, 13),
(168, '', 4, 85, 107, 140, 15),
(169, '', 3, 65, 108, 141, 15),
(170, '', 4, 43, 109, 142, 11),
(171, '', 2, 80, 110, 143, 12),
(172, '', 1, 85, 111, 144, 14),
(173, '', 1, 80, 112, 145, 16),
(174, '', 1, 85, 113, 146, 15),
(175, '', 4, 80, 114, 147, 13),
(176, '', 3, 65, 115, 148, 12);
-- --------------------------------------------------------
--
-- Table structure for table `backlog_data`
--
CREATE TABLE `backlog_data` (
`studentID` int(8) NOT NULL,
`sectionNum` int(5) DEFAULT NULL,
`semester` varchar(8) DEFAULT NULL,
`courseID` varchar(7) DEFAULT NULL,
`year` int(6) DEFAULT NULL,
`obtainGrade` varchar(1) DEFAULT NULL,
`f_employeeID` int(6) DEFAULT NULL,
`timeStamp` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `backlog_data`
--
INSERT INTO `backlog_data` (`studentID`, `sectionNum`, `semester`, `courseID`, `year`, `obtainGrade`, `f_employeeID`, `timeStamp`) VALUES
(26, 13, 'autmn', 'eee131', 2011, 'C', 1531176, '2023-04-25 17:11:34'),
(87, 2, 'summer', 'csc303', 2011, 'A', 2259, '2023-04-25 17:24:07'),
(8902, 13, 'autmn', 'EEE131', 2015, 'A', 8902, '2023-04-27 09:01:39'),
(89011, 13, 'autmn', 'csc303', 2018, 'A', 2035363, '2023-04-27 03:53:00'),
(303030, 3, 'summer', 'CSC401', 2018, 'B', 2035363, '2023-04-27 02:32:30'),
(404040, 2, 'autmn', 'eee131', 2012, 'D', 2035363, '2023-04-27 02:40:38'),
(515151, 3, 'spring', 'EEE131', 2015, 'F', 89011, '2023-04-27 06:17:52'),
(787878, 13, 'summer', 'csc303', 2018, 'B', 89011, '2023-04-27 09:53:40'),
(2031363, 2, 'spring', 'csc101', 2011, 'B', 2259, '2023-04-25 17:14:43'),
(2037453, 2, 'summer', 'mis442', 2012, 'A', 2259, '2023-04-25 18:09:42');
-- --------------------------------------------------------
--
-- Table structure for table `clo_matrix_t`
--
CREATE TABLE `clo_matrix_t` (
`clo_MatID` int(11) NOT NULL,
`cloNum` int(11) NOT NULL,
`coDescription` mediumtext NOT NULL,
`ploAssessed` varchar(10) NOT NULL,
`correlation` int(11) NOT NULL,
`courseOutlineID` int(11) NOT NULL,
`c` int(11) DEFAULT NULL,
`p` int(11) DEFAULT NULL,
`a` int(11) DEFAULT NULL,
`s` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `clo_matrix_t`
--
INSERT INTO `clo_matrix_t` (`clo_MatID`, `cloNum`, `coDescription`, `ploAssessed`, `correlation`, `courseOutlineID`, `c`, `p`, `a`, `s`) VALUES
(3, 1, 'Understand the database applications starting from conceptual design using data models diagram (ERD), Process Model diagram (BPMN)', 'PLO-b', 3, 4, 0, 4, 0, 0),
(4, 2, 'Basic understanding of data access structures and comparison between those structures, Determine the normalization form of Database.', 'PLO-c', 3, 4, 5, 0, 0, 0),
(5, 3, 'Ability to analyze the ERD, Process diagram and normalization concept.', 'PLO-d', 3, 4, 0, 6, 0, 6),
(6, 1, 'sdfgh', 'plo-a', 3, 11, 2, 0, 5, 0),
(7, 1, 'Understand the database applications starting from conceptual design using data models diagram (ERD), Process Model diagram (BPMN)', 'PLO-b', 3, 12, 0, 4, 0, 0),
(8, 1, 'Understand the database applications starting from conceptual design using data models diagram (ERD), Process Model diagram (BPMN)', 'PLO-b', 3, 13, 0, 4, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `course_outline_t`
--
CREATE TABLE `course_outline_t` (
`courseOutlineID` int(11) NOT NULL,
`sectionID` int(11) NOT NULL,
`semester` varchar(30) NOT NULL,
`courseDescription` mediumtext NOT NULL,
`objective` mediumtext NOT NULL,
`content` mediumtext NOT NULL,
`refMaterials` mediumtext NOT NULL,
`sectionNum` int(11) NOT NULL,
`courseTitle` varchar(1000) NOT NULL,
`prerequisiteCode` varchar(6) DEFAULT NULL,
`creditValue` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `course_outline_t`
--
INSERT INTO `course_outline_t` (`courseOutlineID`, `sectionID`, `semester`, `courseDescription`, `objective`, `content`, `refMaterials`, `sectionNum`, `courseTitle`, `prerequisiteCode`, `creditValue`) VALUES
(4, 10, 'spring, 2021', 'Conventional and database approaches. Basic concepts of DBMS. Hierarchical, network and relational data\r\nmodels. \r\nEntity-relationship modeling. Relational database designing: decomposition and normalization;\r\nfunctional dependencies. \r\nRelational algebra and calculus. Structured query language (SQL). \r\nQuery optimization. \r\nDatabase programming with SQL and PL/SQL. \r\nDatabase security and administration. Distributed databases.\r\nObject-oriented data modeling.\r\nSpecific database systems: oracle, MS SQL server, access.', 'In this course, students will get an overview of the following:\r\n\r\n1. Introduce the concept of database and its usages.\r\n\r\n2. Introduce the life cycle of a systems development project.\r\n\r\n3. Introduction to ER Diagram and database model designing.\r\n\r\n4. Introduce the ERD and Relation mapping.\r\n\r\n5. Understanding the Normalization Technique to optimize the database model.\r\n\r\n6. Introduction to SQL and Advanced SQL.\r\n\r\n7. Introduction to Physical system design: Input forms, Output reports and Architecture.\r\n\r\n8. Basic concepts of database administration.', 'Introduction: Concept of Database, DBMS:\r\n1. Students will be able to know each other\r\n2. Students will learn about the course policy\r\n3. Students will be able to plan for the exams\r\n4. Student will learn basic concept of Database.\r\n5. Students will learn about the reason of using database.\r\n6. Students will learn about different categories of applications that use databases.\r\nIntroduction: Database Development process, Database architecture; Database languages and Interfaces:\r\n1. Students will learn about the life cycle of a systems development project.\r\n2. Students will learn about the roles of individuals who design, implement, use, and administer\r\nDatabases.\r\n3. Students will learn about the differences among external, conceptual, and internal schema.\r\nAnalysis: Rich Picture:\r\n1. Introduction to real-time problem.\r\n2. Introduction to understand a real-time issue and draw that using Rich Picture.\r\nAnalysis: Six Elements Analysis:\r\n1. Understand the concept of Six elements Analysis.\r\n2. Perform six elements analysis to map the existing system.\r\nAnalysis: Process Diagram using BPMN 2.0:\r\n1. Identification of details of the processes involved in the system.\r\n2. Introduction to the business process diagram\r\n3. Introduction to BPMN 2.0.\r\n4. Perform process drawing using BMPN 2.0\r\nAnalysis: Process Diagram and Improvement Process:\r\n1. Students will be introduced to advanced features of BPMN 2.0.\r\n2. Students will be introduced to BPR and KPI to find the issues and perform analysis\r\nEntity Relationship Diagram Model:\r\n1. Students will learn about entities, relationships, and attributes.\r\n2. Students will be able to learn about degree of relationship.\r\n3. Students will be able to model E-R diagram considering different types of attributes, entities,\r\nrelationship, and cardinality constraints.\r\n4. Students will be able to differentiate different relationship types.\r\n5. Student will be able to identify the reason of different types of attributes.\r\n6. Students will be able to realize the need of relationship constrains.\r\nDesign: Enhanced ERD Model:\r\n1. Student will learn about subtype super-type relation.\r\n2. Student will learn completeness and disjoint type relations.\r\nDesign: ERD to Relations:\r\n1. Students will learn to convert the entity to relations.\r\n2. Students will learn to map attribute in the relations.\r\n3. Students will be able to design the relationship in terms of relations.\r\nDesign: Normalization 01:\r\n1. Students will be able to list five properties of relations.\r\n2. Students will be able to state two essential properties of a candidate key.\r\n3. Student will be introduced with the concept of normalization: first normal form, second normal\r\nform, and third normal form.\r\n4. Students will learn briefly about four problems that may arise when merging relations.\r\nDesign: Normalization 02, Data Dictionary:\r\n1. Students will be able to realize the need of normalization.\r\n2. Students will be able to perform normalization on any case study.\r\n3. Students will learn about Boyce-Codd normal form.\r\n4. Students will learn the physical database design process, its objectives, and its deliverables.\r\n5. Students will learn about storage formats for attributes from a logical data model.\r\n6. Students will learn how to select an appropriate file organization by balancing various important\r\ndesign factors.\r\n7. Students will be able to translate a relational data model into efficient database structures,\r\nincluding knowing when and how to de-normalize the logical data model.\r\nRelational Algebra:\r\n1. Students will learn about the formal notations.\r\n2. Students will learn how to add constraints to the set union, set intersections. Set difference and\r\nCartesian products.\r\n3. Students will learn how to implement and use them in database.\r\nSQL: DDL, DML, DCL:\r\n1. Students will learn to interpret the history and role of SQL in database development.\r\n2. Students will know how to define and use the data types and constrains in the database using DML.\r\nSQL: Retrieve Information:\r\n1. Students will learn how to fetch the data from the database using basic SQL command.\r\n2. Students will learn how to retrieve and manipulate that information from the database using SQL.\r\n3. Students will learn how to retrieve and manipulate that information from the database using SQL.\r\nAdvance SQL:\r\n1. Students will learn how to use union, join etc. using SQL.\r\n2. Students will be able to establish referential integrity using SQL.\r\n3. Students will learn how to use union, join etc. using SQL.\r\n4. Students will be able to establish referential integrity using SQL.\r\n5. Students will learn how to write sub-queries using SQL query.\r\n6. Students will learn how to establish referential integrity using SQL.\r\n7. Students will practice how to write sub-queries using SQL query.\r\n8. Students will practice how to establish referential integrity using SQL.\r\nInput Form and Output Reports Database Architecture, Database Administrations:\r\n1. Students will be able to explain the three components of client/server systems: data presentation\r\nservices, processing services, and storage services.\r\n2. Students will be able to distinguish between two-tier and three-tier architectures.\r\n3. Students will be able to describe the key components of a web application and the information flow\r\nbetween the various components.\r\n4. Students will learn why organizations needs data administration for.\r\n5. Students will be able to describe the three levels of data warehouse architecture from database\r\nadministrator point of view.\r\n6. Students will be able to develop the requirement for a data bank.', 'The course will be based mostly on the following books [some other books and journals may be\r\nreferred time to time]:\r\n1. Modern Database Management by Jeffrey A. Hoffer, Mary B. Prescott, Fred R. Mcfadden\r\n2. Database Management Systems, by Raghu Ramakrishnan and Johannes Gehrke\r\n3. Fundamentals of Database Systems, By RamezElmasri, Shamkant B. Navathe\r\n4. Microsoft MSDN, W3 School\r\n5. An Introduction to Database System by C. J. Date', 1, 'Introduction to programming', '', 3),
(11, 16, 'summer,2021', 'This course is prepared for the students (Major in MIS) with an introduction to trending technology, for instance,\r\nInternet of Things (IoT), Artificial Intelligence (AI), BlockChain, Fintech, Big Data and Business Intelligence (BI)\r\nas well as business problem solving orientation through various techniques. These usage in an increasingly\r\ncompetitive business world is really required. As a future manager/leader, one needs to be equipped with this\r\ntrending issues to make decisions concerning the planning, development and implementation of information\r\ntechnology resources to increase organizational effectiveness and create a strategic advantage.', 'This course is prepared for the students (Major in MIS) with an introduction to trending technology, for instance,\r\nInternet of Things (IoT), Artificial Intelligence (AI), BlockChain, Fintech, Big Data and Business Intelligence (BI)\r\nas well as business problem solving orientation through various techniques. These usage in an increasingly\r\ncompetitive business world is really required. As a future manager/leader, one needs to be equipped with this\r\ntrending issues to make decisions concerning the planning, development and implementation of information\r\ntechnology resources to increase organizational effectiveness and create a strategic advantage.', 'Upon completion of BBA in Management Information Systems (MIS) program, the individual should be able to:\r\n\r\nPLO1: Explain theories, knowledge, technologies and concepts related to Business and Management.\r\nPLO2: Apply relevant & sustainable computer applications, tools, techniques and skills required for decision\r\nmaking in different functions of management.\r\nPLO3: Analyze plans and requirements for implementing computer-based information systems and use\r\ntechnologies to solve business problems.\r\nPLO4: Apply interpersonal skills & communicate skillfully to work effectively in groups or individually to\r\nperform required tasks in a work environment.\r\nPLO5: Identify ethical considerations in relation to Business and Management.\r\nPLO6: Develop entrepreneurial and employability skills that can be applied in a work environment.\r\nPL07: Recognize the need for lifelong learning to acquire & to be skillful on emerging technologies as it evolves.\r\n\r\nCOURSE LEARNING OUTCOME (CLO):\r\n\r\nUpon completion of this course, individual should be able to: -\r\nCLO1: Identify and explain theories, knowledge, technologies and concepts related to IoT, Big Data, Machine\r\nlearning, Fin-tech etc.\r\nCLO2: Assess if the organizations are well prepared for implementing IoT, Block-Chain and integrate system into\r\na single hub.\r\nCLO3: Execute model-based simulation program to solve business problems/generate best possible solutions to\r\nthe business problem.\r\nCLO4: Identify ethical considerations and evaluate if data can be used for decision making or publicized to all\r\nstakeholders.\r\nCLO5: Measure the pre-performance analysis of given scenario from technical aspects.', 'Articles online.', 1, 'Computers in Business', '', 3),
(12, 13, 'spring,2021', 'aaaaaaaaaaaaaaaaa', 'bbbbbbbbbbbbbbbbb', 'bla bla bla', 'nai', 3, 'English Learning Skills', '', 3),
(13, 15, 'autumn,2021', 'Conventional and database approaches. Basic concepts of DBMS. Hierarchical, network and relational data models. Entity-relationship modeling. Relational database designing: decomposition and normalization; functional dependencies. Relational algebra and calculus. Structured query language (SQL). Query optimization. Database programming with SQL and PL/SQL. Database security and administration. Distributed databases. Object-oriented data modeling. Specific database systems: oracle, MS SQL server, access.\r\n', 'In this course, students will get an overview of the following:\r\n\r\nIntroduce the concept of database and its usages.\r\nIntroduce the life cycle of a systems development project.\r\nIntroduction to ER Diagram and database model designing. \r\nIntroduce the ERD and Relation mapping.\r\nUnderstanding the Normalization Technique to optimize the database model.\r\nIntroduction to SQL and Advanced SQL.\r\nIntroduction to Physical system design: Input forms, Output reports and Architecture. \r\nBasic concepts of database administration.\r\n\r\n', 'blah', 'gbrbr', 1, 'Introduction to programming', '', 3),
(14, 0, 'spring', 'this is cmn course . one of the interesting course at IUB', 'OBjective to learn media and communication.', 'content is very short', 'asdfasf', 1, 'mis442', '', 3);
-- --------------------------------------------------------
--
-- Table structure for table `course_t`
--
CREATE TABLE `course_t` (
`courseID` varchar(6) NOT NULL,
`courseName` varchar(40) NOT NULL,
`numOfCredits` int(11) NOT NULL,
`courseType` varchar(10) NOT NULL,
`programID` int(11) NOT NULL,
`preReqID` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `course_t`
--
INSERT INTO `course_t` (`courseID`, `courseName`, `numOfCredits`, `courseType`, `programID`, `preReqID`) VALUES
('CSC101', 'Introduction to Computer Science', 3, 'foundation', 13, NULL),
('EEE131', 'Electrical Circuit-I', 3, 'core', 9, NULL),
('EEE231', 'Signals & Systems', 3, 'core', 9, NULL),
('EEE233', 'Energy Conversion-I', 3, 'core', 9, NULL),
('ENG101', 'English Listening & Speaking Skills', 3, 'foundation', 20, NULL),
('MKT101', 'Introduction to Marketing', 3, 'core', 8, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `co_t`
--
CREATE TABLE `co_t` (
`coID` int(11) NOT NULL,
`coNum` int(11) DEFAULT NULL,
`courseID` varchar(8) NOT NULL,
`ploID` varchar(5) NOT NULL,
`poID` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `co_t`
--
INSERT INTO `co_t` (`coID`, `coNum`, `courseID`, `ploID`, `poID`) VALUES
(1, 1, 'CSC101', '43', '43'),
(2, 1, 'CSC101', '44', '44'),
(3, 1, 'CSC101', '45', '45'),
(4, 2, 'CSC101', '43', '43'),
(5, 1, 'EEE131', '22', '22'),
(6, 2, 'EEE131', '22', '22'),
(7, 3, 'EEE131', '23', '23'),
(8, 4, 'EEE131', '22', '22'),
(31, 5, 'CSC101', '58', '58'),
(32, 1, 'CSC101', '61', '61'),
(33, 5, 'CSC101', '62', '62'),
(34, 6, 'CSC101', '62', '62'),
(35, 2, 'CSC101', '45', '45'),
(36, 2, 'CSC101', '47', '47'),
(37, 2, 'CSC101', '49', '49'),
(38, 3, 'CSC101', '45', '45'),
(39, 3, 'CSC101', '46', '46'),
(40, 3, 'CSC101', '49', '49'),
(41, 4, 'CSC101', '44', '44'),
(42, 4, 'CSC101', '45', '45'),
(43, 4, 'CSC101', '46', '46'),
(44, 6, 'CSC101', '44', '44'),
(45, 6, 'CSC101', '45', '45'),
(46, 6, 'CSC101', '47', '47'),
(47, 6, 'CSC101', '48', '48'),
(48, 5, 'CSC101', '48', '48'),
(49, 1, 'EEE131', '23', '23'),
(50, 1, 'EEE131', '24', '24'),
(51, 1, 'EEE131', '28', '28'),
(52, 1, 'EEE131', '64', '64'),
(53, 3, 'EEE131', '25', '25'),
(54, 3, 'EEE131', '24', '24'),
(55, 3, 'EEE131', '28', '28'),
(56, 3, 'EEE131', '26', '26'),
(57, 3, 'EEE131', '27', '27'),
(58, 3, 'EEE131', '63', '63'),
(59, 3, 'EEE131', '65', '65'),
(60, 4, 'EEE131', '23', '23'),
(61, 5, 'EEE131', '23', '23'),
(62, 5, 'EEE131', '24', '24'),
(63, 5, 'EEE131', '25', '25'),
(64, 6, 'EEE131', '23', '23'),
(65, 6, 'EEE131', '24', '24'),
(66, 6, 'EEE131', '25', '25'),
(67, 7, 'EEE131', '22', '22'),
(68, 1, 'ENG101', '50', '50'),
(69, 3, 'ENG101', '50', '50'),
(70, 5, 'ENG101', '50', '50'),
(71, 6, 'ENG101', '50', '50'),
(72, 1, 'ENG101', '52', '52'),
(73, 2, 'ENG101', '52', '52'),
(74, 1, 'ENG101', '53', '53'),
(75, 1, 'ENG101', '54', '54'),
(76, 2, 'ENG101', '54', '54'),
(77, 3, 'ENG101', '54', '54'),
(78, 4, 'ENG101', '54', '54'),
(79, 1, 'ENG101', '55', '55'),
(80, 3, 'ENG101', '55', '55'),
(81, 5, 'ENG101', '55', '55'),
(82, 1, 'ENG101', '56', '56'),
(83, 3, 'ENG101', '56', '56'),
(84, 6, 'ENG101', '56', '56'),
(85, 4, 'ENG101', '68', '68'),
(86, 6, 'ENG101', '68', '68'),
(87, 4, 'ENG101', '69', '69'),
(88, 1, '', '', ''),
(89, 2, '', '', ''),
(90, 3, '', '', ''),
(91, 1, ' csc101', '72', '72'),
(92, 1, ' csc101', '73', '73'),
(93, 2, ' csc401', '74', '74'),
(94, 3, ' csc401', '75', '75'),
(95, 4, ' csc401', '76', '76'),
(96, 1, ' csc303', '77', '77'),
(97, 2, ' csc303', '78', '78'),
(98, 3, ' csc303', '79', '79'),
(99, 4, ' csc303', '80', '80'),
(100, 1, ' csc303', '81', '81'),
(101, 2, ' csc303', '82', '82'),
(102, 3, ' csc303', '83', '83'),
(103, 1, ' eee131', '84', '84'),
(104, 1, ' eee131', '', ''),
(105, 1, ' mis442', '', ''),
(106, 1, ' mis442', '', ''),
(107, 1, ' CSC303', '85', '85'),
(108, 1, ' mis442', '86', '86'),
(109, 1, ' EEE131', '87', '87'),
(110, 2, ' CSC101', '88', '88'),
(111, 3, ' csc401', '89', '89'),
(112, 3, ' eee131', '90', '90'),
(113, 3, ' EEE131', '', ''),
(114, 3, ' EEE131', '', ''),
(115, 3, ' CSC401', '93', '93'),
(116, 1, ' CSC101', '94', '94'),
(117, 1, ' CSC401', '95', '95'),
(118, 1, ' CSC401', '96', '96'),
(119, 4, ' eee131', '97', '97'),
(120, 4, ' eee131', '98', '98'),
(121, 4, ' csc303', '99', '99'),
(122, 3, ' mis442', '100', '100'),
(123, 3, ' EEE131', '101', '101'),
(124, 4, ' csc101', '102', '102'),
(125, 3, ' EEE131', '103', '103'),
(126, 4, ' csc303', '104', '104'),
(127, 3, ' CSC401', '105', '105'),
(128, 2, ' CSC101', '106', '106'),
(129, 3, ' mis442', '107', '107');
-- --------------------------------------------------------
--
-- Table structure for table `dean_t`
--
CREATE TABLE `dean_t` (
`d_employeeID` int(11) NOT NULL,
`schoolID` varchar(5) NOT NULL,
`startDate` date NOT NULL,
`endDate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `departmenthead_t`
--
CREATE TABLE `departmenthead_t` (
`h_employeeID` int(11) NOT NULL,
`departmentID` varchar(3) NOT NULL,
`startDate` date NOT NULL,
`endDate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `department_t`
--
CREATE TABLE `department_t` (
`departmentID` varchar(3) NOT NULL,
`departmentName` varchar(50) NOT NULL,
`schoolID` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `department_t`
--
INSERT INTO `department_t` (`departmentID`, `departmentName`, `schoolID`) VALUES
('ACN', 'Accounting', 'SBE'),
('CSE', 'Computer Science & Engineering', 'SETS'),
('ECO', 'Economics', 'SBE'),
('EEE', 'Electrical & Electronic Engineering', 'SETS'),
('ESM', 'Environmental Science & Management', 'SELS'),
('FIN', 'Finance', 'SBE'),
('GSG', 'Global Studies & Governance', 'SLASS'),
('HRM', 'Human Resource Management', 'SBE'),
('LAW', 'Law', 'SLASS'),
('LS', 'Life Sciences', 'SELS'),
('MC', 'Media and Communication', 'SLASS'),
('MGT', 'General Management', 'SBE'),
('MIS', 'Management Information Systems', 'SBE'),
('MKT', 'Marketing', 'SBE'),
('PH', 'Public Health', 'SPPH'),
('PHA', 'Pharmacy', 'SPPH'),
('PS', 'Physical Sciences', 'SETS'),
('SSH', 'Social Sciences and Humanities', 'SLASS');
-- --------------------------------------------------------
--
-- Table structure for table `employee_t`
--
CREATE TABLE `employee_t` (
`employeeID` int(11) NOT NULL,
`password` varchar(10) NOT NULL,
`firstName` varchar(50) NOT NULL,
`lastName` varchar(50) NOT NULL,
`email` varchar(30) DEFAULT NULL,
`phone` int(11) DEFAULT NULL,
`gender` varchar(10) DEFAULT NULL,
`designation` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `employee_t`
--
INSERT INTO `employee_t` (`employeeID`, `password`, `firstName`, `lastName`, `email`, `phone`, `gender`, `designation`) VALUES
(2258, '12345', 'Mainuddin', 'Chowdhury', '[email protected]', 88017548, 'male', 'professor'),
(2344, '12345', 'Nadira Sultana', 'Mirza', '[email protected]', 88018548, 'female', 'senior lecturer'),
(2483, '12345', 'Kazi Mubinul Hasan', 'Shanto', '[email protected]', 88017486, 'male', 'professor'),
(2518, '12345', 'Mubash-Shera Karishma', 'Mobarok', '[email protected]', 88017594, 'female', 'lecturer'),
(3251, '12345', 'Farzana', 'Chowdhury', '[email protected]', 88013562, 'female', 'senior lecturer'),
(3329, '12345', 'Abul Khair', 'Jyote', '[email protected]', NULL, 'female', NULL),
(3358, '12345', 'Iftekhar', 'Mahfuz', NULL, NULL, 'male', NULL),
(3542, '12345', 'Md. Aminul ', 'Islam', NULL, NULL, 'mele', NULL),
(4161, '12345', 'Subrata Kumar', 'Dey', NULL, NULL, 'male', NULL),
(4228, '12345', 'Habib Bin', 'Muzaffer', NULL, NULL, 'male', NULL),
(4275, '12345', 'Tahsin F. Ara', 'Nayna', NULL, NULL, 'female', NULL),
(4351, '12345', 'Nabila Rahman', 'Nodi', NULL, NULL, 'female', NULL),
(4361, '12345', 'Shovasis Kumar', 'Biswas', NULL, NULL, 'male', NULL),
(4408, '12345', 'Asif Bin', 'Khalid', '[email protected]', 88019043, 'male', 'senior lecturer'),
(4449, '12345', 'Sheikh', 'Abujar', NULL, NULL, NULL, NULL),
(4453, '12345', 'Moumita', 'Asad', NULL, NULL, NULL, NULL),
(4467, '12345', 'Nashid', 'Sultana', NULL, NULL, NULL, NULL),
(4475, '12345', 'Sejuti', 'Rahman', NULL, NULL, NULL, NULL),
(8902, '12345', 'Md Fahad', 'Monir', '[email protected]', 88017465, 'male', 'senior lecturer'),
(89011, '12345', 'Aquib ', 'Azmain', '[email protected]', 1716384532, 'male', 'lecturer');
-- --------------------------------------------------------
--
-- Table structure for table `evaluation_strategy_t`
--
CREATE TABLE `evaluation_strategy_t` (
`eSID` int(11) NOT NULL,
`assessmentTool1` mediumtext DEFAULT NULL,
`markDistribution1` int(11) DEFAULT NULL,
`bloomsCategory1` mediumtext DEFAULT NULL,
`courseOutlineID` int(11) DEFAULT NULL,
`assessmentTool2` mediumtext DEFAULT NULL,
`assessmentTool3` mediumtext DEFAULT NULL,
`markDistribution2` int(11) DEFAULT NULL,
`markDistribution3` int(11) DEFAULT NULL,
`bloomsCategory2` mediumtext DEFAULT NULL,
`bloomsCategory3` mediumtext DEFAULT NULL,
`assessmentType` mediumtext DEFAULT NULL,
`subTotal` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `evaluation_strategy_t`
--
INSERT INTO `evaluation_strategy_t` (`eSID`, `assessmentTool1`, `markDistribution1`, `bloomsCategory1`, `courseOutlineID`, `assessmentTool2`, `assessmentTool3`, `markDistribution2`, `markDistribution3`, `bloomsCategory2`, `bloomsCategory3`, `assessmentType`, `subTotal`) VALUES
(1, 'a', 1, 'a', 12, 'b', 'c', 2, 3, 'b', 'c', 'i dont know', 40),
(2, 'd', 4, 'd', 12, 'e', 'f', 5, 6, 'e', 'f', 'bleh', 60),
(3, 'Two Class Tests', 10, '', 4, 'One report & assignment\r\n\r\n', 'One Project & Presentation', 15, 15, 'Analyze, Develop', 'Demonstrate, Use', 'Continuous\r\nAssessment', 40),
(4, 'Midterm Examination', 25, 'Analyze, Use', 4, 'Final Term Examination', '', 35, NULL, 'Demonstrate, Model', '', 'Summative Assessment', 60),
(5, 'a', 1, 'a', 13, 'b', 'c', 2, 3, 'b', 'c', 'i dont know', 40);
-- --------------------------------------------------------
--
-- Table structure for table `evaluation_t`
--
CREATE TABLE `evaluation_t` (
`evaluationID` int(11) NOT NULL,
`examID` varchar(20) NOT NULL,
`registrationID` int(11) NOT NULL,
`totalMarks` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `exam_t`
--
CREATE TABLE `exam_t` (
`examID` int(11) NOT NULL,
`examName` varchar(30) NOT NULL,
`sectionID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `exam_t`
--
INSERT INTO `exam_t` (`examID`, `examName`, `sectionID`) VALUES
(1, 'CSC101FinalSpring2021', 10),
(2, 'EEE131FinalSpring2021', 1),
(3, 'EEE231FinalSummer2020', 4),
(4, 'EEE233FinalAutumn2021', 5),
(5, 'ENG101FinalSummer2021', 7),
(6, 'MKT101FinalSpring2020', 11),
(7, 'EEE131FinalAutumn2021', 3),
(9, 'CSC101FinalSummer2021', 14),
(10, 'CSC101FinalAutumn2021', 15),
(11, 'quiz-1', 10),
(12, 'midterm', 1),
(13, 'quiz-1', 3),
(14, 'quiz-1', 7),
(15, 'quiz-1', 19),
(16, 'quiz-2', 19);
-- --------------------------------------------------------
--
-- Table structure for table `faculty_t`
--
CREATE TABLE `faculty_t` (
`f_employeeID` int(11) NOT NULL,
`departmentID` varchar(3) NOT NULL,
`rank` varchar(30) NOT NULL,
`joinDate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `faculty_t`
--
INSERT INTO `faculty_t` (`f_employeeID`, `departmentID`, `rank`, `joinDate`) VALUES
(2258, 'ENG', 'lecturer', '2014-08-13'),
(2344, 'ENG', 'lecturer', '2014-08-13'),
(2483, 'ENG', 'lecturer', '2014-08-13'),
(2518, 'ENG', 'lecturer', '2014-08-13'),
(3542, 'MIS', 'lecturer', '2012-10-10'),
(4275, 'EEE', 'Lecturer', '2012-11-02'),
(4351, 'EEE', 'lecturer', '2014-08-13'),
(4361, 'EEE', 'lecturer', '2014-08-13'),
(4449, 'CSE', 'lecturer', '2015-11-19');
-- --------------------------------------------------------
--
-- Table structure for table `lesson_plan_strategy_t`
--
CREATE TABLE `lesson_plan_strategy_t` (
`lPSID` int(11) NOT NULL,
`week` int(11) NOT NULL,
`topic` mediumtext NOT NULL,
`learningStrategy` mediumtext NOT NULL,
`assessmentStrategy` mediumtext NOT NULL,
`correspondingClo` varchar(10) NOT NULL,
`courseOutlineID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `lesson_plan_strategy_t`
--
INSERT INTO `lesson_plan_strategy_t` (`lPSID`, `week`, `topic`, `learningStrategy`, `assessmentStrategy`, `correspondingClo`, `courseOutlineID`) VALUES
(3, 1, 'Introduction: concept of database, DBMS Introduction: Database development process, Database architecture; Database languages and Interfaces', 'Lecture (3h)', 'Mid Exam Progressive Project', 'CLO1', 4),
(4, 2, 'Analysis: Rich Picture Analysis: Six Elements analysis', 'Lecture (3h)', 'Mid Exam Progressive Project', 'CLO1', 4),
(5, 3, 'Analysis: Process Diagram using BPMN 2.0 Analysis: Process Diagram and Improvement Process', 'Lecture (3h)', 'Mid Exam Progressive Project', 'CLO1', 4),
(6, 1, 'Introduction', 'Discussion', 'Quiz 1', 'CLO1', 11),
(7, 2, 'Internet of Things', 'Review presentations Classroom discussion', 'Quiz 2', 'CLO2', 11),
(8, 3, 'Artificial Intelligence (AI)', 'Review presentations Classroom discussion', 'Quiz 3', 'CLO3', 11),
(9, 1, 'Introduction', 'Discussion', 'Mid Exam Progressive Project', '2', 12),
(10, 1, 'Introduction', 'Lecture (3h)', 'Mid Exam Progressive Project', 'CLO1', 13);
-- --------------------------------------------------------
--
-- Table structure for table `plo_t`
--
CREATE TABLE `plo_t` (
`ploID` int(11) NOT NULL,
`ploNum` int(11) NOT NULL,
`programID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `plo_t`
--
INSERT INTO `plo_t` (`ploID`, `ploNum`, `programID`) VALUES
(1, 1, 1),
(2, 2, 1),
(3, 3, 1),
(4, 4, 1),
(5, 5, 1),
(6, 6, 1),
(7, 7, 1),
(8, 1, 2),
(9, 2, 2),
(10, 3, 2),
(11, 4, 2),
(12, 5, 2),
(13, 6, 2),
(14, 7, 2),
(15, 1, 3),
(16, 2, 3),
(17, 3, 3),
(18, 4, 3),
(19, 5, 3),
(20, 6, 3),
(21, 7, 3),
(22, 1, 9),
(23, 2, 9),
(24, 3, 9),
(25, 4, 9),
(26, 5, 9),
(27, 6, 9),
(28, 7, 9),
(29, 1, 10),
(30, 2, 10),
(31, 3, 10),
(32, 4, 10),
(33, 5, 10),
(34, 6, 10),
(35, 7, 10),
(36, 1, 8),
(37, 2, 8),
(38, 3, 8),
(39, 4, 8),
(40, 5, 8),
(41, 6, 8),
(42, 7, 8),
(43, 1, 13),
(44, 2, 13),
(45, 3, 13),
(46, 4, 13),
(47, 5, 13),
(48, 6, 13),
(49, 7, 13),
(50, 1, 20),
(51, 2, 20),
(52, 3, 20),
(53, 4, 20),
(54, 5, 20),
(55, 6, 20),
(56, 7, 20),
(57, 8, 13),
(58, 9, 13),
(59, 10, 13),
(60, 11, 13),
(61, 12, 13),
(62, 13, 13),
(63, 9, 9),
(64, 11, 9),
(65, 12, 9),
(66, 8, 20),
(67, 9, 20),
(68, 10, 20),
(69, 11, 20),
(70, 12, 20),
(71, 13, 20),
(72, 0, 11),
(73, 0, 12),
(74, 0, 11),
(75, 13, 4),
(76, 13, 6),
(77, 10, 1),
(78, 10, 6),
(79, 12, 6),
(80, 12, 1),
(81, 10, 4),
(82, 6, 12),
(83, 6, 9),
(84, 4, 12),
(85, 6, 11),
(86, 2, 12),
(87, 6, 12),
(88, 4, 13),
(89, 1, 13),
(90, 1, 13),
(91, 2, 13),
(92, 4, 9),
(93, 6, 9),
(94, 3, 9),
(95, 6, 10),
(96, 2, 9),
(97, 1, 10),
(98, 1, 13),
(99, 5, 13),
(100, 5, 13),
(101, 1, 11),
(102, 6, 13),
(103, 5, 9),
(104, 1, 10),
(105, 1, 13),
(106, 1, 10),
(107, 3, 10);
-- --------------------------------------------------------
--
-- Table structure for table `po_t`
--
CREATE TABLE `po_t` (
`poID` int(11) NOT NULL,
`poNum` int(11) NOT NULL,
`programID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `po_t`
--
INSERT INTO `po_t` (`poID`, `poNum`, `programID`) VALUES
(1, 1, 1),
(2, 2, 1),
(3, 3, 1),
(4, 4, 1),
(5, 5, 1),
(6, 6, 1),
(7, 7, 1),
(8, 1, 2),
(9, 2, 2),
(10, 3, 2),
(11, 4, 2),
(12, 5, 2),
(13, 6, 2),
(14, 7, 2),
(15, 1, 3),
(16, 2, 3),
(17, 3, 3),
(18, 4, 3),
(19, 5, 3),
(20, 6, 3),
(21, 7, 3),
(22, 1, 9),
(23, 2, 9),
(24, 3, 9),
(25, 4, 9),
(26, 5, 9),
(27, 6, 9),
(28, 7, 9),
(29, 1, 10),
(30, 2, 10),
(31, 3, 10),
(32, 4, 10),
(33, 5, 10),
(34, 6, 10),
(35, 7, 10),
(36, 1, 8),
(37, 2, 8),
(38, 3, 8),
(39, 4, 8),
(40, 5, 8),
(41, 6, 8),
(42, 7, 8),
(43, 1, 13),
(44, 2, 13),
(45, 3, 13),
(46, 4, 13),
(47, 5, 13),
(48, 6, 13),
(49, 7, 13),
(50, 1, 20),
(51, 2, 20),
(52, 3, 20),
(53, 4, 20),
(54, 5, 20),
(55, 6, 20),
(56, 7, 20),
(57, 8, 13),
(58, 9, 13),
(59, 10, 13),
(60, 11, 13),
(61, 12, 13),
(62, 13, 13),
(63, 9, 9),
(64, 11, 9),
(65, 12, 9),
(66, 8, 20),
(67, 9, 20),
(68, 10, 20),
(69, 11, 20),
(70, 12, 20),
(71, 13, 20),
(72, 0, 11),
(73, 0, 12),
(74, 0, 11),
(75, 13, 4),
(76, 13, 6),
(77, 10, 1),
(78, 10, 6),
(79, 12, 6),
(80, 12, 1),
(81, 10, 4),
(82, 6, 12),
(83, 6, 9),
(84, 4, 12),
(85, 6, 11),
(86, 2, 12),
(87, 6, 12),
(88, 4, 13),
(89, 1, 13),
(90, 1, 13),
(91, 2, 13),
(92, 4, 9),
(93, 6, 9),
(94, 3, 9),
(95, 6, 10),
(96, 2, 9),
(97, 1, 10),
(98, 1, 13),
(99, 5, 13),
(100, 5, 13),
(101, 1, 11),
(102, 6, 13),
(103, 5, 9),
(104, 1, 10),
(105, 1, 13),
(106, 1, 10),
(107, 3, 10);
-- --------------------------------------------------------
--
-- Table structure for table `pre_req_course_t`
--
CREATE TABLE `pre_req_course_t` (
`preReqID` int(11) NOT NULL,
`courseID` varchar(6) NOT NULL,
`preReqCourseID` varchar(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `program_t`
--
CREATE TABLE `program_t` (
`programID` int(11) NOT NULL,
`programName` varchar(50) NOT NULL,
`departmentID` varchar(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `program_t`
--
INSERT INTO `program_t` (`programID`, `programName`, `departmentID`) VALUES
(1, 'BBA in ACN', 'ACN'),
(2, 'BSc in ECO', 'ECO'),
(3, 'BBA in FIN', 'FIN'),
(4, 'BBA in MGT', 'MGT'),
(5, 'BBA in HRM', 'HRM'),
(6, 'BBA in IB', 'IB'),
(7, 'BBA in MIS', 'MIS'),
(8, 'BBA in MKT', 'MKT'),
(9, 'BSc in EEE', 'EEE'),
(10, 'BSc in ETE', 'EEE'),
(11, 'BSc in CEN', 'CSE'),
(12, 'BSc in CSC', 'CSE'),
(13, 'BSc in CSE', 'CSE'),
(14, 'BSc in PHY', 'PS'),
(15, 'BSc in MAT', 'PS'),
(16, 'BSc in BIOCHEM', 'LS'),
(17, 'BSc in MICROBIO', 'LS'),
(18, 'BSc in LWRM', 'ESM'),
(19, 'BSc in ENVMGT', 'ESM'),
(20, 'BA in ENG', 'ENG'),
(21, 'BA in ELT', 'ENG'),
(22, 'BA in GSS', 'GSG'),
(23, 'BA in LAW', 'LAW'),
(24, 'BA in MCM', 'MC'),
(25, 'BSs in ANT', 'SSH'),
(26, 'BSs in Sociology', 'SSH'),
(27, 'Bachelor of Pharmacy', 'PHA'),
(28, 'Master of Public Health', 'PH');
-- --------------------------------------------------------
--
-- Table structure for table `question_t`
--
CREATE TABLE `question_t` (
`questionID` int(11) NOT NULL,
`questionDetails` mediumtext NOT NULL,
`markPerQuestion` int(11) NOT NULL,
`questionNum` int(11) NOT NULL,
`difficultyLevel` int(11) DEFAULT NULL,
`examID` varchar(20) DEFAULT NULL,
`courseID` varchar(6) DEFAULT NULL,
`coNum` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `question_t`
--
INSERT INTO `question_t` (`questionID`, `questionDetails`, `markPerQuestion`, `questionNum`, `difficultyLevel`, `examID`, `courseID`, `coNum`) VALUES
(79, 'add three things in your answer', 10, 1, 3, '11', 'CSC101', 1),
(80, 'state three things about the fundamentals of computer science', 10, 2, 5, '11', 'CSC101', 2),
(81, 'count the number of countries', 10, 3, 1, '11', 'CSC101', 3),
(82, 'what is the name of this course', 10, 1, 1, '12', 'EEE131', 1),
(83, 'define the meaning of this course', 10, 2, 1, '12', 'EEE131', 2),
(84, 'add three things in your answer', 10, 1, 3, '13', 'EEE131', 2),
(85, 'what is this course about', 10, 1, 0, '14', 'EEE131', 1),
(86, 'name three things', 10, 2, 1, '14', 'EEE131', 2),
(87, 'define the fundamentals of this course', 10, 3, 1, '14', 'EEE131', 3),
(88, 'what do you expect from this course', 10, 4, 0, '14', 'EEE131', 4),
(89, 'add three things in your answer', 10, 1, 3, '15', 'EEE131', 1),
(90, 'define the meaning of this course', 10, 2, 1, '15', 'EEE131', 2),
(91, 'define the fundamentals of this course', 10, 3, 1, '15', 'EEE131', 3),
(92, 'what do you expect from this course', 10, 4, 0, '15', 'EEE131', 4),
(93, 'what is the name of this course', 10, 1, 1, '16', 'EEE131', 2),
(94, 'define the meaning of this course', 10, 2, 1, '16', 'EEE131', 3),
(95, '', 100, 0, NULL, NULL, NULL, 2),
(96, '', 100, 0, NULL, NULL, NULL, 2),
(97, '', 100, 0, NULL, NULL, NULL, 3),
(98, '', 100, 0, NULL, NULL, NULL, 4),
(99, '', 100, 0, NULL, NULL, NULL, 2),
(100, '', 100, 0, NULL, NULL, NULL, 4),
(101, '', 100, 0, NULL, NULL, NULL, 51),
(102, '', 100, 0, NULL, NULL, NULL, 52),
(103, '', 100, 0, NULL, NULL, NULL, 53),
(104, '', 100, 0, NULL, NULL, NULL, 0),
(105, '', 100, 0, NULL, NULL, NULL, 0),
(106, '', 100, 0, NULL, NULL, NULL, 1),
(107, '', 100, 0, NULL, NULL, NULL, 2),
(108, '', 100, 0, NULL, NULL, NULL, 3),
(109, '', 100, 0, NULL, NULL, NULL, 1),
(110, '', 100, 0, NULL, NULL, NULL, 1),
(111, '', 100, 0, NULL, NULL, NULL, 2),
(112, '', 100, 0, NULL, NULL, NULL, 3),
(113, '', 100, 0, NULL, NULL, NULL, 4),
(114, '', 100, 0, NULL, NULL, NULL, 1),
(115, '', 100, 0, NULL, NULL, 'csc303', 2),
(116, '', 100, 0, NULL, NULL, 'csc303', 3),
(117, '', 100, 0, NULL, NULL, 'csc303', 4),
(118, '', 100, 0, NULL, NULL, 'csc303', 1),
(119, '', 100, 0, NULL, NULL, 'csc303', 2),
(120, '', 100, 0, NULL, NULL, 'csc303', 3),
(121, '', 100, 0, NULL, NULL, 'eee131', 1),
(122, '', 100, 0, NULL, NULL, 'eee131', 1),
(123, '', 100, 0, NULL, NULL, 'mis442', 1),
(124, '', 100, 0, NULL, NULL, 'mis442', 1),
(125, '', 100, 1, 5, '15', 'CSC303', 1),
(126, '', 100, 4, 3, '14', 'mis442', 1),
(127, '', 100, 2, 2, '11', 'EEE131', 1),
(128, '', 100, 2, 3, '10', 'CSC101', 2),
(129, '', 100, 3, 5, '10', 'csc401', 3),
(130, '', 100, 2, 1, '12', 'eee131', 3),
(131, '', 100, 2, 4, '11', 'EEE131', 4),
(132, '', 100, 1, 1, '13', 'EEE131', 3),
(133, '', 100, 4, 5, '13', 'EEE131', 3),
(134, '', 100, 1, 1, '14', 'CSC401', 3),
(135, '', 100, 1, 5, '11', 'CSC101', 1),
(136, '', 100, 3, 3, '14', 'CSC401', 1),
(137, '', 100, 3, 5, '16', 'CSC401', 1),