-- --------------------------------------------------------
-- Server OS:                    Win32
-- HeidiSQL Version:             11.0.0.5919
-- --------------------------------------------------------



-- Dumping database structure for quad
DROP DATABASE IF EXISTS `quad`;
CREATE DATABASE IF NOT EXISTS `quad` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `quad`;

-- Dumping structure for table quad.0a_settings
CREATE TABLE IF NOT EXISTS `0a_settings` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `sname` varchar(30) NOT NULL,
  `svalue` varchar(60) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.0a_settings: ~28 rows (approximately)
INSERT INTO `0a_settings` (`id`, `sname`, `svalue`) VALUES
	(1, 'tbl_settings', '0a_settings'),
	(2, 'tbl_users', '1a_users'),
	(3, 'tbl_devices', '1b_devices'),
	(4, 'tbl_period', '2a_period'),
	(5, 'tbl_inkake', '2b_intake'),
	(6, 'tbl_semester', '2c_sem'),
	(7, 'tbl_student', '3a_student'),
	(8, 'tbl_student_leaders', '3b_student_leaders'),
	(9, 'tbl_role', '3c_role'),
	(10, 'tbl_appeal', '3d_appeal'),
	(11, 'tbl_remarks', '3e_remarks'),
	(12, 'tbl_survery_cat', '5a_category'),
	(13, 'tbl_survey', '5b_survey'),
	(14, 'tbl_block', '5c_block'),
	(15, 'tbl_thread', '5d_thread'),
	(16, 'tbl_resp_2020', '5x_resp_2020'),
	(17, 'tbl_course', '6a_course'),
	(18, 'tbl_course_unit', '6b_course_unit'),
	(19, 'tbl_unit_load', '6c_unit_load'),
	(20, 'tbl_dept', '6d_dept'),
	(21, 'tbl_faculty', '6e_faculty'),
	(22, 'tbl_program', '6f_program'),
	(23, 'tbl_res', '7b_resources'),
	(26, 'tbl_gal', '7a_gallery'),
	(27, 'tbl_mails', '6h_mails'),
	(28, 'tbl_scheule', '7c_schedule'),
	(29, 'tbl_schedule', '7c_schedule'),
	(30, 'tbl_schedule', '7c_schedule');

-- Dumping structure for table quad.1b_devices
CREATE TABLE IF NOT EXISTS `1b_devices` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `uid` tinyint(4) NOT NULL,
  `device` text NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table quad.1b_devices: ~0 rows (approximately)

-- Dumping structure for table quad.1c_role_groups
CREATE TABLE IF NOT EXISTS `1c_role_groups` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `role` varchar(5) NOT NULL,
  `pageAccess` varchar(100) NOT NULL,
  `roleAccess` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.1c_role_groups: ~9 rows (approximately)
INSERT INTO `1c_role_groups` (`id`, `role`, `pageAccess`, `roleAccess`) VALUES
	(1, 'DEV', '*', '*'),
	(2, 'SYST', '*', '*'),
	(3, 'SYSN', '*', '*'),
	(4, 'STD', 'O0', ''),
	(5, 'LEC', '*', '*'),
	(6, 'ADMT', '*', '*'),
	(7, 'ADMN', '*', '*'),
	(8, 'SUPA', '*', '*'),
	(9, 'SUPT', '*', '*');

-- Dumping structure for table quad.2a_period
CREATE TABLE IF NOT EXISTS `2a_period` (
  `periodID` int(11) NOT NULL AUTO_INCREMENT,
  `periodYear` smallint(4) NOT NULL,
  `periodSemester` tinyint(1) NOT NULL,
  `periodName` varchar(15) NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`periodID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- Dumping data for table quad.2a_period: ~2 rows (approximately)
INSERT INTO `2a_period` (`periodID`, `periodYear`, `periodSemester`, `periodName`, `status`) VALUES
	(1, 2020, 1, '2020-2021 / 1', 1),
	(2, 2020, 2, '2020-2021 / 2', 0);

-- Dumping structure for table quad.2b_intake
CREATE TABLE IF NOT EXISTS `2b_intake` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `intake` varchar(45) NOT NULL,
  `prefix` varchar(5) NOT NULL,
  `active` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.2b_intake: ~5 rows (approximately)
INSERT INTO `2b_intake` (`id`, `intake`, `prefix`, `active`) VALUES
	(1, '2016/2017', '2016', 1),
	(2, '2017/2016', '2017', 1),
	(3, '2018/2019', '2018', 1),
	(4, '2019/2020', '2019', 1),
	(5, '2020/2021', '2020', 1);

-- Dumping structure for table quad.3b_student_leaders
CREATE TABLE IF NOT EXISTS `3b_student_leaders` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `studentID` int(11) NOT NULL,
  `periodID` int(11) NOT NULL,
  `roleID` int(11) NOT NULL,
  PRIMARY KEY (`lid`),
  UNIQUE KEY `studentID` (`studentID`),
  KEY `periodID` (`periodID`),
  KEY `roleID` (`roleID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Guild Members';

-- Dumping data for table quad.3b_student_leaders: ~2 rows (approximately)
INSERT INTO `3b_student_leaders` (`lid`, `studentID`, `periodID`, `roleID`) VALUES
	(2, 1800402209, 1, 7),
	(4, 1800402313, 1, 100);

-- Dumping structure for table quad.3c_role
CREATE TABLE IF NOT EXISTS `3c_role` (
  `roleID` int(11) NOT NULL AUTO_INCREMENT,
  `roleName` varchar(100) NOT NULL,
  PRIMARY KEY (`roleID`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;

-- Dumping data for table quad.3c_role: ~13 rows (approximately)
INSERT INTO `3c_role` (`roleID`, `roleName`) VALUES
	(1, 'Guild President'),
	(2, 'Vice Guild President'),
	(3, 'Securitry General'),
	(4, 'Minister For Accdemic Affairs'),
	(5, 'Minister Of Finance,Innovation and Entrepreneurship'),
	(6, 'Minister For Justice and Constitutional Affairs'),
	(7, 'Minister For Transport, Publicity And Welfare'),
	(8, 'Games Union Chairperson'),
	(9, 'Representative(SADC)'),
	(10, 'Resident Campus Commissioner'),
	(11, 'Deputy Resident Campus Commissioner'),
	(100, 'Course Coordinator'),
	(101, 'Guild Media Specialist');

-- Dumping structure for table quad.3d_appeal
CREATE TABLE IF NOT EXISTS `3d_appeal` (
  `appealID` int(11) NOT NULL AUTO_INCREMENT,
  `studentID` int(11) NOT NULL,
  `audience` varchar(15) NOT NULL,
  `description` varchar(255) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`appealID`),
  KEY `studentID` (`studentID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table quad.3d_appeal: ~0 rows (approximately)

-- Dumping structure for table quad.3e_remarks
CREATE TABLE IF NOT EXISTS `3e_remarks` (
  `remarksID` int(11) NOT NULL AUTO_INCREMENT,
  `appealID` int(11) NOT NULL,
  `remarks` varchar(255) NOT NULL,
  `studentID` int(11) DEFAULT '0',
  PRIMARY KEY (`remarksID`),
  KEY `appealID` (`appealID`),
  KEY `studentID` (`studentID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table quad.3e_remarks: ~0 rows (approximately)

-- Dumping structure for table quad.5a_category
CREATE TABLE IF NOT EXISTS `5a_category` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roles_allowed` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quad.5a_category: ~5 rows (approximately)
INSERT INTO `5a_category` (`cat_id`, `cat_name`, `roles_allowed`) VALUES
	(1, 'Teaching Assesment', 'DEV,STD'),
	(2, 'Library & Services', 'DEV,SYST,SYSN,STD,LEC'),
	(3, 'Administration & Mgt', 'DEV,SYST,SYSN,STD,LEC'),
	(4, 'Council', 'DEV,COC'),
	(5, 'Senate', 'DEV,SEN');

-- Dumping structure for table quad.5b_survey
CREATE TABLE IF NOT EXISTS `5b_survey` (
  `su_id` int(11) NOT NULL AUTO_INCREMENT,
  `su_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `su_cat` int(11) NOT NULL,
  `su_desc` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `requires` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `u_id` smallint(6) NOT NULL,
  `enabled` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`su_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quad.5b_survey: ~7 rows (approximately)
INSERT INTO `5b_survey` (`su_id`, `su_name`, `su_cat`, `su_desc`, `requires`, `u_id`, `enabled`) VALUES
	(1, 'Teaching Process by students', 1, 'The objective of this form is to evaluate this course and the way it is being taught in order to refine and improve its teaching. ', 'courseID', 3, 1),
	(3, 'Assesment of Student Affairs', 1, 'Aimed at assessing the teaching and learning process2', '', 3, 1),
	(4, 'Assesment of Library Services', 2, 'This survey will be used to assess library services against set criteria. The quality of the different aspects is assessed on a scale of 1-5. The scores have the following meaning:', '', 3, 1),
	(5, 'Self Evaluation Senate', 5, 'The survey is used to assess the performance of the Busitema University Senate by its members. The quality of the different aspects is assessed on a scale 1-5. The scores have the following meaning:', '', 3, 1),
	(6, 'Assessment of University Council', 4, 'This survey is used to assess the performance of the Busitema University Council by its members. The quality of different aspects is assessed on scale of 1-5. The scores have the following meaning', '', 3, 1),
	(7, 'Assessment of university central administration', 3, 'This survey is used to assess the performance of the University Central Administration function by Management staff. The quality of the different aspects is assessed on scale of 1-5. The scores have the following:', '', 3, 1),
	(13, 'Graduate Exit Survey', 4, 'This survey intends to get feed', '', 3, 1);

-- Dumping structure for table quad.5c_block
CREATE TABLE IF NOT EXISTS `5c_block` (
  `block_id` int(11) NOT NULL AUTO_INCREMENT,
  `block_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `su_id` int(11) NOT NULL,
  PRIMARY KEY (`block_id`),
  KEY `su_id` (`su_id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quad.5c_block: ~48 rows (approximately)
INSERT INTO `5c_block` (`block_id`, `block_name`, `su_id`) VALUES
	(1, 'Part A: The Course', 1),
	(2, 'Part B: The Course Facilitator', 1),
	(3, 'Part C: The Teaching Process', 1),
	(4, 'Part D: Teaching &Learning Environment', 1),
	(5, 'Part E: Other Comments', 1),
	(6, 'AUTONOMY', 5),
	(7, 'OPENNESS AND LUSIVENESS', 5),
	(8, 'ACADEMIC FUNCTIONS OF THE UNIVERSITY', 5),
	(9, 'OPERATIONS', 5),
	(10, 'CONDUCT OF SENATE MEETINGS', 5),
	(11, 'PERIODIC REVIEWS AND REPORTING', 5),
	(12, 'THE LIBRARY AS A PLACE OF STUDY,REFLECTION AND CREATIVITY', 4),
	(13, 'RELIABILITY OF SERVICES', 4),
	(14, 'RESPONSIVENESS AND TIMELINESS', 4),
	(15, 'REASSURANCE', 4),
	(16, 'EMPATHY', 4),
	(17, 'E-RESOURSES', 4),
	(18, 'GOVERNANCE', 7),
	(19, 'STRATEGIC PLANNING AND IMPLEMENTATION', 7),
	(20, 'RESPONDING TO NEEDS OF KEY STAKEHOLDERS', 7),
	(21, 'STAFFING', 7),
	(22, 'PROVISION OF SERVICES', 7),
	(23, 'BUDGETING', 7),
	(24, 'ACADEMIC EXCELLENCE', 7),
	(25, 'QUALITY ASSURANCE', 7),
	(26, 'FINANCIAL AND ADMINISTRATIVE MANAGEMENT', 7),
	(27, 'INVESTMENT', 7),
	(28, 'HUMAN RESOURCE MANAGEMENT', 7),
	(29, 'INFRASTRUCTURE DEVELOPMENT AND MAINTENANCE', 7),
	(30, 'DEBT MANAGEMENT', 7),
	(31, 'LEADERSHIP', 6),
	(32, 'STRUCTURE AND RELATIONSHIPS', 6),
	(33, 'TRANSPARENCY  AND ACCOUNTABILITY', 6),
	(34, 'COMPLIANCE', 6),
	(35, 'PERFORMANCE', 6),
	(36, 'MEETINGS AND COMMUNICATIONS', 6),
	(38, 'GOVERNANCE', 3),
	(39, 'MAINTENANCE OF CAMPUS GROUNDS', 3),
	(40, 'CHAPLAINCY', 3),
	(41, 'COUNSELLING SERVICES', 3),
	(42, 'DISABILITY SERVICES', 3),
	(43, 'INTERNATIONAL STUDENT SERVICES', 3),
	(44, 'ORIENTATION OF NEW STUDENTS', 3),
	(45, 'SPORTS AND RECREATION', 3),
	(46, 'STUDENT DISCIPLINE', 3),
	(47, 'STUDENT ACCOMMODATION AND RESIDENTIAL LIFE', 3),
	(48, 'STUDENT FEEDBACK', 3),
	(53, 'Teaching and learning', 13);

-- Dumping structure for table quad.5d_thread
CREATE TABLE IF NOT EXISTS `5d_thread` (
  `thread_id` int(11) NOT NULL AUTO_INCREMENT,
  `thread_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `thread_type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'rating',
  `thread_options` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `options_value_order` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal',
  `su_id` int(11) NOT NULL,
  `block_id` int(11) NOT NULL,
  PRIMARY KEY (`thread_id`),
  KEY `block_id` (`block_id`)
) ENGINE=InnoDB AUTO_INCREMENT=388 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quad.5d_thread: ~376 rows (approximately)
INSERT INTO `5d_thread` (`thread_id`, `thread_name`, `thread_type`, `thread_options`, `options_value_order`, `su_id`, `block_id`) VALUES
	(1, 'Had positive impact on my learning', 'rating', '', 'normal', 1, 1),
	(2, 'Was pertinent to my major field of study', 'rating', '', 'normal', 1, 1),
	(3, 'Challenged and engaged my attention', 'rating', '', 'normal', 1, 1),
	(4, 'Had positive impact to my professional practice', 'rating', '', 'normal', 1, 1),
	(5, 'Provided significant insights and is relavant to my career prospects', 'rating', '', 'normal', 1, 1),
	(6, 'Improved my research skills and encouraged me to read widely', 'rating', '', 'normal', 1, 1),
	(7, 'Contents seemed too difficult to assimilate', 'rating', '', 'reversed', 1, 1),
	(8, 'Contents  were appropriate in length and stimulated my thinking', 'rating', '', 'normal', 1, 1),
	(9, 'Time was appropriate for the delivery of the content', 'rating', '', 'normal', 1, 1),
	(10, 'Improved my knowledge and understanding', 'rating', '', 'normal', 1, 1),
	(11, 'Requires restructuring and revision', 'rating', '', 'reversed', 1, 1),
	(12, 'Entails an outline with specific goals  and objectives', 'rating', '', 'normal', 1, 1),
	(13, 'Gave the course outline to students at the start ', 'rating', '', 'normal', 1, 2),
	(14, 'Gave clear course description and objectives at the start', 'rating', '', 'normal', 1, 2),
	(15, 'Explained the mode of Evaluation (course evaluation) ', 'rating', '', 'normal', 1, 2),
	(16, 'Recommended up to date Reference or selected readings ', 'rating', '', 'normal', 1, 2),
	(17, 'Availed the time tables  and schedules for the course', 'rating', '', 'normal', 1, 2),
	(18, 'Would review the previous lecture and blend it with the current topic', 'rating', '', 'normal', 1, 2),
	(19, 'Had a cardinal and professional relation with the students', 'rating', '', 'normal', 1, 2),
	(20, 'Was knowledgeable and resourceful  on the subject matter', 'rating', '', 'normal', 1, 2),
	(21, 'Presented the lectures as scheduled and kept time', 'rating', '', 'normal', 1, 2),
	(22, 'Presented the subject matter logically with  clear explanations', 'rating', '', 'normal', 1, 2),
	(23, 'Was decent in dress and language during the teaching process', 'rating', '', 'normal', 1, 2),
	(24, 'Provided timely feedback on students? assessments & work', 'rating', '', 'normal', 1, 2),
	(25, 'Was sensitive to individual differences & encouraged personal opinions', 'rating', '', 'normal', 1, 2),
	(26, 'Provided  opportunities for student participation and involvement including discussions', 'rating', '', 'normal', 1, 2),
	(27, 'Was Audible and an effective communicator', 'rating', '', 'normal', 1, 2),
	(28, 'Guided and counselled the students on academic problems', 'rating', '', 'normal', 1, 2),
	(29, 'Completed the syllabus as scheduled', 'rating', '', 'normal', 1, 2),
	(30, 'The course was taught using a variety of teaching  methods and aids including ICT, tutorials etc.', 'rating', '', 'normal', 1, 3),
	(31, 'Students were taught and assessed through variety of tools, e.g. practicals, tests, course work etc.', 'rating', '', 'normal', 1, 3),
	(32, 'Assessment was in line with the course objectives', 'rating', '', 'normal', 1, 3),
	(33, 'Continuous Assessment was time bound', 'rating', '', 'normal', 1, 3),
	(34, 'Student attendance and progress was monitored and positive guidance given', 'rating', '', 'normal', 1, 3),
	(35, 'Student records (continuous assessment , attendance etc.) handled with care', 'rating', '', 'normal', 1, 3),
	(36, 'Personal study was encouraged (given tasks and problems to solve)', 'rating', '', 'normal', 1, 3),
	(37, 'Adequate Lighting', 'rating', '', 'normal', 1, 4),
	(38, 'Adequate Chairs/tables', 'rating', '', 'normal', 1, 4),
	(39, 'Adequate Chairs/tables', 'rating', '', 'normal', 1, 4),
	(40, 'Ample Space', 'rating', '', 'normal', 1, 4),
	(41, 'Adequate Laboratory/workshop materials with student numbers', 'rating', '', 'normal', 1, 4),
	(42, 'What were your best aspects of the course?  ', 'answer', '', 'normal', 1, 5),
	(43, 'What were the most challenging aspects of the course? ', 'answer', '', 'normal', 1, 5),
	(44, 'Give any additional information that would improve Teaching and learning', 'answer', '', 'normal', 1, 5),
	(45, 'Senate establishes academic policies independently', 'rating', 'na', 'normal', 5, 6),
	(46, 'Senate establishes academic standards independently', 'rating', '', 'normal', 5, 6),
	(47, 'Academic policies are well documented', 'rating', '', 'normal', 5, 6),
	(48, 'Academic quality standards are well documented', 'rating', '', 'normal', 5, 6),
	(49, 'Senate considers on regular basis new academic policies and quality standards', 'rating', '', 'normal', 5, 6),
	(50, 'Senate considers on regular basis amendments of academic policies and quality standards', 'rating', '', 'normal', 5, 6),
	(51, 'Senate membership and attendance embodies equality', 'rating', '', 'normal', 5, 7),
	(52, 'Senate membership and attendance embodies diversity', 'rating', '', 'normal', 5, 7),
	(53, 'Senate membership and attendance embodies inclusiveness of the University community', 'rating', '', 'normal', 5, 7),
	(54, 'Senate membership and attendance embodies inclusion of major stakeholders external to the University', 'rating', '', 'normal', 5, 7),
	(55, 'Senate considers programmes for improving equity, diversity, and inclusiveness', 'rating', '', 'normal', 5, 7),
	(56, 'Senate ,via its committees, members and officers, consults widely before decisions are made or actions taken on matters of Universitywide concern', 'rating', '', 'normal', 5, 7),
	(57, 'Senate makes a serious attempt to reach consensus on issues or set up a mechanism for resolving differences if a consensus cannot be reached', 'rating', '', 'normal', 5, 7),
	(58, 'Academic quality assurance procedures are updated regularly', 'rating', '', 'normal', 5, 8),
	(59, 'Senate regularly considers emerging issues in the higher education sector and their potential implications for the University', 'rating', '', 'normal', 5, 8),
	(60, 'Approving and accrediting courses, programmes and academic units', 'rating', '', 'normal', 5, 9),
	(61, 'Consideration of the quality and development of research', 'rating', '', 'normal', 5, 9),
	(62, 'Preparation of Senate?s annual workplan', 'rating', '', 'normal', 5, 9),
	(63, 'Communication of Senate priorities, practices and resolutions', 'rating', '', 'normal', 5, 9),
	(64, 'Handling of students grievances and disputes', 'rating', '', 'normal', 5, 9),
	(65, 'Regulation and determination of the requirements for the admission of students', 'rating', '', 'normal', 5, 9),
	(67, 'Regulation of all examinations and the standard of proficiency to be attained in such examinations', 'rating', '', 'normal', 5, 9),
	(68, 'Appointed of external examiners', 'rating', '', 'normal', 5, 9),
	(69, 'Award of degrees and distinctions of the University', 'rating', '', 'normal', 5, 9),
	(70, 'Award of scholarships and prizes administered by the University', 'rating', '', 'normal', 5, 9),
	(71, 'Constituting of professorial chairs, readerships and other academic offices', 'rating', '', 'normal', 5, 9),
	(72, 'Confinement of honorary degrees', 'rating', '', 'normal', 5, 9),
	(73, 'Establishment of new academic departments, schools, institutes, bureaux or similar bodies', 'rating', '', 'normal', 5, 9),
	(74, 'Making regular reports to the Council regarding the performance of Senate functions', 'rating', '', 'normal', 5, 9),
	(75, 'Procedures for Senate meetings closely follow the Standing  Orders', 'rating', '', 'normal', 5, 10),
	(76, 'Senate members attend all meetings', 'rating', '', 'normal', 5, 10),
	(77, 'Confidentiality with regard to those matters noted as confidential is upheld', 'rating', '', 'normal', 5, 10),
	(78, 'Timely conduct of business during meetings (start and finish times)', 'rating', '', 'normal', 5, 10),
	(79, 'Members receive the Senate papers with care before meetings', 'rating', '', 'normal', 5, 10),
	(80, 'Members read the Senate papers with care before meetings', 'rating', '', 'normal', 5, 10),
	(81, 'Members participate and contribute actively at meetings', 'rating', '', 'normal', 5, 10),
	(82, 'Senate and its committees conduct self-assessment and review every three years', 'rating', '', 'normal', 5, 11),
	(83, 'Senate reports effectively its decisions and resolutions in an efficient manner to the University community and all other stakeholders', 'rating', '', 'normal', 5, 11),
	(84, 'Convenient opening hours', 'rating', '', 'normal', 4, 12),
	(85, 'A comfortable and inviting location ', 'rating', '', 'normal', 4, 12),
	(86, 'Library has modern equipment', 'rating', '', 'normal', 4, 12),
	(87, 'Visually appealing facilities', 'rating', '', 'normal', 4, 12),
	(88, 'Adequate ICT Facilities', 'rating', '', 'normal', 4, 12),
	(89, 'Space that enables quiet study', 'rating', '', 'normal', 4, 12),
	(90, 'Access to digital collections from a personal computer', 'rating', '', 'normal', 4, 12),
	(91, 'Orientation and training sessions are conducted when needed', 'rating', '', 'normal', 4, 12),
	(92, 'Library staff understand the needs of their users', 'rating', '', 'normal', 4, 12),
	(93, 'A place of reflection', 'rating', '', 'normal', 4, 12),
	(94, 'A place for creativity', 'rating', '', 'normal', 4, 12),
	(95, 'Visually appealing materials (such as pamphlets, statements or signs) associated with each service', 'rating', '', 'normal', 4, 12),
	(96, 'Availability of required information', 'rating', '', 'normal', 4, 13),
	(97, 'Convenient access to library collections', 'rating', '', 'normal', 4, 13),
	(98, 'Staff provide access to library collections', 'rating', '', 'normal', 4, 13),
	(99, 'Staff perform duties accurately', 'rating', '', 'normal', 4, 13),
	(100, 'Timely document delivery', 'rating', '', 'normal', 4, 13),
	(101, 'Staff perform services correctly the first time', 'rating', '', 'normal', 4, 13),
	(102, 'Staff dependability in handling user?s service problems', 'rating', '', 'normal', 4, 13),
	(103, 'Supports lecturers and students in the research process', 'rating', '', 'normal', 4, 13),
	(104, 'Provides instruction to users on how to effectively use specific information sources both printed and electronic', 'rating', '', 'normal', 4, 13),
	(105, 'Prompt service to users', 'rating', '', 'normal', 4, 14),
	(106, 'Fast and reliable internet and search facilities', 'rating', '', 'normal', 4, 14),
	(107, 'Readiness to respond to user?s questions', 'rating', '', 'normal', 4, 14),
	(108, 'Keeping users informed about when services will be performed', 'rating', '', 'normal', 4, 14),
	(109, 'Knowledge of library employees in their specific lines of duty', 'rating', '', 'normal', 4, 15),
	(110, 'Giving users individual attention', 'rating', '', 'normal', 4, 15),
	(111, 'Ability to inspire trust and confidence', 'rating', '', 'normal', 4, 15),
	(112, 'Staff deal with users in a concerned and considerate manner', 'rating', '', 'normal', 4, 16),
	(113, 'Staff are always courteous and polite', 'rating', '', 'normal', 4, 16),
	(114, 'Staff are willing to help customers having difficulties', 'rating', '', 'normal', 4, 16),
	(115, 'Library computers are available to users during working hours', 'rating', '', 'normal', 4, 17),
	(116, 'Library computers can be used to access most of the library?s online resources, indexes and databases and electronic books', 'rating', '', 'normal', 4, 17),
	(117, 'Staff and students can access with both softcopy of library resources such as database, journals, articles, books, magazines in their disciplines.', 'rating', '', 'normal', 4, 17),
	(118, 'The university repository is maintained up-to-date', 'rating', '', 'normal', 4, 17),
	(119, 'Reliable internet access', 'rating', '', 'normal', 4, 17),
	(120, 'The governance structure of the university is clear and adequate', 'rating', '', 'normal', 7, 18),
	(121, 'Central Administration exhibits sound governance, competent and accountable management', 'rating', '', 'normal', 7, 18),
	(122, 'Central Administration ensures that the University has a clear management structure in which the decision-making processes, competencies and responsibilities have been clearly defined.', 'rating', '', 'normal', 7, 18),
	(123, 'There are transported and coherent quality assurance processes for the functions of Central Administration offices', 'rating', '', 'normal', 7, 18),
	(124, 'There are clear, open and explicit performance indicators for Central Administration offices', 'rating', '', 'normal', 7, 18),
	(125, 'The strategic plan has been adequately translated in implementation plans', 'rating', '', 'normal', 7, 19),
	(126, 'The University has effectively and efficiently met the objectives of the strategic plan', 'rating', '', 'normal', 7, 19),
	(127, 'The aims and goal of Central Administration offices are clearly established and understood', 'rating', '', 'normal', 7, 19),
	(128, 'Priorities are given to the principal goals of Central Administration offices', 'rating', '', 'normal', 7, 19),
	(129, 'Priorities are given to the principal goals of Central Administration offices', 'rating', '', 'normal', 7, 19),
	(130, 'Priorities are given to the principal goals of Central Administration offices', 'rating', '', 'normal', 7, 19),
	(131, 'The goals of Central Administration offices are compatible with the role of the University and its mission statement', 'rating', '', 'normal', 7, 19),
	(132, 'The goals of Central Administration offices are compatible with the role of the University and its mission statement', 'rating', '', 'normal', 7, 19),
	(133, 'The goals of Central Administration offices are coordinated with those of the Senate and Council of the University', 'rating', '', 'normal', 7, 19),
	(134, 'The goals of Central Administration offices are coordinated with those of other University offices and units', 'rating', '', 'normal', 7, 19),
	(135, 'Central Administration is clear about the relevant demands and needs of the key stakeholders', 'rating', '', 'normal', 7, 20),
	(136, 'Central Administration officers interact adequately with non-academic and support staff', 'rating', '', 'normal', 7, 20),
	(137, 'The University responds adequately to the requirements of the MoES and NCHE Requirements', 'rating', '', 'normal', 7, 20),
	(138, 'Central Administration officers interact adequately with academic staff', 'rating', '', 'normal', 7, 20),
	(139, 'Central Administration officers interact adequately with students', 'rating', '', 'normal', 7, 20),
	(140, 'Central administration officers interact adequately with external stakeholders', 'rating', '', 'normal', 7, 20),
	(141, 'Central Administration officers maintain effective communications, cooperation, and coordination with stakeholders', 'rating', '', 'normal', 7, 20),
	(142, 'Central Administration officers are recruited in transparent manner', 'rating', '', 'normal', 7, 21),
	(143, 'Present staff is adequate to provide the services of the central administration offices', 'rating', '', 'normal', 7, 21),
	(144, 'Future staffing plans are clearly defined', 'rating', '', 'normal', 7, 21),
	(145, 'Staff development programme for Central Administration officers is adequate', 'rating', '', 'normal', 7, 21),
	(146, 'Performance of Central Administration officers is adequately evaluated', 'rating', '', 'normal', 7, 21),
	(147, 'Services provided by the Central Administration offices adequately meet the needs of the staff, students, the general public', 'rating', '', 'normal', 7, 22),
	(148, 'Central Administration officers adequately supervise the subordinate administrative units', 'rating', '', 'normal', 7, 22),
	(149, 'The effectiveness of the Central Administration offices are determined and evaluated adequately', 'rating', '', 'normal', 7, 22),
	(150, 'The budget for Central Administration is adequate', 'rating', '', 'normal', 7, 23),
	(151, 'Priorities that govern the allocation of budget resources to the Central Administration are adequate', 'rating', '', 'normal', 7, 23),
	(152, 'The proportion of Central Administration budget allocated for activities directly related to teaching and learning are adequate', 'rating', '', 'normal', 7, 23),
	(153, 'The proportion of Central administration budget allocated for activities directly to research are adequate', 'rating', '', 'normal', 7, 23),
	(154, 'Central Administration effectively evaluates  its budget success', 'rating', '', 'normal', 7, 23),
	(155, 'Administrative costs are within reasonable limits (not too high or  too low)', 'rating', '', 'normal', 7, 23),
	(156, 'Developing, disseminating and implementing a human resource development  training plan in finance and management functions', 'rating', '', 'normal', 7, 24),
	(157, 'Operationalizing the Research Policy for strengthening the capacity to undertake and coordinate quality research ', 'rating', '', 'normal', 7, 24),
	(158, 'Establishing a central consultancy unit and improving internal and external coordination of consultancy', 'rating', '', 'normal', 7, 24),
	(159, 'Strengthening the human and financial capacity to undertake quality consultancy', 'rating', '', 'normal', 7, 24),
	(160, 'Improving research capacity in undergraduate/postgraduate programmes', 'rating', '', 'normal', 7, 24),
	(161, 'The University has developed and implemented a Quality Assurance Framework', 'rating', '', 'normal', 7, 25),
	(162, 'The University has established an operational Quality Assurance Framework', 'rating', '', 'normal', 7, 25),
	(163, 'The University uses benchmarking for assessing its core functions', 'rating', '', 'normal', 7, 25),
	(164, 'Establishing and operationalizing sustainable and improved financial and administrative management systems;', 'rating', '', 'normal', 7, 26),
	(165, 'Building capacity in faculties and units in development planning, coordinating, decision-making', 'rating', '', 'normal', 7, 26),
	(166, 'Provision of an institutional framework to support decision making at faculty and unit level', 'rating', '', 'normal', 7, 26),
	(167, 'Increasing transparency and accountability in resource allocation and utilization at the centre, faculty and units:', 'rating', '', 'normal', 7, 26),
	(168, 'Developing and implementing a risk management policy', 'rating', '', 'normal', 7, 26),
	(169, 'Developing and adopting statuses to govern its administration', 'rating', '', 'normal', 7, 26),
	(170, 'Developing capacity to engage in entrepreneurship and business for sustainability and competitiveness in knowledge economy.', 'rating', '', 'normal', 7, 27),
	(171, 'Operationalizing the Business Development Strategies', 'rating', '', 'normal', 7, 27),
	(172, 'There is increasing self-generated income from self-generated sustainable sources', 'rating', '', 'normal', 7, 27),
	(173, 'Establishing a leadership and knowledge centre on issues of natural and global concern', 'rating', '', 'normal', 7, 27),
	(174, 'Attaining the desired establishment of academic and support staff', 'rating', '', 'normal', 7, 28),
	(175, 'Implementing an adequate staff performance appraisal system', 'rating', '', 'normal', 7, 28),
	(176, 'Developing and Implementing the Human Resource Policy', 'rating', '', 'normal', 7, 28),
	(177, 'The University has adequate bed space and sports grounds', 'rating', '', 'normal', 7, 29),
	(178, 'The University has adequate staff office and lecture space', 'rating', '', 'normal', 7, 29),
	(179, 'The estates has adequate capacity to rehabilitate and maitain physical infrastructure', 'rating', '', 'normal', 7, 29),
	(180, 'Liquidating debt', 'rating', '', 'normal', 7, 30),
	(181, 'Developing and implementing a plan to trade off assets and liabilities', 'rating', '', 'normal', 7, 30),
	(182, 'Institutionalising cost saving measures to mitigate debt increase', 'rating', '', 'normal', 7, 30),
	(183, 'Establishing partnership for the university functions', 'rating', '', 'normal', 7, 30),
	(184, 'The Council provides leadership and vision', 'rating', '', 'normal', 6, 31),
	(185, 'Council members are clear about their roles and responsibilities', 'rating', '', 'normal', 6, 31),
	(186, 'Council members are clear about the distinction between executive and management roles', 'rating', '', 'normal', 6, 31),
	(187, 'The Council adds value to the reviews of the mission, vision and strategic objectives submitted by the university administration', 'rating', '', 'normal', 6, 31),
	(188, 'The duties and responsibilities of the Council and executive are clearly stated.', 'rating', '', 'normal', 6, 31),
	(189, 'The Council has necessary information to undertake effective decision making and actions', 'rating', '', 'normal', 6, 31),
	(190, 'Issues that come before the council framed in a way  that enables members to see the connections between the matter at hand and the University overall strategy', 'rating', '', 'normal', 6, 31),
	(191, 'Ethical and governance standards are clearly stated and complied with', 'rating', '', 'normal', 6, 31),
	(192, 'The skills and experience of Council members is sufficient', 'rating', '', 'normal', 6, 31),
	(193, 'The council does an adequate job of evaluating the performance of the top managers against predetermined criteria', 'rating', '', 'normal', 6, 31),
	(194, 'Selection and appointment procedures in place for all Members of the Council are adequate ', 'rating', '', 'normal', 6, 31),
	(195, 'Serving the Council is rewarding and satisfying experience', 'rating', '', 'normal', 6, 31),
	(196, 'Council is the right size', 'rating', '', 'normal', 6, 32),
	(197, 'The committee structure is satisfactory', 'rating', '', 'normal', 6, 32),
	(198, 'Council Committees add value to the University', 'rating', '', 'normal', 6, 32),
	(199, 'Committee communication with the Council is satisfactory', 'rating', '', 'normal', 6, 32),
	(200, 'Members ask appropriate questions of the Committees', 'rating', '', 'normal', 6, 32),
	(201, 'The Council is sufficiently independent  of the University management', 'rating', '', 'normal', 6, 32),
	(202, 'Council members ask appropriate questions of management', 'rating', '', 'normal', 6, 32),
	(203, 'Major stakeholders evaluation of the performance of the Council is undertaken periodically', 'rating', '', 'normal', 6, 32),
	(204, 'Individual members of Council maintain channels of communication with specific key community leaders', 'rating', '', 'normal', 6, 32),
	(205, 'There are adequate opportunities for informal discussion among Council members', 'rating', '', 'normal', 6, 32),
	(206, 'Differences of opinion in council decisions are more often settled by vote than by more discussion', 'rating', '', 'normal', 6, 32),
	(207, 'The Council operates as an effective team', 'rating', '', 'normal', 6, 32),
	(208, 'There is open and frank discussion', 'rating', '', 'normal', 6, 32),
	(209, 'I have attended Council meetings where explicit attention was given to the concerns of the local community', 'rating', '', 'normal', 6, 32),
	(210, 'The council collects information on the morale of staff', 'rating', '', 'normal', 6, 32),
	(211, 'Orientation programmes for new Council members specifically  include a segment about the university?s history and tradition', 'rating', '', 'normal', 6, 32),
	(212, 'The council fosters an appropriate corporate culture', 'rating', '', 'normal', 6, 32),
	(213, 'Other Council members have important information that I lack on key issues', 'rating', '', 'normal', 6, 32),
	(214, 'The Council communicates its decisions  to all those who are  affected by them adequately', 'rating', '', 'normal', 6, 32),
	(215, 'I am able to speak my mind on key issues without fear that I will be ostracised by some members of the Council', 'rating', '', 'normal', 6, 32),
	(216, 'I am able to speak my mind on key issues without fear that I will be obstructed by some members of the council', 'rating', '', 'normal', 6, 32),
	(217, 'There is at least as much dialogue among council members as there is between members and administration', 'rating', '', 'normal', 6, 32),
	(218, 'The council acts with care and diligence', 'rating', '', 'normal', 6, 33),
	(219, 'The Council adequately monitors financial reports and understands whether the University is performing as projected', 'rating', '', 'normal', 6, 33),
	(220, 'The Council has an adequate code of conduct', 'rating', '', 'normal', 6, 33),
	(221, 'The Council identifies and addresses risks faced by the University', 'rating', '', 'normal', 6, 33),
	(222, 'The Council adequately documents  the current government practices', 'rating', '', 'normal', 6, 33),
	(223, 'The Council explicitly examines the possible pitfalls of any important  decision it may take ', 'rating', '', 'normal', 6, 33),
	(224, 'The council adequately informs members of activities', 'rating', '', 'normal', 6, 33),
	(225, 'Systems are in place for asset management , ensuring efficiency  and minimising costs ', 'rating', '', 'normal', 6, 33),
	(226, 'Adequate procedure are in place for council?s approval of remuneration of Principal Officers ', 'rating', '', 'normal', 6, 33),
	(227, 'Recommendations from the administration are usually accepted with little questioning in Council Meetings ', 'rating', '', 'normal', 6, 33),
	(228, 'Members obtain independent advice when required', 'rating', '', 'normal', 6, 33),
	(229, 'The financial reports meet International Accounting Standards', 'rating', '', 'normal', 6, 34),
	(230, 'Procedures are in place to ensure compliance with legal and other regulations', 'rating', '', 'normal', 6, 34),
	(231, 'Council activities are transparent and open', 'rating', '', 'normal', 6, 34),
	(232, 'Financial controls are adequate  for effective operation of the organisation', 'rating', '', 'normal', 6, 34),
	(233, 'Adequate controls cover fraud, risk management and contract performance', 'rating', '', 'normal', 6, 34),
	(234, 'The whistleblowing procedure for reporting breaches of policy ,rules and government failures', 'rating', '', 'normal', 6, 34),
	(235, 'The council monitors compliance with its policies', 'rating', '', 'normal', 6, 34),
	(236, 'The vision, mission and priorities of the University are clearly articulated and understood by Members of Council', 'rating', '', 'normal', 6, 35),
	(237, 'Values are discussed explicitly at Council meetings', 'rating', '', 'normal', 6, 35),
	(238, 'The Council is decisive, action oriented and gets things done', 'rating', '', 'normal', 6, 35),
	(239, 'Council and Committee meetings are productive', 'rating', '', 'normal', 6, 35),
	(240, 'Council meetings tend to focus more on current concerns than on preparing for the future', 'rating', '', 'normal', 6, 35),
	(241, 'Members stay abreast of issues and trends  and bring that information to the Council', 'rating', '', 'normal', 6, 35),
	(242, 'The Council?s objectives for the past 12months were achieved', 'rating', '', 'normal', 6, 35),
	(243, 'The Council often discusses where the university should be headed in 5 or more years into the future', 'rating', '', 'normal', 6, 35),
	(244, 'I have participated in Council discussions about our performance', 'rating', '', 'normal', 6, 35),
	(245, 'Council evaluates the performance of the Vice-Chancellor and other Principal Officers', 'rating', '', 'normal', 6, 35),
	(246, 'Council goals, expectations are honestly communicated to the University Management', 'rating', '', 'normal', 6, 35),
	(247, 'The Council benchmarks its performance against other institutions', 'rating', '', 'normal', 6, 35),
	(248, 'The Council regularly Evaluates its own performance', 'rating', '', 'normal', 6, 35),
	(249, 'The Council meets high ethical standards', 'rating', '', 'normal', 6, 35),
	(250, 'Council Members receive timely agenda and minutes', 'rating', '', 'normal', 6, 36),
	(251, 'Meetings are productive', 'rating', '', 'normal', 6, 36),
	(252, 'There are sufficient meetings', 'rating', '', 'normal', 6, 36),
	(253, 'Council meetings are conducted in a way that ensures open communication, meaningful participation, and timely resolution of issues', 'rating', '', 'normal', 6, 36),
	(254, 'Council members act as a team', 'rating', '', 'normal', 6, 36),
	(255, 'Council members respect the confidentiality of Council discussions', 'rating', '', 'normal', 6, 36),
	(256, 'Council members prepare well for meetings', 'rating', '', 'normal', 6, 36),
	(262, 'Advising student government organisations ', 'rating', '', 'normal', 3, 38),
	(263, 'Designing and carrying out student leadership development programmes ', 'rating', '', 'normal', 3, 38),
	(264, 'Advising student social clubs and organisations ', 'rating', '', 'normal', 3, 38),
	(265, 'Encouraging student involvement in community service/volunteer activities ', 'rating', '', 'normal', 3, 38),
	(266, 'Providing an aesthetically pleasing environment in which students and staff can interact while pursuing their educational goals ', 'rating', '', 'normal', 3, 39),
	(267, 'Seeking to maintain a safe environment for pedestrian and vehicular traffic on sidewalks, streets and in parking lots ', 'rating', '', 'normal', 3, 39),
	(268, 'Striving for excellence in landscaping ', 'rating', '', 'normal', 3, 39),
	(269, 'Providing facilities for students to worship and share their religious customs and ideas ', 'rating', '', 'normal', 3, 40),
	(270, 'Organizing interfaith or ecumenical services ', 'rating', '', 'normal', 3, 40),
	(271, 'Counselling students seeking spiritual guidance ', 'rating', '', 'normal', 3, 40),
	(272, 'Organising or making available appropriate liturgies and ceremonies to satisfy the spiritual needs of students ', 'rating', '', 'normal', 3, 40),
	(273, 'Providing spiritual support and counselling, individually and in groups, to those in personal crisis ', 'rating', '', 'normal', 3, 40),
	(274, 'In multi-faith settings, co-ordinating the activities and events of the various religious communities ', 'rating', '', 'normal', 3, 40),
	(275, 'Organising events and activities promoting spiritual life on campus ', 'rating', '', 'normal', 3, 40),
	(276, 'Acting as the first point of campus contact for all faith groups ', 'rating', '', 'normal', 3, 40),
	(277, 'Arranging services relevant to the chaplain?s own faith ', 'rating', '', 'normal', 3, 40),
	(278, 'Facilitating services for other faith groups by inviting their leaders on campus ', 'rating', '', 'normal', 3, 40),
	(279, 'Encouraging both specific faith-based and inter-faith dialogue by organising social events and discussion groups ', 'rating', '', 'normal', 3, 40),
	(280, 'Being responsible for the use of the multi-faith centre and helping students find appropriate rooms for religious activities ', 'rating', '', 'normal', 3, 40),
	(281, 'Engaging in brief individual psychotherapy, crisis intervention, couples counselling, group psychotherapy, behaviour modification and medication therapy, as needed ', 'rating', '', 'normal', 3, 41),
	(282, 'Selectively employing various modalities in combination into individualised treatment programmes for student clients ', 'rating', '', 'normal', 3, 41),
	(283, 'Offering programmes for the promotion of a healthier campus environment ', 'rating', '', 'normal', 3, 41),
	(284, 'Operating a confidential, after-hours telephone help-line/referral service to assist students in crisis when no face-to-face counselling is available ', 'rating', '', 'normal', 3, 41),
	(285, 'Conducting group counselling programmes on common themes ', 'rating', '', 'normal', 3, 41),
	(286, 'Participating in student induction and welcoming programmes ', 'rating', '', 'normal', 3, 41),
	(287, 'Providing developmental and preventative workshops throughout the academic year in response to student needs including such examples as assertiveness training, stress management, support for adult students, and time management ', 'rating', '', 'normal', 3, 41),
	(288, 'Offering liaison and consultancy to tutors and others concerned about a particular student?s personal or academic situation ', 'rating', '', 'normal', 3, 41),
	(289, 'Offering a relevant programme of professional development workshops, conferences, and activities for tutorial and counselling staff and student services colleagues related to good practice in providing support for students ', 'rating', '', 'normal', 3, 41),
	(290, 'Contributing to institutional, faculty and departmental planning, policy and developments through participation in University committees and work-groups ', 'rating', '', 'normal', 3, 41),
	(291, 'Offering feedback to University staff on factors that promote or hinder learning ', 'rating', '', 'normal', 3, 41),
	(292, 'Continuously monitoring and evaluating the work of the counselling service through identified quality assurance systems and client research ', 'rating', '', 'normal', 3, 41),
	(293, 'Serving as an office and mediator that assists students with disabilities in acquiring classroom and other accommodation as necessary ', 'rating', '', 'normal', 3, 42),
	(294, 'Ensuring that students with disabilities have equal access to all areas, including libraries, food service, computer laboratories and other technology areas and facilities ', 'rating', '', 'normal', 3, 42),
	(295, 'Informing and making the campus community aware of the need to include students with disabilities in all programmes, services and activities ', 'rating', '', 'normal', 3, 42),
	(296, 'Acting as an agent to inform the community about access issues ', 'rating', '', 'normal', 3, 42),
	(297, 'Arranging for interpreters or signers for deaf students ', 'rating', '', 'normal', 3, 42),
	(298, 'Arranging for note-takers, readers and volunteer books-on-tape readers ', 'rating', '', 'normal', 3, 42),
	(299, 'Arranging for appropriate alternative student academic assessment and examination methodologies ', 'rating', '', 'normal', 3, 42),
	(300, 'Assisting students in acquiring alternative formats of classroom materials (Braille, audio textbooks, large print text) ', 'rating', '', 'normal', 3, 42),
	(301, 'Providing individual counselling and assistance for disabled students until they graduate ', 'rating', '', 'normal', 3, 42),
	(302, 'Providing leadership in assessing existing and new spaces/facilities to determine compliance with accessibility criteria and standards set by government units and the University ', 'rating', '', 'normal', 3, 42),
	(303, 'Serving as an advisor/counsellor for international students ', 'rating', '', 'normal', 3, 43),
	(304, 'Providing one-to-one support to individual international students in crisis ', 'rating', '', 'normal', 3, 43),
	(305, 'Developing appropriate procedures to recruit international students ', 'rating', '', 'normal', 3, 43),
	(306, 'Providing accurate information and instruction regarding immigration regulations for international students and scholars ', 'rating', '', 'normal', 3, 43),
	(307, 'Providing pre-arrival information packages for international students and pre-departure information for students going abroad ', 'rating', '', 'normal', 3, 43),
	(308, 'Ensuring there is an appropriate level of housing for international students ', 'rating', '', 'normal', 3, 43),
	(309, 'Providing visa and immigration assistance ', 'rating', '', 'normal', 3, 43),
	(310, 'Organising living arrangements and activities that bring domestic and international students together in the same facilities ', 'rating', '', 'normal', 3, 43),
	(311, 'Developing social, cultural and educational support services ', 'rating', '', 'normal', 3, 43),
	(312, 'Identifying and administering financial assistance for international students ', 'rating', '', 'normal', 3, 43),
	(313, 'Providing individual and personal support services for international students in their adjustment to the host country culture ', 'rating', '', 'normal', 3, 43),
	(314, 'Ensuring that institutional obligations to students and the legal structure are fulfilled in relation to health insurance ', 'rating', '', 'normal', 3, 43),
	(315, 'Supporting and encouraging the development of international activities, programmes and events for the general campus community ', 'rating', '', 'normal', 3, 43),
	(316, 'Working with staff in understanding cultures and assisting with the adjustment of international students ', 'rating', '', 'normal', 3, 43),
	(317, 'Developing host family and mentoring activities and programmes as appropriate ', 'rating', '', 'normal', 3, 43),
	(318, 'Establishing and managing an orientation and induction programme for newly arrived students including help in the areas of housing, academic registration, and general knowledge of the institutional environment ', 'rating', '', 'normal', 3, 43),
	(319, 'Assisting international students/scholars in the transition to living, learning, and working in the domestic setting ', 'rating', '', 'normal', 3, 43),
	(320, 'Organising various social and cultural activities designed to inform and engage the community in the process of learning about other cultures ', 'rating', '', 'normal', 3, 43),
	(321, 'Creating and managing a resource centre on host country integration issues ', 'rating', '', 'normal', 3, 43),
	(322, 'Supporting student groups in their promotion of various cultures ', 'rating', '', 'normal', 3, 43),
	(323, 'Organising workshops or activities on the understanding of different cultures ', 'rating', '', 'normal', 3, 43),
	(324, 'Working with educational leaders to develop recruiting programmes for potential students and various accessibility support mechanisms to facilitate transition to higher education in a foreign country ', 'rating', '', 'normal', 3, 43),
	(325, 'Providing individual and group discussions on issues facing international students including immigration, funding and other personal concerns ', 'rating', '', 'normal', 3, 43),
	(326, 'Developing staff and student training programmes that encourage more understanding of the cross-culture issues for international students ', 'rating', '', 'normal', 3, 43),
	(327, 'Advising staff on issues relating to international students ', 'rating', '', 'normal', 3, 43),
	(328, 'Researching key issues which relate to the experience of international students and their interface with the university and the community at large ', 'rating', '', 'normal', 3, 43),
	(329, 'Reporting on findings of research and increasing awareness of significant issues raised by research into international students? experiences ', 'rating', '', 'normal', 3, 43),
	(330, 'Explaining the overall purpose of higher education and how this general purpose translates to the institution they are attending ', 'rating', '', 'normal', 3, 44),
	(331, 'Explaining academic/support staff and student roles, responsibilities and expectations ', 'rating', '', 'normal', 3, 44),
	(332, 'Describing the expectations of students with regard to scholarship, integrity, conduct, finan?cial obligations, and ethical use of technology ', 'rating', '', 'normal', 3, 44),
	(333, 'Providing information clarifying relevant administrative policies and procedures ', 'rating', '', 'normal', 3, 44),
	(334, 'Explaining class scheduling and registration processes and providing assistance from quali?fied staff, or peer academic advisors for developing educational plans ', 'rating', '', 'normal', 3, 44),
	(335, 'Assisting students in utilizing course placement examinations, interest inventories, and study skills assessments in selecting a major and appropriate course ', 'rating', '', 'normal', 3, 44),
	(336, 'Identifying appropriate referral resources, such as counsellors and advisors, and providing information about relevant services and programmes ', 'rating', '', 'normal', 3, 44),
	(337, 'Providing new students with personal health and safety information ', 'rating', '', 'normal', 3, 44),
	(338, 'Providing social and informational programmes for parents of new students ', 'rating', '', 'normal', 3, 44),
	(339, 'Providing opportunities for new students to interact with academic and support staff ', 'rating', '', 'normal', 3, 44),
	(340, 'Providing information about the physical layout of the campus including the location of key offices and functions ', 'rating', '', 'normal', 3, 44),
	(341, 'Providing opportunities for new students to interact with continuing students to develop a sense of identification with and belonging to the institution ', 'rating', '', 'normal', 3, 44),
	(342, 'Attending to needs of sub-groups of students, e.g. students with disabilities, athletes, adult, multi-cultural and international students ', 'rating', '', 'normal', 3, 44),
	(343, 'Employing a diverse staff to reflect the diversity of the campus student population, to ensure the existence of identifiable role models for students that enrich the campus community ', 'rating', '', 'normal', 3, 44),
	(344, 'Co-ordinating recreational programming, facilities and equipment ', 'rating', '', 'normal', 3, 45),
	(345, 'Supervising all campus recreational programmes and services ', 'rating', '', 'normal', 3, 45),
	(346, 'Providing informal programmes for self-directed, individualised involvement to meet stu?dents? desires to participate in sport for personal fitness and enjoyment ', 'rating', '', 'normal', 3, 45),
	(347, 'Organizing intramural sports to provide structured contests, tournaments and leagues, limit?ing participation to campus members ', 'rating', '', 'normal', 3, 45),
	(348, 'Offering sport clubs that provide opportunities for individuals to organise around a common interest in a sport within or outside the institution ', 'rating', '', 'normal', 3, 45),
	(349, 'Providing instructional programmes for learning opportunities, knowledge, and skills through lessons, clinics and workshops ', 'rating', '', 'normal', 3, 45),
	(350, 'Organising special events, either within or outside the institution, to introduce new sport or related activities that are unique in approach or nature from traditional programmes ', 'rating', '', 'normal', 3, 45),
	(351, 'Developing fitness programmes that provide opportunities and assistance to students and others in carrying out their personal exercise programmes ', 'rating', '', 'normal', 3, 45),
	(352, 'Developing recreation programmes ', 'rating', '', 'normal', 3, 45),
	(353, 'Providing health promotion and well-being programmes ', 'rating', '', 'normal', 3, 45),
	(354, 'Organising extramural sports that provide structured tournaments, contests and meets among participants from other institutions ', 'rating', '', 'normal', 3, 45),
	(355, 'Offering family and youth programmes for members of the campus community ', 'rating', '', 'normal', 3, 45),
	(356, 'Developing recreation sports programmes for persons with disabilities ', 'rating', '', 'normal', 3, 45),
	(357, 'Managing the recreation and athletic facilities of the University ', 'rating', '', 'normal', 3, 45),
	(358, 'Encouraging programme staff to serve as resources to the community, providing expert advice on recreational issues and activities ', 'rating', '', 'normal', 3, 45),
	(359, 'Providing recreational activities for students including weight training, exercise and fitness centres, jogging/walking courses, tennis/golf/squash courts, etc. ', 'rating', '', 'normal', 3, 45),
	(360, 'Explaining the unit?s role through new student/parent orientation programmes ', 'rating', '', 'normal', 3, 46),
	(361, 'Training all staff members responsible for the administration of the disciplinary process ', 'rating', '', 'normal', 3, 46),
	(362, 'Conducting educational programmes for students in the residence halls and student organisations about the disciplinary process upon request ', 'rating', '', 'normal', 3, 46),
	(363, 'Sanctioning students responsible for misconduct through a responsible university hearing panel comprised of students and University staff ', 'rating', '', 'normal', 3, 46),
	(364, 'Advising students on their options in the disciplinary process ', 'rating', '', 'normal', 3, 46),
	(365, 'Administering a database that includes disposition and records of the involvement of guilty students in misconduct cases ', 'rating', '', 'normal', 3, 46),
	(366, 'Designing appropriate sanctions to educate students on their behaviour risks ', 'rating', '', 'normal', 3, 46),
	(367, 'Implementing sanctions by acquiring the expertise to do so or seeking individuals that possess the expertise ', 'rating', '', 'normal', 3, 46),
	(368, 'Holding students accountable for completing their educational sanctions by assigning additional sanctions to students that failed to complete them ', 'rating', '', 'normal', 3, 46),
	(369, 'Conducting mediation sessions ', 'rating', '', 'normal', 3, 46),
	(370, 'Providing statistics on student judicial actions to local and student media ', 'rating', '', 'normal', 3, 46),
	(371, 'Administering all budgets involved in the implementation of mediation and substance abuse programmes ', 'rating', '', 'normal', 3, 46),
	(372, 'Planning and carrying out study and recreational activities in the residence halls including quiet periods for study ', 'rating', '', 'normal', 3, 47),
	(373, 'Co-ordinating academic advising, career planning, time management, and instructional activities within the housing and other units as appropriate and in coordination with various academic and other units within the institution ', 'rating', '', 'normal', 3, 47),
	(374, 'Offering a variety of living options including individual, group, undergraduate, postgraduate, disability, first year, and other options ', 'rating', '', 'normal', 3, 47),
	(375, 'Providing mentoring and student development programmes ', 'rating', '', 'normal', 3, 47),
	(376, 'Advising residence hall governments and student organisations ', 'rating', '', 'normal', 3, 47),
	(377, 'Providing staff training and development support ', 'rating', '', 'normal', 3, 47),
	(378, 'Hiring and training students to become resident assistants, peer assistants and resident advisors to their peers in a live-in environment ', 'rating', '', 'normal', 3, 47),
	(379, 'Conducting student misconduct disciplinary hearings in cases that originate in student housing ', 'rating', '', 'normal', 3, 47),
	(380, 'Offering off-session housing options for conferences, workshops and camps ', 'rating', '', 'normal', 3, 47),
	(381, 'Conducting research on students living in on-campus housing ', 'rating', '', 'normal', 3, 47),
	(382, 'Obtaining students? experiences that include all areas of their lives on campus from counselling, the quality of their accommodation, sports and recreation, discipline, to their financial situations, among other things ', 'rating', '', 'normal', 3, 48),
	(383, 'How do you understand your lecturer?', 'rating', '', 'normal', 0, 49),
	(384, 'How good is the teaching methods of your teacher?', 'rating', '', 'normal', 0, 49),
	(387, 'Did your Lecturer teacher all courses', 'rating', '', 'normal', 13, 53);

-- Dumping structure for table quad.5x_resp_2020
CREATE TABLE IF NOT EXISTS `5x_resp_2020` (
  `resp_id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(5) NOT NULL,
  `surveyee_id` bigint(15) NOT NULL,
  `study_yr` tinyint(1) NOT NULL,
  `study_sem` tinyint(1) NOT NULL,
  `course_id` varchar(10) NOT NULL,
  `lecturer_id` int(11) NOT NULL,
  `su_id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `block_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  `thread_type` varchar(10) NOT NULL,
  `remarks` varchar(250) NOT NULL,
  `date` varchar(11) NOT NULL,
  PRIMARY KEY (`resp_id`)
) ENGINE=MyISAM AUTO_INCREMENT=182 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.5x_resp_2020: 181 rows
INSERT INTO `5x_resp_2020` (`resp_id`, `role`, `surveyee_id`, `study_yr`, `study_sem`, `course_id`, `lecturer_id`, `su_id`, `cat_id`, `block_id`, `thread_id`, `thread_type`, `remarks`, `date`) VALUES
	(1, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 1, 'rating', '100', '1595311187'),
	(2, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 2, 'rating', '100', '1595311208'),
	(3, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 3, 'rating', '100', '1595311216'),
	(4, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 4, 'rating', '75', '1595311220'),
	(5, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 5, 'rating', '100', '1595311224'),
	(6, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 6, 'rating', '100', '1595311229'),
	(7, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 7, 'rating', '75', '1595311234'),
	(8, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 8, 'rating', '100', '1595311240'),
	(9, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 9, 'rating', '75', '1595311248'),
	(10, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 10, 'rating', '100', '1595311251'),
	(11, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 11, 'rating', '75', '1595311255'),
	(12, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 1, 12, 'rating', '100', '1595311679'),
	(13, 'STD', 1800401948, 1, 1, 'SCS101', 4, 1, 1, 2, 13, 'rating', '100', '1595311686'),
	(14, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 38, 262, 'rating', '75', '1595341752'),
	(15, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 38, 263, 'rating', '50', '1595341802'),
	(16, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 38, 264, 'rating', '100', '1595341821'),
	(17, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 38, 265, 'rating', '25', '1595341862'),
	(18, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 39, 266, 'rating', '100', '1595341897'),
	(19, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 39, 267, 'rating', '0', '1595341912'),
	(20, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 39, 268, 'rating', '25', '1595341922'),
	(21, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 269, 'rating', '75', '1595341933'),
	(22, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 270, 'rating', '50', '1595341942'),
	(23, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 271, 'rating', '75', '1595341954'),
	(24, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 272, 'rating', '75', '1595341977'),
	(25, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 273, 'rating', '75', '1595341986'),
	(26, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 274, 'rating', '50', '1595341988'),
	(27, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 275, 'rating', '25', '1595341992'),
	(28, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 276, 'rating', '100', '1595341999'),
	(29, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 277, 'rating', '50', '1595342002'),
	(30, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 278, 'rating', '0', '1595342009'),
	(31, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 279, 'rating', '100', '1595342014'),
	(32, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 40, 280, 'rating', '50', '1595342026'),
	(33, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 281, 'rating', '25', '1595342032'),
	(34, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 282, 'rating', '100', '1595342043'),
	(35, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 283, 'rating', '50', '1595342046'),
	(36, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 284, 'rating', '0', '1595342050'),
	(37, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 285, 'rating', '75', '1595342062'),
	(38, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 286, 'rating', '25', '1595342067'),
	(39, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 287, 'rating', '100', '1595342072'),
	(40, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 288, 'rating', '50', '1595342077'),
	(41, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 289, 'rating', '25', '1595342079'),
	(42, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 290, 'rating', '75', '1595342081'),
	(43, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 291, 'rating', '100', '1595342086'),
	(44, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 41, 292, 'rating', '0', '1595342087'),
	(45, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 293, 'rating', '25', '1595342090'),
	(46, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 294, 'rating', '50', '1595342092'),
	(47, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 295, 'rating', '50', '1595342103'),
	(48, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 296, 'rating', '75', '1595342111'),
	(49, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 297, 'rating', '25', '1595342117'),
	(50, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 298, 'rating', '75', '1595342119'),
	(51, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 299, 'rating', '50', '1595342121'),
	(52, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 300, 'rating', '100', '1595342123'),
	(53, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 301, 'rating', '75', '1595342126'),
	(54, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 42, 302, 'rating', '50', '1595342127'),
	(55, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 303, 'rating', '25', '1595342129'),
	(56, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 304, 'rating', '100', '1595342132'),
	(57, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 305, 'rating', '75', '1595342134'),
	(58, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 306, 'rating', '100', '1595342138'),
	(59, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 307, 'rating', '50', '1595342142'),
	(60, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 308, 'rating', '75', '1595342156'),
	(61, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 309, 'rating', '100', '1595342158'),
	(62, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 310, 'rating', '25', '1595342161'),
	(63, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 311, 'rating', '0', '1595342163'),
	(64, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 312, 'rating', '100', '1595342166'),
	(65, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 313, 'rating', '50', '1595342168'),
	(66, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 314, 'rating', '100', '1595342171'),
	(67, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 315, 'rating', '0', '1595342173'),
	(68, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 316, 'rating', '25', '1595342175'),
	(69, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 317, 'rating', '75', '1595342177'),
	(70, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 318, 'rating', '100', '1595342180'),
	(71, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 319, 'rating', '50', '1595342182'),
	(72, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 320, 'rating', '25', '1595342184'),
	(73, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 321, 'rating', '50', '1595342186'),
	(74, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 322, 'rating', '100', '1595342190'),
	(75, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 323, 'rating', '75', '1595342192'),
	(76, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 324, 'rating', '50', '1595342195'),
	(77, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 325, 'rating', '25', '1595342197'),
	(78, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 326, 'rating', '0', '1595342199'),
	(79, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 327, 'rating', '100', '1595342209'),
	(80, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 328, 'rating', '50', '1595342218'),
	(81, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 43, 329, 'rating', '75', '1595342221'),
	(82, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 330, 'rating', '75', '1595342237'),
	(83, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 331, 'rating', '50', '1595342247'),
	(84, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 332, 'rating', '0', '1595342251'),
	(85, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 333, 'rating', '75', '1595342278'),
	(86, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 334, 'rating', '25', '1595342280'),
	(87, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 335, 'rating', '100', '1595342282'),
	(88, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 336, 'rating', '50', '1595342285'),
	(89, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 337, 'rating', '50', '1595342288'),
	(90, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 338, 'rating', '25', '1595342292'),
	(91, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 339, 'rating', '0', '1595342295'),
	(92, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 340, 'rating', '100', '1595342297'),
	(93, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 341, 'rating', '75', '1595342299'),
	(94, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 342, 'rating', '50', '1595342300'),
	(95, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 44, 343, 'rating', '25', '1595342302'),
	(96, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 344, 'rating', '75', '1595342304'),
	(97, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 345, 'rating', '100', '1595342306'),
	(98, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 346, 'rating', '25', '1595342310'),
	(99, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 347, 'rating', '100', '1595342313'),
	(100, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 348, 'rating', '0', '1595342316'),
	(101, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 349, 'rating', '100', '1595342318'),
	(102, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 350, 'rating', '75', '1595342320'),
	(103, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 351, 'rating', '50', '1595342322'),
	(104, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 352, 'rating', '25', '1595342324'),
	(105, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 353, 'rating', '50', '1595342326'),
	(106, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 354, 'rating', '100', '1595342328'),
	(107, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 355, 'rating', '75', '1595342330'),
	(108, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 356, 'rating', '25', '1595342332'),
	(109, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 357, 'rating', '0', '1595342335'),
	(110, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 358, 'rating', '75', '1595342337'),
	(111, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 45, 359, 'rating', '100', '1595342339'),
	(112, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 360, 'rating', '50', '1595342341'),
	(113, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 361, 'rating', '75', '1595342342'),
	(114, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 362, 'rating', '100', '1595342344'),
	(115, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 363, 'rating', '75', '1595342345'),
	(116, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 364, 'rating', '50', '1595342347'),
	(117, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 365, 'rating', '25', '1595342348'),
	(118, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 366, 'rating', '0', '1595342350'),
	(119, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 367, 'rating', '100', '1595342352'),
	(120, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 368, 'rating', '75', '1595342354'),
	(121, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 369, 'rating', '50', '1595342355'),
	(122, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 370, 'rating', '25', '1595342357'),
	(123, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 46, 371, 'rating', '0', '1595342359'),
	(124, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 372, 'rating', '100', '1595342361'),
	(125, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 373, 'rating', '75', '1595342363'),
	(126, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 374, 'rating', '50', '1595342364'),
	(127, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 375, 'rating', '25', '1595342366'),
	(128, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 376, 'rating', '0', '1595342368'),
	(129, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 377, 'rating', '100', '1595342370'),
	(130, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 378, 'rating', '75', '1595342371'),
	(131, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 379, 'rating', '50', '1595342373'),
	(132, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 380, 'rating', '25', '1595342375'),
	(133, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 47, 381, 'rating', '100', '1595342377'),
	(134, 'STD', 1800402313, 1, 1, '0', 0, 3, 1, 48, 382, 'rating', '25', '1595342379'),
	(135, 'STD', 1800402313, 1, 1, 'SCS102', 2, 2, 1, 37, 257, 'answer', '1', '1595343128'),
	(136, 'STD', 1800402313, 1, 1, 'SCS102', 2, 2, 1, 37, 258, 'answer', '20/07/2020', '1595343270'),
	(137, 'STD', 1800402313, 1, 1, 'SCS102', 2, 2, 1, 37, 259, 'answer', '2hours', '1595343304'),
	(138, 'STD', 1800402313, 1, 1, 'SCS102', 2, 2, 1, 37, 260, 'answer', '2 hours', '1595343322'),
	(139, 'STD', 1800402313, 1, 1, 'SCS102', 2, 2, 1, 37, 261, 'answer', 'Light', '1595343333'),
	(140, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 84, 'rating', '100', '1596450769'),
	(141, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 85, 'rating', '75', '1596450775'),
	(142, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 86, 'rating', '50', '1596450779'),
	(143, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 87, 'rating', '25', '1596450789'),
	(144, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 88, 'rating', '25', '1596450796'),
	(145, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 89, 'rating', '25', '1596450798'),
	(146, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 90, 'rating', '25', '1596450804'),
	(147, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 91, 'rating', '50', '1596450808'),
	(148, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 92, 'rating', '75', '1596450825'),
	(149, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 93, 'rating', '100', '1596450834'),
	(150, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 94, 'rating', '100', '1596450836'),
	(151, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 12, 95, 'rating', '100', '1596450839'),
	(152, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 13, 96, 'rating', '100', '1596450843'),
	(153, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 13, 97, 'rating', '25', '1596450846'),
	(154, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 13, 98, 'rating', '0', '1596450852'),
	(155, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 13, 99, 'rating', '0', '1596450855'),
	(156, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 13, 100, 'rating', '50', '1596450857'),
	(157, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 13, 101, 'rating', '75', '1596450861'),
	(158, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 13, 102, 'rating', '50', '1596450865'),
	(159, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 13, 103, 'rating', '50', '1596450888'),
	(160, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 13, 104, 'rating', '50', '1596450891'),
	(161, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 14, 105, 'rating', '75', '1596450893'),
	(162, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 14, 106, 'rating', '0', '1596450896'),
	(163, 'SYST', 3, 0, 1, '0', 0, 7, 3, 18, 120, 'rating', '100', '1597181737'),
	(164, 'SYST', 3, 0, 1, '0', 0, 7, 3, 18, 121, 'rating', '75', '1597181754'),
	(165, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 14, 107, 'rating', '100', '1597184701'),
	(166, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 14, 108, 'rating', '75', '1597184722'),
	(167, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 15, 109, 'rating', '75', '1597184725'),
	(168, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 15, 110, 'rating', '75', '1597184733'),
	(169, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 15, 111, 'rating', '75', '1597184735'),
	(170, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 16, 112, 'rating', '75', '1597184738'),
	(171, 'STD', 1800402209, 1, 1, '0', 0, 4, 2, 16, 113, 'rating', '75', '1597184741'),
	(172, 'STD', 1900403002, 1, 1, '0', 0, 3, 1, 38, 262, 'rating', '100', '1597215937'),
	(173, 'STD', 1900403002, 1, 1, '0', 0, 3, 1, 38, 263, 'rating', '75', '1597215940'),
	(174, 'STD', 1900403002, 1, 1, '0', 0, 3, 1, 38, 264, 'rating', '50', '1597215945'),
	(175, 'STD', 1900403002, 1, 1, '0', 0, 4, 2, 12, 84, 'rating', '75', '1597239666'),
	(176, 'STD', 1900403002, 1, 1, '0', 0, 4, 2, 12, 85, 'rating', '50', '1597239670'),
	(177, 'STD', 1900403002, 1, 1, '0', 0, 4, 2, 12, 86, 'rating', '25', '1597239673'),
	(178, 'STD', 1900403002, 1, 1, '0', 0, 4, 2, 12, 87, 'rating', '100', '1597239677'),
	(179, 'LEC', 25, 0, 1, '0', 0, 7, 3, 18, 120, 'rating', '100', '1597239878'),
	(180, 'STD', 1900403002, 1, 1, '0', 0, 4, 2, 12, 88, 'rating', '100', '1597304951'),
	(181, 'STD', 1900403002, 1, 1, '0', 0, 4, 2, 12, 89, 'rating', '50', '1597304958');

-- Dumping structure for table quad.6a_course
CREATE TABLE IF NOT EXISTS `6a_course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `courseID` varchar(5) NOT NULL,
  `courseName` varchar(150) NOT NULL,
  `level` varchar(3) NOT NULL,
  `facultyID` varchar(5) NOT NULL,
  `duration` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `facultyID` (`facultyID`),
  KEY `courseID` (`courseID`),
  KEY `level` (`level`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

-- Dumping data for table quad.6a_course: ~46 rows (approximately)
INSERT INTO `6a_course` (`id`, `courseID`, `courseName`, `level`, `facultyID`, `duration`) VALUES
	(1, 'ELS', 'BACHELOR OF EDUCATION LANGUAGES (ENGLISH & LITERATURE IN ENGLISH)', 'DEG', 'FSE', 3),
	(2, 'BEP', 'BACHELOR OF EDUCATION PRIMARY', 'DEG', 'FSE', 3),
	(3, 'BTI', 'BACHELOR OF INFORMATION TECHNOLOGY', 'DEG', 'FSE', 3),
	(4, 'SCE', 'BACHELOR OF SCIENCE EDUCATION', 'DEG', 'FSE', 3),
	(5, 'SCS', 'BACHELOR OF SCIENCE IN COMPUTER SCIENCE', 'DEG', 'FSE', 3),
	(6, 'BEP', 'DIPLOMA IN EDUCATION PRIMARY', 'DIP', 'FSE', 2),
	(7, 'SLB', 'DIPLOMA IN SCIENCE LABORATORY TECHNOLOGY (BIOLOGY)', 'DIP', 'FSE', 2),
	(8, 'SLC', 'DIPLOMA IN SCIENCE LABORATORY TECHNOLOGY (CHEMISTRY)', 'DIP', 'FSE', 2),
	(9, 'HBA', 'HIGHER EDUCATION ACCESS CERTIFICATE IN BIOLOGY AND AGRICULTURE', 'CER', 'FSE', 1),
	(10, 'HBC', 'HIGHER EDUCATION ACCESS CERTIFICATE IN BIOLOGY AND CHEMISTRY', 'CER', 'FSE', 1),
	(11, 'HEL', 'HIGHER EDUCATION ACCESS CERTIFICATE IN ENGLISH LANGUAGE AND LITERATURE IN ENGLISH', 'CER', 'FSE', 1),
	(12, 'HMC', 'HIGHER EDUCATION ACCESS CERTIFICATE IN MATHEMATICS  AND CHEMISTRY', 'CER', 'FSE', 1),
	(13, 'HPM', 'HIGHER EDUCATION ACCESS CERTIFICATE IN PHYSICS AND MATHEMATICS', 'CER', 'FSE', 1),
	(14, 'MEM', 'MASTER OF EDUCATIONAL LEADERSHIP AND MANAGEMENT', 'MST', 'FSE', 2),
	(15, 'MIM', 'MASTER OF SCIENCE IN INDUSTRIAL MATHEMATICS', 'MST', 'FSE', 2),
	(16, 'MSP', 'MASTER OF SCIENCE IN PHYSICS', 'MST', 'FSE', 2),
	(17, 'APE', 'BACHELOR OF SCIENCE IN AGROPROCESSING ENGINEERING', 'DEG', 'FOE', 4),
	(18, 'WAR', 'BACHELOR OF SCIENCE IN WATER RESOURCES ENGINEERING', 'DEG', 'FOE', 4),
	(19, 'BCT', 'BACHELOR OF SCIENCE IN COMPUTER ENGINEERING', 'DEG', 'FOE', 4),
	(20, 'AMI', 'BACHELOR OF SCIENCE IN AGRICULTURAL MECHANIZATION ENGINEERING', 'DEG', 'FOE', 4),
	(21, 'MEB', 'BACHELOR OF SCIENCE IN MINING ENGINEERING', 'DEG', 'FOE', 4),
	(22, 'PTI', 'BACHELOR OF SCIENCE IN INDUSTRIAL POLYMER AND TEXTILE ENGINEERING', 'DEG', 'FOE', 4),
	(23, 'MDI', 'MASTER OF DRAINAGE AND IRRIGATION ENGINEERING', 'MST', 'FOE', 2),
	(24, 'MCF', 'MASTER OF COMPUTER FORENSICS', 'MST', 'FOE', 2),
	(25, 'DAG', 'DIPLOMA IN AGRICULTURAL ENGINEERING', 'DIP', 'FOE', 2),
	(26, 'DEE', 'DIPLOMA IN ELECTRICAL AND ELECTRONICS ENGINEERING', 'DIP', 'FOE', 2),
	(27, 'DGIE', 'DIPLOMA IN GINING AND INDUSTRIAL ENGINEERING', 'DIP', 'FOE', 2),
	(28, 'DCE', 'DIPLOMA IN COMPUTER ENGINEERING', 'DIP', 'FOE', 2),
	(29, 'DCF', 'POST GRADUATE DIPLOMA IN COMPUTER FORENSICS', 'DIP', 'FOE', 2),
	(30, 'BEE', 'BACHELOR OF SCIENCE IN ELECTRICAL ENGINEERING', 'DEG', 'FOE', 4),
	(31, 'BBA', 'BACHELOR OF BUSINESS ADMINISTRATION', 'DEG', 'FMS', 3),
	(32, 'BTT', 'BACHELOR OF TOURISM AND TRAVEL MANAGEMENT', 'DEG', 'FMS', 3),
	(33, 'DBA', 'DIPLOMA IN BUSINESS ADMINISTRATION', 'DIP', 'FMS', 3),
	(34, 'DRI', 'DIPLOMA IN RECORDS & INFORMATION MANAGEMENT', 'DIP', 'FMS', 3),
	(35, 'DTT', 'DIPLOMA  OF TOURISM AND TRAVEL MANAGEMENT', 'DIP', 'FMS', 3),
	(36, 'MBA', 'MASTER OF BUSINESS ADMINISTRATION', 'MST', 'FMS', 3),
	(37, 'BPM', 'BACHELOR OF PROCUREMENT AND SUPPLY CHAIN MANAGEMENT', 'DEG', 'FMS', 3),
	(38, 'BCH', 'BACHELOR OF CATERING AND HOSPITALITY MANAGEMENT', 'DEG', 'FMS', 3),
	(39, 'EDM', 'BACHELOR  OF ENTREPRENEURSHIP  DEVELOPMENT AND  MANAGEMENT', 'DEG', 'FMS', 3),
	(40, 'DCH', 'DIPLOMA OFCATERING AND HOSPITALITY MANAGEMENT', 'DIP', 'FMS', 3),
	(41, 'MMP', 'MASTER OF MEDICINE ( PAEDIATRICS & CHILD HEALTH)', 'MST', 'FHS', 3),
	(42, 'MPH', 'MASTER OF  PUBLIC HEALTH', 'MST', 'FHS', 3),
	(43, 'MED', 'BACHELOR OF  SCIENCE IN  ANAESTHESIA', 'DEG', 'FHS', 3),
	(44, 'APM', 'BACHELOR  OF SCIENCEIN ANIMAL PRODUCTION AND MANAGEMENT (APM)', 'DEG', 'FAA', 3),
	(45, 'DAP', 'DIPLOMA IN ANIMAL PRODUCTION AND MANAGEMENT', 'DIP', 'FAA', 2),
	(46, 'DCP', 'DIPLOMA IN CROP PRODUCTION AND MANAGEMENT', 'DIP', 'FAA', 2);

-- Dumping structure for table quad.6b_course_unit
CREATE TABLE IF NOT EXISTS `6b_course_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `study_yr` tinyint(1) NOT NULL DEFAULT '1',
  `study_sem` tinyint(1) NOT NULL DEFAULT '1',
  `courseID` varchar(10) NOT NULL,
  `facultyID` varchar(5) NOT NULL,
  `deptID` int(11) NOT NULL DEFAULT '0',
  `cuID` varchar(10) NOT NULL,
  `cuName` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `deptID` (`deptID`)
) ENGINE=InnoDB AUTO_INCREMENT=505 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.6b_course_unit: ~502 rows (approximately)
INSERT INTO `6b_course_unit` (`id`, `study_yr`, `study_sem`, `courseID`, `facultyID`, `deptID`, `cuID`, `cuName`) VALUES
	(1, 1, 1, 'SCS', 'FSE', 1, 'SCS101', 'Computer Literacy'),
	(2, 1, 1, 'SCS', 'FSE', 1, 'SCS102', 'Computer Architecture'),
	(3, 1, 1, 'ELS', 'FSE', 3, 'ELS101', 'Introduction to Literature'),
	(4, 1, 1, 'ELS', 'FSE', 3, 'ELS102', 'Cognitive Writing'),
	(5, 2, 1, 'SCS', 'FSE', 1, 'SCS201', 'Intruduction to Computer Science'),
	(6, 1, 1, 'MBA', 'FMS', 4, 'MBA7101', 'Manegerial Economics'),
	(7, 1, 1, 'MBA', 'FMS', 4, 'MBA7102', 'Organizational Systems and Behaviour'),
	(8, 1, 1, 'MBA', 'FMS', 4, 'MBA7103', 'Accounting for Business'),
	(9, 1, 1, 'MBA', 'FMS', 4, 'MBA7104', 'Entrepreneurship and Innovation'),
	(10, 1, 1, 'MBA', 'FMS', 4, 'MBA7105', 'Legal Aspects of Business'),
	(11, 1, 1, 'MBA', 'FMS', 4, 'MBA7201', 'Marketing Management'),
	(12, 1, 1, 'MBA', 'FMS', 4, 'MBA7202', 'Financial Management'),
	(13, 1, 1, 'MBA', 'FMS', 4, 'MBA7203', 'Business Quantitative Methods'),
	(14, 1, 1, 'MBA', 'FMS', 4, 'MBA7204', 'Business Communication'),
	(15, 1, 1, 'MBA', 'FMS', 4, 'MBA7205', 'Human Capital Management'),
	(16, 2, 1, 'MBA', 'FMS', 4, 'MBA8101', 'Strategic Management'),
	(17, 2, 1, 'MBA', 'FMS', 4, 'MBA8102', 'Business Research Management'),
	(18, 2, 1, 'MBA', 'FMS', 4, 'MBA8103', 'Corporate Finance'),
	(19, 2, 1, 'MBA', 'FMS', 4, 'MBA8104', 'Investments and Financing Decisions'),
	(20, 2, 1, 'MBA', 'FMS', 4, 'MBA8105', 'Management Accounting'),
	(21, 2, 1, 'MBA', 'FMS', 4, 'MBA8106', 'Financial Reporting and Analysis'),
	(22, 2, 1, 'MBA', 'FMS', 4, 'MBA8107', 'Machinery Managemnt'),
	(23, 2, 1, 'MBA', 'FMS', 4, 'MBA8108', 'Management of Factory Plants'),
	(24, 2, 1, 'MBA', 'FMS', 4, 'MBA8109', 'Roads and Transport Management'),
	(25, 2, 1, 'MBA', 'FMS', 4, 'MBA8110', 'Real Estates Management'),
	(26, 1, 1, 'MBA', 'FMS', 4, 'MBA8111', 'Hr Laws and Employment Relations'),
	(27, 2, 1, 'MBA', 'FMS', 4, 'MBA8112', 'Compensation and Benefits Management'),
	(28, 1, 1, 'MBA', 'FMS', 4, 'MBA8113', 'Strategic Human Resource Management'),
	(29, 2, 1, 'MBA', 'FMS', 5, 'MBA8114', 'Human Resource Information Systems'),
	(30, 2, 1, 'MBA', 'FMS', 5, 'MBA8115', 'Project Monitoring and Evaluation'),
	(31, 2, 1, 'MBA', 'FMS', 5, 'MBA8116', 'Operations Management'),
	(32, 2, 1, 'MBA', 'FMS', 4, 'MBA8117', 'Development Administration & Management'),
	(33, 2, 1, 'MBA', 'FMS', 4, 'MBA8118', 'Tourism and Hospitality Management'),
	(34, 2, 1, 'MBA', 'FMS', 4, 'MBA8201', 'Ethics and Corporate Governance'),
	(35, 2, 1, 'MBA', 'FMS', 4, 'MBA8202', 'Research Project (Plan B)'),
	(36, 2, 1, 'MBA', 'FMS', 4, 'MBA8204', 'Risk Management'),
	(37, 2, 1, 'MBA', 'FMS', 4, 'MBA8205', 'Audit and Assurance'),
	(38, 2, 1, 'MBA', 'FMS', 4, 'MBA8206', 'International Business and Finance'),
	(39, 2, 1, 'MBA', 'FMS', 4, 'MBA8207', 'Water and Sanitation Management'),
	(40, 2, 1, 'MBA', 'FMS', 4, 'MBA8208', 'Energy Resources Management'),
	(41, 2, 1, 'MBA', 'FMS', 4, 'MBA8209', 'Project Cost Managemnt'),
	(42, 2, 1, 'MBA', 'FMS', 5, 'MBA8210', 'Performance Management'),
	(43, 2, 1, 'MBA', 'FMS', 4, 'MBA8210', 'Performance Management'),
	(44, 2, 1, 'MBA', 'FMS', 4, 'MBA8211', 'Public Policy Formulation and Management'),
	(45, 2, 1, 'MBA', 'FMS', 4, 'MBA8212', 'Organizational Change & Development'),
	(46, 2, 1, 'MBA', 'FMS', 4, 'MBA8213', 'Public Private Partnership'),
	(47, 2, 1, 'BBA', 'FMS', 4, 'BBA1101', 'Foundatiions of Business Administration'),
	(48, 1, 1, 'BBA', 'FMS', 5, 'BBA1102', 'Fundermentals of Information and Communications Technology'),
	(49, 1, 1, 'BBA', 'FMS', 4, 'BBA1103', 'Business Accounting'),
	(50, 1, 1, 'BBA', 'FMS', 4, 'BBA1104', 'Business Communication Skills'),
	(51, 1, 1, 'BBA', 'FMS', 4, 'BBA1105', 'Micro-economics'),
	(52, 1, 1, 'BBA', 'FMS', 4, 'BBA1106', 'Principles of Economics'),
	(53, 1, 1, 'BBA', 'FMS', 4, 'BBA1201', 'Organization Theory and Management'),
	(54, 1, 1, 'BBA', 'FMS', 4, 'BBA1202', 'Business Quantative Methods'),
	(55, 1, 1, 'BBA', 'FMS', 4, 'BBA1203', 'Intermediate Business Accounting'),
	(56, 1, 1, 'BBA', 'FMS', 4, 'BBA1204', 'Principles of Marketing'),
	(57, 1, 1, 'BBA', 'FMS', 4, 'BBA1205', 'Macro-economics'),
	(58, 1, 1, 'BBA', 'FMS', 4, 'BBA1206', 'Business Law'),
	(59, 1, 1, 'BBA', 'FMS', 4, 'BBA2101', 'Principles of Entrepreneurship'),
	(60, 2, 1, 'BBA', 'FMS', 4, 'BBA2102', 'Business Statics'),
	(61, 2, 1, 'BBA', 'FMS', 4, 'BBA2103', 'Business Finance'),
	(62, 2, 1, 'BBA', 'FMS', 4, 'BBA2104', 'Taxation Management'),
	(63, 2, 1, 'BBA', 'FMS', 5, 'BBA2105', 'Mnagement Information Systems'),
	(64, 2, 1, 'BBA', 'FMS', 4, 'BBA2106', 'Company Law'),
	(65, 1, 2, 'BBA', 'FMS', 4, 'BBA2201', 'Foundations of Human Resource Management'),
	(66, 2, 2, 'BBA', 'FMS', 4, 'BBA2202', 'Marketing Management'),
	(67, 2, 2, 'BBA', 'FMS', 4, 'BBA2203', 'Manegerial Economics'),
	(68, 3, 1, 'BBA', 'FMS', 4, 'BBA3101', 'Business Research Methods'),
	(69, 3, 1, 'BBA', 'FMS', 4, 'BBA3102', 'Coporate Governance'),
	(70, 3, 1, 'BBA', 'FMS', 4, 'BBA3103', 'Project Planning and Management'),
	(71, 3, 1, 'BBA', 'FMS', 4, 'BBA3104', 'Financial Reporting'),
	(72, 3, 1, 'BBA', 'FMS', 4, 'BBA3105', 'Audit Theory'),
	(73, 3, 1, 'BBA', 'FMS', 4, 'BBA3106', 'Corporate Finance'),
	(74, 3, 1, 'BBA', 'FMS', 4, 'BBA3107', 'Real Estates Management'),
	(75, 2, 1, 'BBA', 'FMS', 4, 'BBA3108', 'Retail Marketing'),
	(76, 3, 1, 'BBA', 'FMS', 4, 'BBA3109', 'Marketing Channels'),
	(77, 3, 1, 'BBA', 'FMS', 4, 'BBA3110', 'Entrepreneurship and Venture Management'),
	(78, 3, 1, 'BBA', 'FMS', 4, 'BBA3111', 'Social Entrepreneurship'),
	(79, 3, 1, 'BBA', 'FMS', 4, 'BBA3112', 'Management of Social Service Systems'),
	(80, 3, 1, 'BBA', 'FMS', 4, 'BBA3113', 'Loading and Managing Non-Profit Organizations'),
	(81, 3, 1, 'BBA', 'FMS', 4, 'BBA3108', 'Retail Marketing'),
	(82, 3, 1, 'BBA', 'FMS', 4, 'BBA3109', 'Marketing Channels'),
	(83, 1, 1, 'BBA', 'FMS', 4, 'BBA3110', 'Entrepreneurship and Venture Management'),
	(84, 3, 1, 'BBA', 'FMS', 4, 'BBA3111', 'Social Entreprenuership'),
	(85, 2, 1, 'BBA', 'FMS', 4, 'BBA3101', 'Business Research Methods'),
	(86, 3, 1, 'BBA', 'FMS', 4, 'BBA3102', 'Corporate Governance'),
	(87, 3, 1, 'BBA', 'FMS', 4, 'BBA3103', 'Project Planning & Management'),
	(88, 3, 1, 'BBA', 'FMS', 5, 'BBA3112', 'Management of Social Service Systems'),
	(89, 3, 1, 'BBA', 'FMS', 4, 'BBA3113', 'Leading and Managing Non - Profit Organisation'),
	(90, 3, 1, 'BBA', 'FMS', 4, 'BBA3114', 'Local Government & Decentralized Service Delivery'),
	(91, 3, 1, 'BBA', 'FMS', 4, 'BBA3115', 'Social Entrepreneurship'),
	(92, 2, 1, 'BBA', 'FMS', 4, 'BBA3116', 'Supply Chain Management'),
	(93, 3, 1, 'BBA', 'FMS', 4, 'BBA3117', 'Transport and Distribution Management'),
	(94, 3, 1, 'BBA', 'FMS', 5, 'BBA3118', 'E- Procurement'),
	(95, 3, 2, 'BBA', 'FMS', 4, 'BBA3201', 'Strategic Management'),
	(96, 3, 2, 'BBA', 'FMS', 4, 'BBA3202', 'Research Project'),
	(97, 3, 2, 'BBA', 'FMS', 5, 'BBA3203', 'Organizational Systems and Design'),
	(98, 3, 2, 'BBA', 'FMS', 4, 'BBA3209', 'International Marketing'),
	(99, 3, 2, 'BBA', 'FMS', 4, 'BBA3210', 'Sales Force Marketing'),
	(100, 3, 2, 'BBA', 'FMS', 4, 'BBA3210', 'Business Innovation'),
	(101, 3, 2, 'BBA', 'FMS', 4, 'BBA3212', 'Entrepreneurship and Small Management'),
	(102, 3, 2, 'BBA', 'FMS', 4, 'BBA3213', 'Public Policy Analysis and Management'),
	(103, 3, 2, 'BBA', 'FMS', 4, 'BBA3214', 'Health Services Management'),
	(104, 3, 2, 'BBA', 'FMS', 4, 'BBA3215', 'Education Service Managemnent'),
	(105, 3, 2, 'BBA', 'FMS', 4, 'BBA3216', 'Environmental Services Management'),
	(106, 2, 2, 'BBA', 'FMS', 4, 'BBA3217', 'Contracts Managemnet'),
	(107, 3, 2, 'BBA', 'FMS', 4, 'BBA3218', 'Public Procurement'),
	(108, 2, 2, 'BBA', 'FMS', 5, 'BBA3219', 'Global Sourcing'),
	(109, 2, 2, 'BBA', 'FMS', 4, 'BBA3220', 'Sustainable Procurement'),
	(110, 1, 1, 'BTT', 'FMS', 4, 'BTT1101', 'Tourism and Travel Business'),
	(111, 1, 1, 'BTT', 'FMS', 4, 'BTT1102', 'Computer Applicarions'),
	(112, 1, 1, 'BTT', 'FMS', 4, 'BTT1103', 'Travel Agency Operations'),
	(113, 1, 1, 'BTT', 'FMS', 4, 'BTT1104', 'Communication Skils'),
	(114, 1, 1, 'BTT', 'FMS', 4, 'BTT1105', 'Tour Guiding and Leadership Skills'),
	(115, 1, 1, 'BTT', 'FMS', 4, 'BTT1106', 'Fundermentals of Accounting'),
	(116, 1, 1, 'BTT', 'FMS', 4, 'BTT1107', 'Acquatic Tourism'),
	(117, 1, 1, 'BTT', 'FMS', 4, 'BTT1201', 'Financial Management'),
	(118, 1, 1, 'BTT', 'FMS', 4, 'BTT1202', 'Environment Management for Tourism'),
	(119, 1, 2, 'BTT', 'FMS', 4, 'BTT1203', 'Human Resource Management'),
	(120, 1, 1, 'BTT', 'FMS', 4, 'BTT1204', 'Principles of Hospitality Management'),
	(121, 1, 1, 'BTT', 'FMS', 4, 'BTT1205', 'Wildlife Tourism'),
	(122, 1, 2, 'BTT', 'FMS', 5, 'BTT1206', 'Tourism Analysis'),
	(123, 1, 2, 'BTT', 'FMS', 4, 'BTT1207', 'Tourism Marketing and Destination Promotion'),
	(124, 1, 2, 'BTT', 'FMS', 4, 'BTT1301', 'Industrial Attachment'),
	(125, 2, 1, 'BTT', 'FMS', 5, 'BTT2101', 'Introduction to Leisure and Recreation'),
	(126, 2, 1, 'BTT', 'FMS', 4, 'BTT2102', 'Tourism and Travel Industry Operations'),
	(127, 2, 1, 'BTT', 'FMS', 4, 'BTT2103', 'Eat African Wildlife'),
	(128, 2, 1, 'BTT', 'FMS', 4, 'BTT2104', 'Cultural Tourism'),
	(129, 2, 1, 'BTT', 'FMS', 5, 'BTT2105', 'Events Management'),
	(130, 2, 1, 'BTT', 'FMS', 4, 'BTT2106', 'Rural based Tourism Management'),
	(131, 2, 2, 'BTT', 'FMS', 4, 'BTT2201', 'Tourism and Travel Management Issues'),
	(132, 2, 2, 'BTT', 'FMS', 4, 'BTT2202', 'Conventions and Management of Functions'),
	(133, 2, 2, 'BTT', 'FMS', 4, 'BTT2203', 'Hospitality and Tourism Law'),
	(134, 2, 2, 'BTT', 'FMS', 4, 'BTT2204', 'Sport & Events Tourism'),
	(135, 2, 2, 'BTT', 'FMS', 5, 'BTT2205', 'Research Methods'),
	(136, 2, 2, 'BTT', 'FMS', 4, 'BBT2206', 'French I'),
	(137, 2, 2, 'BTT', 'FMS', 4, 'BTT2207', 'Kiswahili I'),
	(138, 2, 2, 'BTT', 'FMS', 4, 'BTT2208', 'German I'),
	(139, 2, 2, 'BTT', 'FMS', 5, 'BTT2302', 'Industrial Attachment'),
	(140, 3, 1, 'BTT', 'FMS', 4, 'BTT3101', 'Principles of Tourism Law'),
	(141, 3, 1, 'BTT', 'FMS', 4, 'BTT3102', 'Economics of Hospitality and Tourism'),
	(142, 3, 1, 'BTT', 'FMS', 4, 'BTT3103', 'Tourism Planning and policy Management'),
	(143, 3, 1, 'BTT', 'FMS', 4, 'BTT3104', 'Tour and Travel Operations Managemnt'),
	(144, 3, 1, 'BTT', 'FMS', 5, 'BTT3105', 'World Geography for Tourism'),
	(145, 3, 1, 'BTT', 'FMS', 4, 'BTT3106', 'Public Relations'),
	(146, 3, 1, 'BTT', 'FMS', 4, 'BTT3107', 'French II'),
	(147, 3, 1, 'BTT', 'FMS', 5, 'BTT3108', 'Kiswahili II'),
	(148, 3, 1, 'BTT', 'FMS', 4, 'BTT3109', 'German II'),
	(149, 3, 2, 'BTT', 'FMS', 4, 'BTT3201', 'International Tourism'),
	(150, 3, 1, 'BTT', 'FMS', 4, 'BTT3202', 'Tourism Entrepreneurship'),
	(151, 3, 2, 'BTT', 'FMS', 4, 'BTT3203', 'Principles of Marketing'),
	(152, 3, 2, 'BTT', 'FMS', 4, 'BTT3204', 'Tour Project Planning & Management'),
	(153, 3, 2, 'BTT', 'FMS', 4, 'BTT3205', 'Sustainable Tourism Development'),
	(154, 3, 2, 'BTT', 'FMS', 5, 'BTT3206', 'East African Societies'),
	(155, 3, 2, 'BTT', 'FMS', 4, 'BTT3207', 'Health, Safety and Security in Tourism Industry'),
	(156, 3, 2, 'BTT', 'FMS', 4, 'BTT3208', 'Research Report'),
	(157, 1, 1, 'DRI', 'FMS', 4, 'DRI1101', 'Principles of Record Management'),
	(158, 1, 1, 'DRI', 'FMS', 4, 'DRI1102', 'Skills and Practice of Communication'),
	(159, 1, 1, 'DRI', 'FMS', 4, 'DRI1103', 'Essential of Management'),
	(160, 1, 1, 'DRI', 'FMS', 5, 'DRI1104', 'Records and Archive Management Ethics'),
	(161, 1, 1, 'DRI', 'FMS', 5, 'DRI1105', 'Information and Communications Technology'),
	(162, 1, 1, 'DRI', 'FMS', 4, 'DRI1106', 'Fundermentals of Accounting'),
	(163, 1, 1, 'DRI', 'FMS', 5, 'DRI1201', 'Principles of Records Classifications'),
	(164, 1, 2, 'DRI', 'FMS', 4, 'DRI1202', 'Management'),
	(165, 1, 2, 'DRI', 'FMS', 4, 'DRI1203', 'Practice'),
	(166, 1, 1, 'DRI', 'FMS', 4, 'DRI1204', 'Identification'),
	(167, 1, 2, 'DRI', 'FMS', 5, 'DRI1204', 'Store Keeping and Materials Management'),
	(168, 1, 2, 'DRI', 'FMS', 4, 'DRI1206', 'Information and Communicatioins Technology II'),
	(169, 1, 2, 'DRI', 'FMS', 4, 'DRI1207', 'Field Work'),
	(170, 2, 1, 'DRI', 'FMS', 4, 'DRI2101', 'Computerized and Electronic Records Management'),
	(171, 2, 1, 'DRI', 'FMS', 5, 'DRI2102', 'Paper Making & Printing'),
	(172, 2, 1, 'DRI', 'FMS', 4, 'DRI2103', 'Fundermentals of Archives Management'),
	(173, 2, 1, 'DRI', 'FMS', 5, 'DRI2104', 'Organizational Management of Audio Visual Information'),
	(174, 2, 1, 'DRI', 'FMS', 4, 'DRI2105', 'Research Methods'),
	(175, 2, 2, 'DRI', 'FMS', 4, 'DRI2202', 'Preservation and Conservation of Information in Records'),
	(176, 2, 2, 'DRI', 'FMS', 4, 'DRI2202', 'Technical Writing and Documentation'),
	(177, 2, 2, 'DRI', 'FMS', 5, 'DRI2203', 'Paleology and Oral History'),
	(178, 2, 2, 'DRI', 'FMS', 5, 'DRI2204', 'Museology'),
	(179, 1, 2, 'DRI', 'FMS', 5, 'DRI2205', 'Research Analysis of Data'),
	(180, 2, 2, 'DRI', 'FMS', 5, 'DRI2205', 'Research Proposal'),
	(181, 1, 1, 'DBA', 'FMS', 4, 'DBA1101', '7'),
	(182, 1, 1, 'DBA', 'FMS', 5, 'DBA1102', 'Principles of Information and Communication'),
	(183, 1, 1, 'DBA', 'FMS', 4, 'DBA1103', 'Financial Accounting'),
	(184, 1, 1, 'DBA', 'FMS', 4, 'DBA1104', 'Business Communication'),
	(185, 1, 1, 'DBA', 'FMS', 4, 'DBA1105', 'Micro-economics'),
	(186, 1, 2, 'DBA', 'FMS', 4, 'DBA1201', 'Principles of Management'),
	(187, 1, 2, 'DBA', 'FMS', 4, 'DBA1202', 'Macro- Economics'),
	(188, 1, 2, 'DBA', 'FMS', 4, 'DBA1203', 'Principles of Marketing'),
	(189, 1, 2, 'DBA', 'FMS', 4, 'DBA1204', 'Business Law'),
	(190, 1, 2, 'DBA', 'FMS', 4, 'DBA1205', 'Business Statistics'),
	(191, 1, 2, 'DBA', 'FMS', 4, 'DBA1206', 'Research Methods'),
	(192, 2, 1, 'DBA', 'FMS', 4, 'DBA2101', 'Procurement and Supplies Management'),
	(193, 2, 1, 'DBA', 'FMS', 4, 'DBA2102', 'Intermediate Business Accounting'),
	(194, 2, 1, 'DBA', 'FMS', 4, 'DBA2103', 'Business Finanace'),
	(195, 2, 1, 'DBA', 'FMS', 4, 'DBA2104', 'Elements of Taxation'),
	(196, 2, 1, 'DBA', 'FMS', 4, 'DBA2105', 'Business Quantative Methods'),
	(197, 2, 2, 'DBA', 'FMS', 4, 'DBA2201', 'Entrepreneurship Development'),
	(198, 2, 2, 'DBA', 'FMS', 4, 'DBA2202', 'Cost and Management Accounting'),
	(199, 2, 2, 'DBA', 'FMS', 4, 'DBA2203', 'Principles of Accounting'),
	(200, 2, 2, 'DBA', 'FMS', 5, 'DBA2204', 'Management Information Systems'),
	(201, 2, 2, 'DBA', 'FMS', 4, 'DBA2205', 'Human Resource Management'),
	(202, 2, 2, 'DBA', 'FMS', 5, 'DBA2206', 'Research Proposal'),
	(203, 1, 1, 'DTT', 'FMS', 5, 'DTT1101', 'Computer Applications'),
	(204, 1, 1, 'DTT', 'FMS', 4, 'DTT1102', 'Principles of Tourism & Travel'),
	(205, 1, 1, 'DTT', 'FMS', 4, 'DTT1103', 'Travel Agency Operations'),
	(206, 1, 1, 'DTT', 'FMS', 4, 'DDT1104', 'Communication Skills'),
	(207, 1, 1, 'DTT', 'FMS', 4, 'DTT1105', 'Tour Guiding and Leadership'),
	(208, 1, 1, 'DTT', 'FMS', 4, 'DDT1106', 'Introductory Economics'),
	(209, 1, 2, 'DTT', 'FMS', 4, 'DDT1201', 'Air Fares and Ticketing'),
	(210, 1, 2, 'DTT', 'FMS', 4, 'DTT1202', 'Human Resource Management'),
	(211, 1, 2, 'DTT', 'FMS', 4, 'DTT1203', 'Marketing Tourism'),
	(212, 1, 2, 'DTT', 'FMS', 4, 'DTT1204', 'French'),
	(213, 1, 2, 'DTT', 'FMS', 4, 'DTT1205', 'Swahili'),
	(214, 1, 2, 'DTT', 'FMS', 4, 'DTT1206', 'German'),
	(215, 1, 2, 'DTT', 'FMS', 4, 'DTT1207', 'wildlife Tourism i'),
	(216, 1, 2, 'DTT', 'FMS', 4, 'DTT1208', 'Fundermentals of Accounting'),
	(217, 1, 2, 'DTT', 'FMS', 4, 'DTT1209', 'Industrial Attachment'),
	(218, 2, 1, 'DTT', 'FMS', 4, 'DTT2101', 'Business Entrepreneurship'),
	(219, 2, 1, 'DTT', 'FMS', 5, 'DTT2102', 'Tourism Analysis'),
	(220, 2, 1, 'DTT', 'FMS', 4, 'DT2103', 'Wildlife Tourism'),
	(221, 2, 1, 'DTT', 'FMS', 4, 'DTT2104', 'Principles of Hospitality Management'),
	(222, 1, 1, 'DTT', 'FMS', 4, 'DTT2105', 'Research Methods'),
	(223, 2, 1, 'DTT', 'FMS', 4, 'DTT2106', 'Acquatic Tourism'),
	(224, 2, 1, 'DTT', 'FMS', 4, 'DTT2201', 'Environment Management for Tourism'),
	(225, 2, 2, 'DTT', 'FMS', 4, 'DTT2202', 'Tourism Resources in Esat Africa'),
	(226, 2, 2, 'DTT', 'FMS', 4, 'DTT2203', 'Healthy, Safety and Security Tourism'),
	(227, 2, 2, 'DTT', 'FMS', 4, 'DTT2204', 'Destination Management'),
	(228, 2, 2, 'DTT', 'FMS', 4, 'DTT2205', 'Research Proposal'),
	(229, 1, 1, 'BPM', 'FMS', 4, 'BPM1101', 'Introduction to Procurement'),
	(230, 1, 1, 'BPM', 'FMS', 4, 'BPM1102', 'Computer Application 1'),
	(231, 1, 1, 'BPM', 'FMS', 4, 'BPM1103', 'Ware house and Inventory Management'),
	(232, 1, 1, 'BPM', 'FMS', 4, 'BPM1104', 'Business Communication Skills'),
	(233, 1, 1, 'BPM', 'FMS', 4, 'BPM1105', 'Micro-Economics'),
	(234, 1, 1, 'BPM', 'FMS', 4, 'BPM1106', 'Fundermentals of Accounting'),
	(235, 1, 2, 'BPM', 'FMS', 4, 'BPM1201', 'Principles of Management'),
	(236, 1, 2, 'BPM', 'FMS', 4, 'BPM1202', 'Fundermentals of Business Administration'),
	(237, 1, 2, 'BPM', 'FMS', 4, 'BPM1203', 'Logistics Management'),
	(238, 1, 2, 'BPM', 'FMS', 5, 'BPM1204', 'Computer Applications II'),
	(239, 1, 2, 'BPM', 'FMS', 4, 'BPM1205', 'Macro- Economics'),
	(240, 1, 2, 'BPM', 'FMS', 4, 'BPM1206', 'Customer Service and Logistics'),
	(241, 2, 1, 'BPM', 'FMS', 4, 'BPM2101', 'Marketing Management'),
	(242, 1, 1, 'BPM', 'FMS', 4, 'BPM2102', 'Financial Management'),
	(243, 2, 1, 'BPM', 'FMS', 4, 'BPM2103', 'Business Statistics'),
	(244, 2, 1, 'BPM', 'FMS', 4, 'BPM2104', 'Procurement for Resale'),
	(245, 2, 1, 'BPM', 'FMS', 4, 'BPM2105', 'Value Chain Management'),
	(246, 2, 1, 'BPM', 'FMS', 5, 'BPM2106', 'Production and Operations Management'),
	(247, 2, 2, 'BPM', 'FMS', 5, 'BPM2201', 'Research Methods'),
	(248, 2, 2, 'BPM', 'FMS', 4, 'BPM2202', 'Procurement Law'),
	(249, 2, 2, 'BPM', 'FMS', 4, 'BPM2203', 'Specifications and Supply Chain Management'),
	(250, 1, 2, 'BPM', 'FMS', 4, 'BPM2204', 'Cost Acoounting'),
	(251, 2, 2, 'BPM', 'FMS', 4, 'BPM2205', 'Risk & Insurance in Supply Chain Management'),
	(252, 2, 2, 'BPM', 'FMS', 4, 'BPM2206', 'Human Resource Management'),
	(253, 3, 1, 'BPM', 'FMS', 4, 'BPM3101', 'Strategic Procurement Management'),
	(254, 3, 1, 'BPM', 'FMS', 4, 'BPM3102', 'Relationship Management and Negotiations in SC'),
	(255, 2, 1, 'BPM', 'FMS', 5, 'BPM3103', 'E- Procurement'),
	(256, 3, 1, 'BPM', 'FMS', 4, 'BPM3104', 'Procurement Ethics'),
	(257, 3, 1, 'BPM', 'FMS', 4, 'BPM3105', 'Taxation Management'),
	(258, 3, 1, 'BPM', 'FMS', 4, 'BPM3106', 'Procurement records management'),
	(259, 3, 2, 'BPM', 'FMS', 4, 'BPM3201', 'Logistics in Supply Chain Managemment'),
	(260, 3, 2, 'BPM', 'FMS', 4, 'BPM3205', 'International Procurement Management'),
	(261, 3, 2, 'BPM', 'FMS', 4, 'BPM3206', 'Entrepreneurship'),
	(262, 3, 2, 'BPM', 'FMS', 5, 'BPM3207', 'Research Projects'),
	(263, 1, 1, 'BCH', 'FMS', 4, 'BCH1101', 'Food Production I'),
	(264, 1, 1, 'BCH', 'FMS', 5, 'BCH1102', 'Computer Applications'),
	(265, 1, 1, 'BCH', 'FMS', 4, 'BCH1103', 'Food and Beverage Service I'),
	(266, 1, 1, 'BCH', 'FMS', 4, 'BCH1104', 'Communication Skills'),
	(267, 1, 1, 'BCH', 'FMS', 4, 'BCH1105', 'Front Office Operation'),
	(268, 1, 1, 'BCH', 'FMS', 4, 'BCH1106', 'Fundermentals of Accounting'),
	(269, 2, 1, 'BCH', 'FMS', 4, 'BCH2101', 'Food Production III'),
	(270, 2, 1, 'BCH', 'FMS', 4, 'BCH2102', 'Facility and House Keeping II'),
	(271, 2, 1, 'BCH', 'FMS', 4, 'BCH2103', 'Accomodation Management'),
	(272, 2, 1, 'BCH', 'FMS', 4, 'BCH2104', 'Food and Beverage Management and Control'),
	(273, 2, 1, 'BCH', 'FMS', 4, 'BCH2105', 'Introduction to Leisure and Recreation'),
	(274, 2, 1, 'BCH', 'FMS', 4, 'BCH2106', 'Front Office Operations III'),
	(275, 3, 1, 'BCH', 'FMS', 4, 'BCH3101', 'Business Ethics'),
	(276, 3, 1, 'BCH', 'FMS', 4, 'BCH3102', 'Economics for Hospitality abd Tourism'),
	(277, 3, 1, 'BCH', 'FMS', 4, 'BCH3103', 'Food related micro-organism and Disease'),
	(278, 3, 1, 'BCH', 'FMS', 5, 'BCH3104', 'Foood and Nutrition for Hospitality Industry'),
	(279, 3, 1, 'BCH', 'FMS', 4, 'BCH3105', 'Organizational behaviour for Hospitality'),
	(280, 3, 1, 'BCH', 'FMS', 5, 'BCH3106', 'International Relations'),
	(281, 3, 1, 'BCH', 'FMS', 4, 'BCH3107', 'French II'),
	(282, 3, 1, 'BCH', 'FMS', 4, 'BCH3108', 'German II'),
	(283, 3, 1, 'BCH', 'FMS', 4, 'BCH3109', 'Kiswahili II'),
	(284, 1, 1, 'EDM', 'FMS', 4, 'EDM1101', 'Foundations of Entrepreneurship'),
	(285, 1, 1, 'EDM', 'FMS', 4, 'EDM1102', 'Management of Small Business'),
	(286, 1, 1, 'EDM', 'FMS', 4, 'EDM1103', 'Micro-econommics'),
	(287, 1, 1, 'EDM', 'FMS', 4, 'EDM1104', 'Principles of Accounting'),
	(288, 1, 1, 'EDM', 'FMS', 4, 'EDM1105', 'Management Mathematics'),
	(289, 1, 1, 'EDM', 'FMS', 4, 'EDM1106', 'Communication Skills'),
	(290, 1, 1, 'EDM', 'FMS', 4, 'EDM2101', 'Entrepreneurship Operations Management'),
	(291, 1, 1, 'EDM', 'FMS', 4, 'EDM2102', 'Local Government and Decentralized Service Delivery'),
	(292, 1, 1, 'EDM', 'FMS', 4, 'EDM2103', 'Consumer Behaviour'),
	(293, 2, 1, 'EDM', 'FMS', 4, 'EDM2101', 'Entrepreneurship Operations Management'),
	(294, 2, 1, 'EDM', 'FMS', 4, 'EDM2102', 'Local Government and Decentralized Service Delivery'),
	(295, 2, 1, 'EDM', 'FMS', 4, 'EDM2103', 'Consumer Behaviour'),
	(296, 2, 1, 'EDM', 'FMS', 4, 'EDM2104', 'Resource Mobilization Strategies'),
	(297, 2, 1, 'EDM', 'FMS', 4, 'EDM2105', 'Principles of Marketing'),
	(298, 2, 1, 'EDM', 'FMS', 4, 'EDM2106', 'Research Methods'),
	(299, 3, 1, 'EDM', 'FMS', 4, 'EDM3101', 'Business Law'),
	(300, 3, 1, 'EDM', 'FMS', 4, 'EDM3102', 'International Marketing for Entrepreneurs'),
	(301, 3, 1, 'EDM', 'FMS', 5, 'EDM3103', 'High Technology Ventures'),
	(302, 3, 1, 'EDM', 'FMS', 4, 'EDM3104', 'Entrepreneurial Solutions to global poverty'),
	(303, 3, 1, 'EDM', 'FMS', 4, 'EDM3105', 'E- Commerce and Entrepreneurship'),
	(304, 3, 1, 'EDM', 'FMS', 4, 'EDM3106', 'Human Resource Management'),
	(305, 1, 1, 'DCH', 'FMS', 4, 'DCH1101', 'Food Production I'),
	(306, 1, 1, 'DCH', 'FMS', 4, 'DCH1102', 'Computer Applications'),
	(307, 1, 1, 'DCH', 'FMS', 4, 'DCH1103', 'Food and Beverage Service I'),
	(308, 1, 1, 'DCH', 'FMS', 4, 'DCH1104', 'Communication Skills'),
	(309, 1, 1, 'DCH', 'FMS', 4, 'DCH1105', 'Front Office Operation'),
	(310, 2, 1, 'DCH', 'FMS', 4, 'DCH2101', 'Food Production II'),
	(311, 2, 1, 'DCH', 'FMS', 4, 'DCH2102', 'Hotel Housekeeping II'),
	(312, 2, 1, 'DCH', 'FMS', 4, 'DCH2103', 'Accomodation Management'),
	(313, 2, 1, 'DCH', 'FMS', 4, 'DCH2104', 'Food and Beverage Management and Control'),
	(314, 2, 1, 'DCH', 'FMS', 5, 'DCH2105', 'Research Methods'),
	(315, 1, 1, 'MMP', 'FHS', 16, 'MMP:7101', 'Introduction to Emmergency Pediatrics'),
	(316, 1, 1, 'MMP', 'FHS', 17, 'MMP: 7102', 'Medical Ethics & Gender Concepts'),
	(317, 1, 1, 'MMP', 'FHS', 17, 'MPP: 7103', 'Growth, development & Genetics'),
	(318, 1, 1, 'MMP', 'FHS', 17, 'MPP: 7104', 'Infectious disease and immunology & allergic diseases'),
	(319, 1, 1, 'MMP', 'FHS', 17, 'MMP:7105', 'Principles of teaching & learning'),
	(320, 2, 1, 'MMP', 'FHS', 17, 'MMP: 8101', 'Intermediate Emergency PEdiatrics (i)'),
	(321, 2, 1, 'MMP', 'FHS', 17, 'MMP: 8102', 'Neaonatology'),
	(322, 2, 1, 'MMP', 'FHS', 17, 'MMP: 8103', 'Child & Adolescent Mental Health'),
	(323, 2, 1, 'MMP', 'FHS', 17, 'MMP: 8104', 'Basic epidimology, statistics and applied research methods.'),
	(324, 3, 1, 'MMP', 'FHS', 17, 'MMP: 9101', 'Advanced Emmergency Pediatrics (i)'),
	(325, 3, 1, 'MMP', 'FHS', 17, 'MMP: 9102', 'Pulmonology'),
	(326, 3, 1, 'MMP', 'FHS', 17, 'MMP: 9103', 'Endocrine & Metabolic disorders'),
	(327, 3, 1, 'MMP', 'FHS', 17, 'MMP: 9104', 'Emerging & re-emerging diseases'),
	(328, 1, 1, 'MPH', 'FHS', 18, 'MPH: 7101', 'Primary  Healthcare: Principles an Practice'),
	(329, 1, 1, 'MPH', 'FHS', 18, 'MPH:7102', 'Health & Health Systems'),
	(330, 1, 1, 'MPH', 'FHS', 18, 'MPH:7103', 'Population Demographic and  Disease'),
	(331, 1, 1, 'MPH', 'FHS', 18, 'MPH:7104', 'Health Information Systems'),
	(332, 2, 1, 'MPH', 'FHS', 18, 'MPH:8201', 'Advanced Epidemiology'),
	(333, 2, 1, 'MPH', 'FHS', 18, 'MPH:8203', 'Data Management and Analysis'),
	(334, 2, 1, 'MPH', 'FHS', 18, 'MPH:8202', 'Quantative  Research Methods'),
	(335, 2, 1, 'MPH', 'FHS', 18, 'MPH:8205', 'Research  Proposal Development'),
	(336, 1, 1, 'MED', 'FHS', 19, 'MED1101', 'The Medical Profession, Nationalism & Ethics'),
	(337, 1, 1, 'MED', 'FHS', 20, 'MED1102', 'Information & Telecommunications technology in Medicine'),
	(338, 1, 1, 'MED', 'FHS', 20, 'MED11033', 'Cells, Tissues and Body Systems'),
	(339, 1, 1, 'MED', 'FHS', 20, 'MED1104', 'Blood and  Body  Fluids'),
	(340, 2, 1, 'MED', 'FHS', 20, 'MED2101', 'Neuroscience'),
	(341, 2, 1, 'MED', 'FHS', 20, 'MED2102', 'Cardiovascular and Respiratory System'),
	(342, 2, 1, 'MED', 'FHS', 20, 'MED2103', 'The Endocrine Reproductive and Urinary System'),
	(343, 3, 1, 'MED', 'FHS', 20, 'BSA3101', 'Pre-operative Assessment'),
	(344, 3, 1, 'MED', 'FHS', 20, 'BSA3102', 'Premedication and Infection Control'),
	(345, 3, 1, 'MED', 'FHS', 20, 'BSA3103', 'Induction of General Anaesthesia'),
	(346, 3, 1, 'MED', 'FHS', 20, 'BSA3104', 'Intra- and Post- operative Care'),
	(347, 3, 1, 'MED', 'FHS', 20, 'BSA3105', 'Introduction to Anaesthesia for Emergency Surgery and Management of Respiratory and Cardiac Arrest'),
	(348, 4, 1, 'MED', 'FHS', 20, 'BSA4101', 'Acute Pain  Management'),
	(349, 4, 1, 'MED', 'FHS', 20, 'BSA4102', 'Clinical Anaesthesia: Regional'),
	(350, 4, 1, 'MED', 'FHS', 20, 'BSA4103', 'Clinical Anaesthesia: Paediatrics'),
	(351, 4, 1, 'MED', 'FHS', 20, 'BSA4104', 'Emergency   Care'),
	(352, 4, 1, 'MED', 'FHS', 20, 'BSA4201', 'Critical  Care: I'),
	(353, 4, 1, 'MED', 'FHS', 20, 'BSA4202', 'Critical  Care: II'),
	(354, 4, 1, 'MED', 'FHS', 20, 'BSA4203', 'Critical  Care: III'),
	(355, 1, 1, 'APM', 'FAA', 21, 'APM1101', 'Farm Animal Anatomy'),
	(356, 1, 1, 'APM', 'FAA', 21, 'APM1102', 'Farm Animal Physiology'),
	(357, 1, 1, 'APM', 'FAA', 21, 'APM1103', 'Applied Biochemisty of Farm Animals'),
	(358, 1, 1, 'APM', 'FAA', 21, 'APM1104', 'Animal Resources, Rural Development & Gender'),
	(359, 1, 1, 'APM', 'FAA', 21, 'APM1105', 'Wildlife Resources ( Farming & Ranching)'),
	(360, 1, 1, 'APM', 'FAA', 21, 'APM1106', 'Development Studies, Sociolgy in Animal Production'),
	(361, 2, 1, 'APM', 'FAA', 21, 'APM2101', 'Biostatistics in Animal Production'),
	(362, 2, 1, 'APM', 'FAA', 21, 'APM2102', 'Assisted Reproduction Technologies & Gene Banking'),
	(363, 2, 1, 'APM', 'FAA', 21, 'APM2103', 'Animal Genetics & Bleeding'),
	(364, 2, 1, 'APM', 'FAA', 21, 'APM2104', 'Pharmacology & Animal  Drugs Management'),
	(365, 2, 1, 'APM', 'FAA', 21, 'APM2105', 'Natural Products & Ethno-Pharmacology'),
	(366, 2, 1, 'APM', 'FAA', 21, 'APM2106', 'Animal & Enviromental Toxicology'),
	(367, 2, 1, 'APM', 'FAA', 21, 'APM3101', 'Poultry  Production, Value  Addition and Marketing'),
	(368, 2, 1, 'APM', 'FAA', 21, 'APM3102', 'Aquaculture,Value  Addition and Marketing'),
	(369, 3, 1, 'APM', 'FAA', 21, 'APM3101', 'Poultry  Production, Value  Addition and Marketing'),
	(370, 3, 1, 'APM', 'FAA', 21, 'APM3102', 'Aquaculture,Value  Addition and Marketing'),
	(371, 3, 1, 'APM', 'FAA', 21, 'APM3103', 'Micro-livestock production, Value  Addition and Marketing'),
	(372, 3, 1, 'APM', 'FAA', 21, 'APM3104', 'Animal Product Quality Assurance'),
	(373, 3, 1, 'APM', 'FAA', 21, 'APM3105', 'Public Health  in Animal Production'),
	(374, 3, 1, 'APM', 'FAA', 21, 'APM3106', 'Leather  Technology'),
	(375, 3, 1, 'APM', 'FAA', 21, 'APM3107', 'Livestock Production Economics'),
	(376, 1, 1, 'DAP', 'FAA', 21, 'DAP1101', 'Livestock- Environment Interaction'),
	(377, 1, 1, 'DAP', 'FAA', 21, 'DAP1102', 'Animal genetics and Bleeding'),
	(378, 1, 1, 'DAP', 'FAA', 21, 'DAP1103', 'Farm Practices I'),
	(379, 1, 1, 'DAP', 'FAA', 21, 'DAP1104', 'Farm  Structures and Agricultural Mechanization'),
	(380, 1, 1, 'DAP', 'FAA', 21, 'DAP1105', 'Farm  Management and Communications Skills'),
	(381, 1, 1, 'DAP', 'FAA', 21, 'DAP1106', 'Biochemistry'),
	(382, 1, 1, 'DAP', 'FAA', 21, 'DAP1107', 'Computer Applications'),
	(383, 1, 1, 'DAP', 'FAA', 21, 'DAP1108', 'Farm Animal Anatomy and Physiology'),
	(384, 2, 1, 'DAP', 'FAA', 21, 'DAP2101', 'Dairy and Beef Production Technology and Marketing'),
	(385, 2, 1, 'DAP', 'FAA', 21, 'DAP2102', 'Principles of Ethno-Pharmacology'),
	(386, 2, 1, 'DAP', 'FAA', 21, 'DAP2103', 'Research  Project'),
	(387, 2, 1, 'DAP', 'FAA', 21, 'DAP2104', 'Rural  Sociology and Community Outreach'),
	(388, 2, 1, 'DAP', 'FAA', 21, 'DAP2105', 'Wildlife Ecology and Management'),
	(389, 2, 1, 'DAP', 'FAA', 21, 'DAP2106', 'Animal Nutrition and Feed  Technology'),
	(390, 2, 1, 'DAP', 'FAA', 21, 'DAP2107', 'Poultry Production and Marketing'),
	(391, 1, 1, 'DCP', 'FAA', 22, 'DCP1101', 'Principles of Agriculture and Climatology'),
	(392, 1, 1, 'DCP', 'FAA', 22, 'DCP1102', 'Annual Crops Production'),
	(393, 1, 1, 'DCP', 'FAA', 22, 'DCP1103', 'Farm Practices I'),
	(394, 1, 1, 'DCP', 'FAA', 22, 'DCP1104', 'Soils and Soil Improvement'),
	(395, 1, 1, 'DCP', 'FAA', 22, 'DCP1105', 'Farm Structures and Workshop Skills'),
	(396, 1, 1, 'DCP', 'FAA', 22, 'DCP1106', 'DCP1106'),
	(397, 1, 1, 'DCP', 'FAA', 22, 'DCP1107', 'Computer Applications'),
	(398, 1, 1, 'DCP', 'FAA', 22, 'DCP2101', 'Introduction  to Botany  & Physiology'),
	(399, 1, 1, 'DCP', 'FAA', 22, 'DCP2102', 'Agro forestry  & Apiculture'),
	(400, 1, 1, 'DCP', 'FAA', 22, 'DCP2103', 'Crop Protection'),
	(401, 1, 1, 'DCP', 'FAA', 22, 'DCP2104', 'Sustainable Agriculture'),
	(402, 1, 1, 'DCP', 'FAA', 22, 'DCP2105', 'Extension Education, Rural Sociology and Gender'),
	(403, 1, 1, 'DCP', 'FAA', 22, 'DCP2106', 'Special Project'),
	(404, 1, 1, 'DCP', 'FAA', 22, 'DCP2107', 'Outreach'),
	(405, 1, 1, 'MCF', 'FOE', 23, 'MCF8101', 'Web Programming'),
	(406, 1, 1, 'MCF', 'FOE', 23, 'MCF8102', 'Cybercrime & Digital Forensic'),
	(407, 1, 1, 'MCF', 'FOE', 23, 'MCF8103', 'Criminal Justice'),
	(408, 1, 1, 'MCF', 'FOE', 23, 'MCF8104', 'Network Technologies'),
	(409, 1, 1, 'MCF', 'FOE', 23, 'MCF8105', 'Information Privacy and Security'),
	(410, 1, 1, 'MCF', 'FOE', 23, 'MCF8106', 'OS Platforms & Computer Technologies'),
	(411, 2, 1, 'MCF', 'FOE', 23, 'MCF9101', 'Research Methods'),
	(412, 2, 1, 'MCF', 'FOE', 23, 'MCF9102', 'Constitutional Law'),
	(413, 2, 1, 'MCF', 'FOE', 23, 'MCF9103', 'Cryptographic and Authentication'),
	(414, 2, 1, 'MCF', 'FOE', 23, 'MCF9104', 'Distributed Systems'),
	(415, 2, 1, 'MCF', 'FOE', 23, 'MCF9105', 'Wireless and  mobile computing'),
	(416, 1, 1, 'PTI', 'FOE', 25, 'PTI1101', 'Engineering Mathematics I'),
	(417, 1, 1, 'PTI', 'FOE', 25, 'PTI1102', 'Computer Applications'),
	(418, 1, 1, 'PTI', 'FOE', 25, 'PTI1103', 'Organic Chemistry'),
	(419, 1, 1, 'PTI', 'FOE', 25, 'PTI1104', 'Engineering  Drawing I'),
	(420, 1, 1, 'PTI', 'FOE', 25, 'PTI1105', 'Communications Skills'),
	(421, 1, 1, 'PTI', 'FOE', 25, 'PTI1106', 'Engineering Mechanics I ( Statics)'),
	(422, 2, 1, 'PTI', 'FOE', 25, 'PTI2101', 'Engineering  Mathematics  III'),
	(423, 2, 1, 'PTI', 'FOE', 25, 'PTI2101', 'Engineering  Mathematics  III'),
	(424, 2, 1, 'PTI', 'FOE', 25, 'PTI2102', 'Electrical Machines and Devices'),
	(425, 2, 1, 'PTI', 'FOE', 25, 'PTI2103', 'Computer  Programming'),
	(426, 2, 1, 'PTI', 'FOE', 25, 'PTI2104', 'Polymer Chemistry'),
	(427, 2, 1, 'PTI', 'FOE', 25, 'PTI2105', 'Spinning Methods and Yarn Engineering'),
	(428, 2, 1, 'PTI', 'FOE', 25, 'PTI2106', 'Materials Science and Engineering'),
	(429, 2, 1, 'PTI', 'FOE', 25, 'PTI3101', 'Production Planning and Control'),
	(430, 2, 1, 'PTI', 'FOE', 25, 'PTI3103', 'Knitting Technolgy'),
	(431, 2, 1, 'PTI', 'FOE', 25, 'PTI3103', 'Gender Studies'),
	(432, 2, 1, 'PTI', 'FOE', 25, 'PTI3105', 'Design of Machine Elements'),
	(433, 2, 1, 'PTI', 'FOE', 25, 'PTI3106', 'Research Methods'),
	(434, 2, 1, 'PTI', 'FOE', 25, 'PTI3107', 'Theory of Textile Structures'),
	(435, 4, 1, 'PTI', 'FOE', 25, 'PTI4101', 'Indutrial Textiles'),
	(436, 4, 1, 'PTI', 'FOE', 25, 'PTI4102', 'Business Management'),
	(437, 4, 1, 'PTI', 'FOE', 25, 'PTI4103', 'Maintenance  Engineering'),
	(438, 4, 1, 'PTI', 'FOE', 25, 'PTI4104', 'Operations Research'),
	(439, 4, 1, 'PTI', 'FOE', 25, 'PTI4105', 'Quality Control and Assuranace'),
	(440, 4, 1, 'PTI', 'FOE', 25, 'PTI4107', 'Final Year Project I'),
	(441, 4, 1, 'PTI', 'FOE', 25, 'PTI4108', 'Leather and  Footwear  Technology'),
	(442, 4, 1, 'PTI', 'FOE', 25, 'PTI4110', 'Woven Textile  Design'),
	(443, 1, 1, 'DEE', 'FOE', 23, 'DEE1101', 'Engineering Mathematics I'),
	(444, 1, 1, 'DAG', 'FOE', 24, 'DAG1101', 'Engineering Mathematics I'),
	(445, 1, 1, 'DAG', 'FOE', 24, 'DAG1102', 'Engineering Drawing'),
	(446, 1, 1, 'DEE', 'FOE', 23, 'DEE1102', 'Engineering Drawing'),
	(447, 1, 1, 'DEE', 'FOE', 23, 'DEE1103', 'Mechanical Engineering Science'),
	(448, 1, 1, 'DEE', 'FOE', 23, 'DEE1104', 'Basics of Electrical and Electronic Engineering'),
	(449, 1, 1, 'DEE', 'FOE', 24, 'DEE1105', 'Fundamentals of Information and Communication Technolgy'),
	(450, 1, 1, 'DEE', 'FOE', 24, 'DEE1106', 'Workshop Practice'),
	(451, 1, 1, 'DEE', 'FOE', 23, 'DEE1107', 'Communication Skills'),
	(452, 2, 1, 'DEE', 'FOE', 23, 'DEE2101', 'Electrical Machines and Devices II'),
	(453, 2, 1, 'DEE', 'FOE', 23, 'DEE2102', 'Analog and Digital Electronics'),
	(454, 2, 1, 'DEE', 'FOE', 23, 'DEE2103', 'Power Systems I'),
	(455, 2, 1, 'DEE', 'FOE', 25, 'DEE2104', 'Industrial Automation and Control'),
	(456, 2, 1, 'DEE', 'FOE', 25, 'DEE2105', 'Computer  Programming'),
	(457, 2, 1, 'DEE', 'FOE', 25, 'DEE2106', 'Ethics and Gender Studies'),
	(458, 2, 1, 'DEE', 'FOE', 25, 'DEE2107', 'Final Year Project I'),
	(459, 2, 1, 'DEE', 'FOE', 25, 'DEE2108', 'Control Systems'),
	(460, 1, 1, 'DAG', 'FOE', 25, 'DAG1103', 'Engineering Mechanics 1'),
	(461, 1, 1, 'DAG', 'FOE', 23, 'DAG1104', 'Computer Applications'),
	(462, 1, 1, 'DAG', 'FOE', 23, 'DAG1105', 'Communication Skills'),
	(463, 1, 1, 'DAG', 'FOE', 24, 'DAG1106', 'Engineering and Sustainable Development'),
	(464, 1, 1, 'DAG', 'FOE', 24, 'DAG1107', 'Principles of Agronomy'),
	(465, 2, 1, 'DAG', 'FOE', 24, 'DAG2101', 'Electrical Technology'),
	(466, 2, 1, 'DAG', 'FOE', 24, 'DAG2102', 'Production Technology II'),
	(467, 2, 1, 'DAG', 'FOE', 24, 'DAG2103', 'Agricultural Machinery'),
	(468, 2, 1, 'DAG', 'FOE', 24, 'DAG2104', 'Post-Harvest Handling and Processing'),
	(469, 2, 1, 'DAG', 'FOE', 24, 'DAG2105', 'Water Harvesting and Irrigation'),
	(470, 2, 1, 'DAG', 'FOE', 24, 'DAG2106', 'Agricultural Machinery Maintenance and Repair'),
	(471, 1, 1, 'DCF', 'FOE', 24, 'DCF7101', 'Web Programming'),
	(472, 1, 1, 'DCF', 'FOE', 24, 'DCF7102', 'Cybercrime and Digital Forensic'),
	(473, 1, 1, 'DCF', 'FOE', 25, 'DCF7103', 'Criminal Justice'),
	(474, 1, 1, 'DCF', 'FOE', 23, 'DCF7104', 'Network Technologies'),
	(475, 1, 1, 'DCF', 'FOE', 24, 'DCF7105', 'Information Privacy and Security'),
	(476, 1, 1, 'DCF', 'FOE', 24, 'DCF7106', 'OS Platforms and Computer Technologies'),
	(477, 1, 1, 'DGIE', 'FOE', 25, 'DGIE1101', 'Engineering Mathematics Science I'),
	(478, 1, 1, 'DGIE', 'FOE', 24, 'DGIE1102', 'Mechanical Engineering Science I'),
	(479, 1, 1, 'DGIE', 'FOE', 24, 'DGIE1104', 'Electrical Engineering Science I'),
	(480, 1, 1, 'DGIE', 'FOE', 24, 'DGIE1103', 'Engineering Drawing'),
	(481, 1, 1, 'DGIE', 'FOE', 23, 'DGIE1105', 'Communication Skills'),
	(482, 1, 1, 'DGIE', 'FOE', 23, 'DGIE1106', 'Computer Applications'),
	(483, 1, 1, 'DGIE', 'FOE', 24, 'DGIE1107', 'Production Technology'),
	(484, 2, 1, 'DGIE', 'FOE', 25, 'DGIE2101', 'Industrial and Ginning Machinery'),
	(485, 2, 1, 'DGIE', 'FOE', 25, 'DGIE2102', 'Industrial Electrical Engineering I'),
	(486, 2, 1, 'DGIE', 'FOE', 25, 'DGIE2103', 'Material Handling Equipment & Structures I'),
	(487, 2, 1, 'DGIE', 'FOE', 24, 'DGIE2104', 'Baling and Industrial Packaging'),
	(488, 2, 1, 'DGIE', 'FOE', 25, 'DGIE2105', 'Occupational Health and Safety'),
	(489, 2, 1, 'DGIE', 'FOE', 25, 'DGIE2106', 'Cotton Production Technology and Marketing'),
	(490, 2, 1, 'DGIE', 'FOE', 25, 'DGIE2107', 'Research Project'),
	(491, 1, 1, 'MDI', 'FOE', 24, 'MDI8101', 'Hydrology'),
	(492, 1, 1, 'MDI', 'FOE', 25, 'MDI8102', 'Applied Hydraulics'),
	(493, 1, 1, 'MDI', 'FOE', 24, 'MDI8103', 'Agronomy and Water Management'),
	(494, 1, 1, 'MDI', 'FOE', 24, 'MDI8104', 'Drainage and Water Quality'),
	(495, 1, 1, 'MDI', 'FOE', 23, 'MDI8105', 'Applied Statistics'),
	(496, 2, 1, 'MDI', 'FOE', 25, 'MDI9101', 'Dissertation Research I'),
	(497, 2, 1, 'MDI', 'FOE', 24, 'MDI9102', 'Management of Irrigation & Drainage Systems'),
	(498, 2, 1, 'MDI', 'FOE', 24, 'MDI9103', 'Irrigation Conveyance and ControlSystems'),
	(499, 2, 1, 'MDI', 'FOE', 24, 'MDI9104', 'Project Planning & Management'),
	(500, 2, 1, 'MDI', 'FOE', 24, 'MDI9105', 'Food Mitigation & Management'),
	(501, 2, 1, 'MDI', 'FOE', 24, 'MDI9106', 'Land Evaluation for Irrigated Agriculture'),
	(502, 2, 1, 'MDI', 'FOE', 25, 'MDI9107', 'Creativity and Innovations'),
	(503, 1, 1, 'SCS', 'FSE', 1, 'SCS110', 'Discrete Mathematics'),
	(504, 3, 1, 'SCS', 'FSE', 1, 'SCS301', 'Graphics Design');

-- Dumping structure for table quad.6c_unit_load_2020
CREATE TABLE IF NOT EXISTS `6c_unit_load_2020` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `semester` tinyint(1) NOT NULL,
  `cuID` varchar(10) NOT NULL,
  `staffID` int(11) NOT NULL,
  `cordinator` bigint(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.6c_unit_load_2020: 1 rows
INSERT INTO `6c_unit_load_2020` (`id`, `semester`, `cuID`, `staffID`, `cordinator`) VALUES
	(6, 1, 'SCS201', 136, 0);

-- Dumping structure for table quad.6d_dept
CREATE TABLE IF NOT EXISTS `6d_dept` (
  `deptID` int(11) NOT NULL AUTO_INCREMENT,
  `facultyID` varchar(3) NOT NULL,
  `deptName` varchar(100) NOT NULL,
  `hod` smallint(6) NOT NULL,
  PRIMARY KEY (`deptID`),
  KEY `facultyID` (`facultyID`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.6d_dept: ~45 rows (approximately)
INSERT INTO `6d_dept` (`deptID`, `facultyID`, `deptName`, `hod`) VALUES
	(1, 'FSE', 'Department of Computer Studies', 98),
	(2, 'FSE', 'Department of Physics', 93),
	(3, 'FSE', 'Department of Languages', 0),
	(4, 'FMS', 'Department of Economics and Management', 8),
	(5, 'FMS', 'Department of Tourism and Hospitality Management', 163),
	(7, 'FSE', 'Department of Mathematics', 107),
	(9, 'FSE', 'Department of Economics', 127),
	(11, 'FSE', 'Department of Chemistry', 90),
	(12, 'FSE', 'Department of Biology', 94),
	(13, 'FSE', 'Department of Agriculture', 97),
	(14, 'FSE', 'Department of Geography', 128),
	(15, 'FSE', 'Department of Education', 96),
	(16, 'FHS', 'Paaediatrics & Child Health', 0),
	(17, 'FHS', 'Department of Paediatrics & Child Health', 0),
	(18, 'FHS', 'Department of Public and Community Health', 0),
	(19, 'FHS', 'Department of Anaesthesia', 0),
	(20, 'FHS', 'Department of Anaesthesia and Critical Care', 0),
	(21, 'FAA', 'Department of  Animal Production and Management (APM)', 0),
	(22, 'FAA', 'Department of Crop Production', 0),
	(23, 'FOE', 'Department of Computer Engineering', 21),
	(24, 'FOE', 'Department of Agricultural Mechanization &  Irrigation Engineering', 50),
	(25, 'FOE', 'Department of Textile and Ginning Engineering', 16),
	(26, 'FOE', 'Department of Mining Engineering', 33),
	(27, 'FOE', 'Department of Agroprocessing Engineering', 34),
	(28, 'FOE', 'Department of Water Resources Engineering', 17),
	(31, 'FNR', 'Department of Geo-information, Earth Observations and Physical Land Resources', 75),
	(32, 'FNR', 'Department of Natural Resources Economics', 74),
	(33, 'FNR', 'Department of Environmental Management', 71),
	(34, 'FSE', 'Dean Faculty of Science and Education', 95),
	(35, 'FSE', 'Deputy Dean Faculty of Science and Education', 0),
	(36, 'FHS', 'Department of Anatomy and Cell Biology', 0),
	(37, 'FHS', 'Department of Biochemistry and Molecular Biology', 0),
	(39, 'FHS', 'Department of Internal Medicine', 0),
	(40, 'FHS', 'Department of Microbiology and Immunology', 0),
	(41, 'FHS', 'Department of Nursing', 0),
	(42, 'FHS', 'Department of Obstetrics and Gynecology', 0),
	(43, 'FHS', 'Department of Paediatrics and Child Health', 0),
	(44, 'FHS', 'Department of Pathology', 0),
	(45, 'FHS', 'Department of Pharmacology and therapeutics', 0),
	(46, 'FHS', 'Department of Physiology', 0),
	(47, 'FHS', 'Department of Psychiatry and Mental Health', 0),
	(48, 'FHS', 'Department of Surgery', 0),
	(49, 'FHS', 'Department of ENT', 0),
	(50, 'FHS', 'Department of Ophthalmology', 0),
	(51, 'FHS', 'Department of Radiology', 0);

-- Dumping structure for table quad.6e_faculty
CREATE TABLE IF NOT EXISTS `6e_faculty` (
  `facultyID` varchar(5) NOT NULL,
  `facultyName` varchar(45) NOT NULL,
  `address` varchar(45) NOT NULL,
  `dean` varchar(100) NOT NULL,
  `contact` varchar(100) NOT NULL,
  `PHD` int(1) NOT NULL,
  `MST` int(1) NOT NULL,
  `DEG` int(1) NOT NULL,
  `DIP` int(1) NOT NULL,
  `CER` varchar(5) NOT NULL,
  `icon` varchar(20) NOT NULL,
  `color` varchar(20) NOT NULL,
  `photo1` varchar(100) NOT NULL,
  `photo2` varchar(100) NOT NULL,
  `photo3` varchar(100) NOT NULL,
  PRIMARY KEY (`facultyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table quad.6e_faculty: ~6 rows (approximately)
INSERT INTO `6e_faculty` (`facultyID`, `facultyName`, `address`, `dean`, `contact`, `PHD`, `MST`, `DEG`, `DIP`, `CER`, `icon`, `color`, `photo1`, `photo2`, `photo3`) VALUES
	('FAA', 'Agriculture', 'Arapi', '', '', 2, 2, 3, 2, '2', 'ion ion-leaf', 'bg-green', '1.jpg', '2.jpg', '3.jpg'),
	('FHS', 'Health Sciences', 'Mbale', '', '', 3, 3, 5, 3, '2', 'ion ion-medkit', 'bg-green', '1.jpg', '2.jpg', '3.jpg'),
	('FMS', 'Management Sciences & Human Resource', 'Pallisa', '', '', 2, 2, 3, 2, '1', 'ion ion-ios-people', 'bg-yellow', '1.jpg', '2.jpg', '3.jpg'),
	('FNRE', 'Natural Resources', 'Namasagali', '', '', 2, 2, 3, 2, '1', 'fa fa-tint', 'bg-aqua', '1.jpg', '2.jpg', '3.jpg'),
	('FOE', 'Engineering(Main)', 'Busia', '', '', 2, 2, 4, 2, '2', 'fa fa-cogs', 'bg-gold', '1.jpg', '2.jpg', '3.jpg'),
	('FSE', 'Science And Education', 'Nagongera', '', '', 2, 2, 3, 2, '1', 'ion ion-ribbon-b', 'bg-blue', '1.jpg', '2.jpg', '3.jpg');

-- Dumping structure for table quad.6f_program
CREATE TABLE IF NOT EXISTS `6f_program` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `programID` varchar(5) NOT NULL,
  `programName` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.6f_program: ~6 rows (approximately)
INSERT INTO `6f_program` (`id`, `programID`, `programName`) VALUES
	(1, 'CER', 'Certifiate'),
	(2, 'DEG', 'Bachelors Degree'),
	(3, 'DIP', 'Diploma'),
	(4, 'MST', 'Masters Degree'),
	(5, 'PDG', 'Post Graduate Diploma'),
	(6, 'PHD', 'Doctorate Degree');

-- Dumping structure for table quad.6h_mails
CREATE TABLE IF NOT EXISTS `6h_mails` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `u_id` smallint(6) NOT NULL,
  `u_role` varchar(5) NOT NULL,
  `sender` varchar(150) NOT NULL DEFAULT '',
  `rec_filters` varchar(150) NOT NULL DEFAULT '',
  `rec_count` bigint(20) NOT NULL,
  `subject` varchar(150) NOT NULL,
  `message` mediumtext NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table quad.6h_mails: ~0 rows (approximately)

-- Dumping structure for table quad.6i_reviews
CREATE TABLE IF NOT EXISTS `6i_reviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `courseID` varchar(5) NOT NULL,
  `start` int(11) NOT NULL DEFAULT '0',
  `finish` int(11) NOT NULL DEFAULT '0',
  `duration` tinyint(1) NOT NULL,
  `notes` longtext NOT NULL,
  `file` varchar(50) DEFAULT '',
  `uid` smallint(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Program reviews';

-- Dumping data for table quad.6i_reviews: 2 rows
INSERT INTO `6i_reviews` (`id`, `courseID`, `start`, `finish`, `duration`, `notes`, `file`, `uid`) VALUES
	(1, 'SCS', 1491177600, 1585872000, 3, '<p><span style="left: 120.04px; top: 477.567px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.896203);">The Computer Science </span><span style="left: 294.117px; top: 477.567px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.856292);">Program (CSP) </span><span style="left: 407.367px; top: 477.567px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.933876);">offers a 40</span><span style="left: 488.2px; top: 477.567px; font-size: 18.4px; font-family: sans-serif;">-</span><span style="left: 493.8px; top: 477.567px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.929831);">course degree program with the designa</span><span style="left: 800.317px; top: 477.567px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.925424);">tion Bachelor </span><span style="left: 120.04px; top: 499.967px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.920571);">of  Science   (Computer  Science).  This  program  is  offered  in  full</span><span style="left: 629.833px; top: 499.967px; font-size: 18.4px; font-family: sans-serif;">-</span><span style="left: 635.433px; top: 499.967px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.926545);">time   and  part</span><span style="left: 749.117px; top: 499.967px; font-size: 18.4px; font-family: sans-serif;">-</span><span style="left: 754.717px; top: 499.967px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.914097);">time   formats.  The </span><span style="left: 120.04px; top: 522.367px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.870871);">Department  also  offers  an  optional  Co</span><span style="left: 412.167px; top: 522.367px; font-size: 18.4px; font-family: sans-serif;">-</span><span style="left: 417.767px; top: 522.367px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.878612);">op  program  whereby  a  student  may work  for  sixteen  to  twenty </span><span style="left: 120.04px; top: 544.767px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.94292);">months (four or five</span><span style="left: 273.717px; top: 544.767px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.949155);">work </span><span style="left: 315.317px; top: 544.767px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.930044);">terms), typically for a</span><span style="left: 477.4px; top: 544.767px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.926202);">software company</span><span style="left: 615.833px; top: 544.767px; font-size: 18.4px; font-family: sans-serif;">,</span><span style="left: 624.233px; top: 544.767px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.94184);">outside of the university.</span></p><p><br><span style="left: 624.233px; top: 544.767px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.94184);"><span style="left: 845.967px; top: 1171.36px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.89433);"></span></span></p>', 'file_SCS_1597241302.pdf', 2),
	(2, 'SCS', 1396310400, 1488326400, 3, '<p><span style="left: 624.233px; top: 544.767px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.94184);"><span style="left: 120.04px; top: 1104.52px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.904248);">Admission  r</span><span style="left: 211.683px; top: 1104.52px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.935747);">equirements</span><span style="left: 314.517px; top: 1104.52px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.930257);"> for  the  f</span><span style="left: 382.167px; top: 1104.52px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.969);">ull</span><span style="left: 400.167px; top: 1104.52px; font-size: 18.4px; font-family: sans-serif;">-</span><span style="left: 405.767px; top: 1104.52px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.921988);">time  program  include</span><span style="left: 581.833px; top: 1104.52px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.874316);">O.S.S.D.  with  six  Grade  12  U/M  courses,</span><span style="left: 120.04px; top: 1126.92px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.868596);">including  Grade  12  U  courses  in:  English,  Advanced  Functions  (MHF4U),  one  of  Physics  (SPH4U),  or </span><span style="left: 120.04px; top: 1148.92px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.870627);">Chemistry  (SCH4U),  or  Biology  (SBI4U),  and  either  Calculus  and  Vectors  (MCV4U)  or  Mathematics  of </span><span style="left: 120.04px; top: 1171.36px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.899314);">Data  Management  (MDM4U).  Calculus  and  Vectors  (MCV4U)  is  the </span><span style="left: 661.083px; top: 1171.36px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.953712);">preferred</span><span style="left: 740.717px; top: 1171.36px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.921906);">mathematics </span><span style="left: 845.967px; top: 1171.36px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.89433);">course.</span></span></p><p><br><span style="left: 624.233px; top: 544.767px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.94184);"><span style="left: 845.967px; top: 1171.36px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.89433);"><span style="left: 120.04px; top: 123.433px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.862642);">ENG4U/EAE4U  is  the  preferred  English.  Physics  is  the  recommended  Grade  12  U  Science.  Subject  to </span><span style="left: 120.04px; top: 145.833px; font-size: 18.4px; font-family: sans-serif; transform: scaleX(0.921857);">competition, candidates may be required to present averages/grades above the minimum.</span></span></span></p>', 'file_SCS_1597241429.pdf', 2);

-- Dumping structure for table quad.7a_gallery
CREATE TABLE IF NOT EXISTS `7a_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `photo` varchar(25) NOT NULL,
  `cat` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.7a_gallery: ~30 rows (approximately)
INSERT INTO `7a_gallery` (`id`, `photo`, `cat`) VALUES
	(1, '1.jpg', 'students'),
	(2, '2.jpg', 'students'),
	(3, '3.jpg', 'students'),
	(4, '4.jpg', 'students'),
	(5, '5.jpg', 'students'),
	(6, '6.jpg', 'staff'),
	(7, '7.jpg', 'staff'),
	(8, '8.jpg', 'staff'),
	(9, '9.jpg', 'staff'),
	(10, '10.jpg', 'events'),
	(11, '11.jpg', 'students'),
	(12, '12.jpg', 'events'),
	(13, '13.jpg', 'events'),
	(14, '14.jpg', 'events'),
	(15, '15.jpg', 'events'),
	(16, '16.jpg', 'events'),
	(17, '17.jpg', 'students'),
	(18, '18.jpg', 'students'),
	(19, '19.jpg', 'students'),
	(20, '20.jpg', 'events'),
	(21, '21.jpg', 'events'),
	(22, '22.jpg', 'students'),
	(23, '23.jpg', 'events'),
	(24, '24.jpg', 'events'),
	(25, '25.jpg', 'events'),
	(26, '26.jpg', 'events'),
	(27, '27.jpg', 'events'),
	(28, '28.jpg', 'events'),
	(29, '29.jpg', 'events'),
	(30, '30.jpg', 'events');

-- Dumping structure for table quad.7b_resources
CREATE TABLE IF NOT EXISTS `7b_resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `detail` text NOT NULL,
  `type` varchar(15) NOT NULL,
  `file` varchar(100) NOT NULL,
  `url` varchar(200) NOT NULL,
  `public` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.7b_resources: ~9 rows (approximately)
INSERT INTO `7b_resources` (`id`, `name`, `detail`, `type`, `file`, `url`, `public`) VALUES
	(1, '2020 Advert', '2020 Advert', 'pdf', '2020_advert.pdf', '', 0),
	(2, 'Fees Structure ', 'Fees Structure ', 'pdf', '2020_fees.pdf', '', 1),
	(3, 'Mbale Diploma Shortlist', 'Mbale Diploma Shortlist', 'pdf', '2020_mbale.pdf', '', 0),
	(4, '2020 Post Graduate Shortlist', '2020 Post Graduate Shortlist', 'pdf', '2020_post.pdf', '', 1),
	(5, '2020 Suplementary Admissions', '2020 Suplementary Admissions', 'pdf', '2020_suplementary.pdf', '', 1),
	(6, 'QA Governing Policy', 'Governing manual for Busitema University DAQ', 'word', 'policy.docx', '', 1),
	(7, 'Senate Members', 'Senate cabinet members  2020', 'excel', 'senate.xls', '', 0),
	(8, 'New Guild House', 'New guild canteen 2020/2021 regime', 'image', 'plan.png', '', 0);

-- Dumping structure for table quad.7c_schedule
CREATE TABLE IF NOT EXISTS `7c_schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cuID` varchar(10) NOT NULL,
  `staffID` int(11) NOT NULL,
  `topic` varchar(45) NOT NULL,
  `content` varchar(200) NOT NULL,
  `week` int(2) NOT NULL,
  `description` varchar(150) NOT NULL,
  `type` varchar(15) NOT NULL,
  `status1` varchar(100) NOT NULL,
  `status2` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cuID` (`cuID`),
  KEY `staffID` (`staffID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Dumping data for table quad.7c_schedule: ~3 rows (approximately)
INSERT INTO `7c_schedule` (`id`, `cuID`, `staffID`, `topic`, `content`, `week`, `description`, `type`, `status1`, `status2`) VALUES
	(3, 'SCS201', 3, 'Relation', 'listed types of relationships like one to one, one to many etc', 1, 'the target was achived', 'Assignment', 'Successful', 'Successful'),
	(4, 'SCS201', 136, 'Relation', '1 to 1 , 1 to M and M to 1', 1, 'completed', 'Lecture', 'Successful', 'Unsuccessful'),
	(5, 'scs201', 3, 'Web Design', 'Designing Website using ASP.Net', 1, 'all went well', 'Lecture', 'Successful', 'Successful');

