first_semester2020.sql

-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 26, 2020 at 08:44 AM
-- Server version: 10.4.6-MariaDB
-- PHP Version: 7.3.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `first_semester2020`
--

-- --------------------------------------------------------

--
-- Table structure for table `class`
--

CREATE TABLE `class` (
  `class_id` int(255) NOT NULL,
  `level_id` int(5) NOT NULL,
  `department_id` int(255) NOT NULL,
  `population` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `class`
--

INSERT INTO `class` (`class_id`, `level_id`, `department_id`, `population`) VALUES
(1, 1, 1, 84),
(2, 1, 2, 283),
(3, 1, 3, 320),
(4, 1, 4, 642),
(5, 1, 5, 12),
(6, 1, 6, 110),
(7, 1, 7, 502),
(8, 1, 8, 660),
(9, 1, 9, 97),
(10, 1, 10, 27),
(11, 1, 11, 72),
(12, 1, 12, 82),
(13, 1, 13, 53),
(14, 1, 14, 16),
(15, 1, 15, 112),
(16, 1, 22, 487),
(17, 1, 25, 39),
(18, 1, 26, 12),
(19, 1, 27, 13),
(20, 1, 30, 12),
(21, 1, 34, 67),
(22, 2, 1, 57),
(23, 2, 2, 205),
(24, 2, 3, 287),
(25, 2, 4, 590),
(26, 2, 5, 7),
(27, 2, 6, 106),
(28, 2, 7, 425),
(29, 2, 8, 583),
(30, 2, 9, 140),
(31, 2, 10, 21),
(32, 2, 11, 21),
(33, 2, 12, 56),
(34, 2, 13, 46),
(35, 2, 14, 20),
(36, 2, 15, 52),
(37, 2, 22, 250),
(38, 2, 26, 6),
(39, 2, 27, 7),
(40, 3, 1, 24),
(41, 3, 2, 87),
(42, 3, 3, 207),
(43, 3, 4, 283),
(44, 3, 6, 43),
(45, 3, 16, 100),
(46, 3, 17, 5),
(47, 3, 18, 37),
(48, 3, 19, 4),
(49, 4, 1, 33),
(50, 4, 2, 64),
(51, 4, 3, 191),
(52, 4, 4, 230),
(53, 4, 6, 27),
(54, 4, 16, 78),
(55, 4, 17, 15),
(56, 4, 18, 23),
(57, 4, 19, 5);

-- --------------------------------------------------------

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `course_id` int(255) NOT NULL,
  `course_code` varchar(10) NOT NULL,
  `course_title` varchar(50) NOT NULL,
  `course_unit` int(10) NOT NULL,
  `level_id` int(255) NOT NULL,
  `department_id` int(255) NOT NULL,
  `semester_id` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` (`course_id`, `course_code`, `course_title`, `course_unit`, `level_id`, `department_id`, `semester_id`) VALUES
(4989, 'ACC 111', 'PRINCIPLES OF ACCOUNTS I', 2, 1, 9, 1),
(4990, 'ACC 111', 'PRINCIPLES OF ACCOUNTS I', 3, 1, 4, 1),
(4991, 'ACC 111', 'PRINCIPLES OF ACCOUNTS I', 3, 1, 3, 1),
(4992, 'ACC 111', 'PRINCIPLES OF ACCOUNTS I', 2, 1, 11, 1),
(4993, 'ACC 111', 'PRINCIPLES OF ACCOUNTS I', 4, 1, 12, 1),
(4994, 'ACC 111', 'PRINCIPLES OF ACCOUNTS I', 3, 1, 22, 1),
(4995, 'ACC 111', 'PRINCIPLES OF ACCOUNTS I', 2, 1, 26, 1),
(4996, 'BAM 114', 'PRINCIPLES OF MANAGEMENT I', 2, 1, 12, 1),
(4997, 'ACC 112', 'PRINCIPLES OF MANAGEMENT I', 3, 1, 3, 1),
(5007, 'ACC 211', 'FINANCIAL ACCOUNTING I', 3, 2, 3, 1),
(5008, 'ACC 211', 'COST ACCOUNTING I', 3, 2, 4, 1),
(5009, 'ACC 211', 'FINANCIAL ACCOUNTING I', 4, 2, 12, 1),
(5010, 'ACC 212', 'COST ACCOUNTING I', 4, 2, 12, 1),
(5011, 'ACC 212', 'COST ACCOUNTING I', 3, 2, 22, 1),
(5012, 'ACC 212', 'COST ACCOUNTING I', 3, 2, 9, 1),
(5013, 'ACC 212', 'COST ACCOUNTING I', 3, 2, 3, 1),
(5014, 'ACC 213', 'AUDITING I', 3, 2, 3, 1),
(5015, 'ACC 214', 'TAXATION I', 3, 2, 3, 1),
(5030, 'ACC 311', 'ACCOUNTING THEORY AND PRACTICE', 3, 3, 3, 1),
(5031, 'ACC 312', 'ADVANCED COSTING I', 3, 3, 3, 1),
(5032, 'ACC 313', 'EXECUTORSHIP AND BANKRUPTCY LAW', 2, 3, 3, 1),
(5033, 'ACC 315', 'QUANTITATIVE TECHNIQUES', 3, 3, 3, 1),
(5034, 'ACC 316', 'PUBLIC FINANCE', 3, 3, 3, 1),
(5035, 'ACC 316', 'PUBLIC FINANCE', 3, 3, 4, 1),
(5036, 'ACC 317', 'MANAGEMENT INFORMATION SYSTEM I', 3, 3, 3, 1),
(5037, 'ACC 318', 'MANAGERIAL ECONOMICS', 3, 3, 3, 1),
(5043, 'ACC 411', 'ADVANCED FINANCIAL ACCOUNTING II', 3, 4, 3, 1),
(5044, 'ACC 412', 'AUDITING AND INVESTIGATIONS', 3, 4, 3, 1),
(5045, 'ACC 413', 'FINANCIAL MANAGEMENT I', 3, 4, 3, 1),
(5046, 'ACC 414', 'ADVANCED TAXATION II', 3, 4, 3, 1),
(5047, 'ACC 415', 'MANAGEMENT ACCOUNTING I', 3, 4, 3, 1),
(5048, 'ACC 415', 'MANAGEMENT ACCOUNTING I', 3, 4, 4, 1),
(5049, 'ACC 416', 'PUBLIC SECTOR ACCOUNTING II', 3, 4, 3, 1),
(5057, 'ARC 111', 'TECHNICAL DRAWING', 2, 1, 10, 1),
(5058, 'ARC 111', 'TECHNICAL DRAWING', 2, 1, 14, 1),
(5059, 'ARC 115', 'FREEHAND SKETCHING', 2, 1, 14, 1),
(5065, 'ARC 211', 'ARCHITECTURAL DESIGN', 3, 2, 14, 1),
(5066, 'ARC 214', 'PHOTOGRAPHY AND MODEL MAKING', 2, 2, 14, 1),
(5067, 'ARC 213', 'MECHANICAL/ELECTRICAL WORKSHOP PRACTICE', 2, 2, 14, 1),
(5068, 'ARC 215', 'ARCHITECTURAL GRAPHICS II', 2, 2, 14, 1),
(5069, 'ARC 219', 'COMPUTER AIDED DESIGN AND DRAFTING II', 2, 2, 14, 1),
(5075, 'BAM 111', 'INTRODUCTION TO BUSINESS I', 2, 1, 11, 1),
(5076, 'BAM 111', 'INTRODUCTION TO BUSINESS', 3, 1, 4, 1),
(5077, 'BAM 111', 'INTRODUCTION TO BUSINESS', 2, 1, 9, 1),
(5078, 'BAM 112', 'BUSINESS MATHEMATICS I', 2, 1, 4, 1),
(5079, 'BAM 112', 'BUSINESS MATHEMATICS I', 2, 1, 3, 1),
(5080, 'BAM 112', 'BUSINESS MATHEMATICS I', 2, 1, 12, 1),
(5081, 'BAM 113', 'PRINCIPLES OF LAW', 2, 1, 12, 1),
(5082, 'BAM 113', 'PRINCIPLES OF LAW', 2, 1, 11, 1),
(5083, 'BAM 113', 'PRINCIPLES OF LAW', 2, 1, 3, 1),
(5084, 'BAM 113', 'PRINCIPLES OF LAW', 2, 1, 4, 1),
(5085, 'BAM 114', 'PRINCIPLES OF ECONOMICS I', 3, 1, 4, 1),
(5086, 'BAM 114', 'PRINCIPLES OF ECONOMICS I', 2, 1, 11, 1),
(5087, 'BAM 115', 'PRINCIPLES OF MARKETING', 2, 1, 12, 1),
(5088, 'BAM 115', 'PRINCIPLES OF MARKETING', 2, 1, 4, 1),
(5089, 'BAM 116', 'ELEMENTS OF PUBLIC ADMINISTRATION', 3, 1, 4, 1),
(5090, 'BAM 117', 'PRINCIPLES OF PURCHASING', 2, 1, 4, 1),
(5101, 'BAM 211', 'PRINCIPLES OF MANAGEMENT I', 3, 2, 4, 1),
(5102, 'BAM 211', 'PRINCIPLES OF MANAGEMENT I', 3, 2, 9, 1),
(5103, 'BAM 212', 'BUSINESS STATISTICS I', 2, 2, 4, 1),
(5104, 'BAM 212', 'BUSINESS STATISTICS I', 2, 2, 3, 1),
(5105, 'BAM 212', 'BUSINESS STATISTICS I', 2, 2, 12, 1),
(5106, 'BAM 213', 'OFFICE MANAGEMENT', 2, 2, 4, 1),
(5107, 'BAM 214', 'BUSINESS LAW', 2, 2, 4, 1),
(5108, 'BAM 214', 'BUSINESS LAW', 2, 2, 9, 1),
(5109, 'BAM 215', 'DATA PROCESSING II', 3, 2, 4, 1),
(5110, 'BAM 217', 'BUSINESS RESEARCH METHODS', 2, 2, 4, 1),
(5119, 'BAM 311', 'PRACTICE OF MANAGEMENT', 3, 3, 4, 1),
(5120, 'BAM 312', 'ORGANSATIONAL BEHAVIOUR I', 3, 3, 4, 1),
(5121, 'BAM 313', 'QUANTITATIVE TECHNIQUES IN BUSINESS', 3, 3, 4, 1),
(5122, 'BAM 314', 'HUMAN CAPITAL MANAGEMENT I', 3, 3, 4, 1),
(5123, 'BAM 316', 'FINANCIAL MANAGEMENT I', 3, 3, 4, 1),
(5132, 'BAM 411', 'BUSINESS POLICY AND STRATEGIES I', 3, 4, 4, 1),
(5133, 'BAM 412', 'MANAGERIAL ECONOMICS I', 3, 4, 4, 1),
(5134, 'BAM 414', 'INDUSTRIAL RELATIONS', 2, 4, 4, 1),
(5135, 'BAM 415', 'COMPANY LAW', 2, 4, 4, 1),
(5136, 'BAM 418', 'SMALL BUSINESS MANAGEMENT I', 3, 4, 4, 1),
(5137, 'BAM 418', 'SMALL BUSINESS MANAGEMENT', 2, 4, 3, 1),
(5145, 'BFN 111', 'ELEMENTS OF BANKING I', 2, 1, 12, 1),
(5146, 'BFN 111', 'ELEMENTS OF BANKING I', 2, 1, 3, 1),
(5147, 'BFN 112', 'PRINCIPLES OF ECONOMICS I', 3, 1, 3, 1),
(5148, 'BFN 112', 'PRINCIPLES OF ECONOMICS I', 3, 1, 12, 1),
(5155, 'BFN 211', 'BUSINESS FINANCE', 2, 2, 12, 1),
(5156, 'BFN 211', 'BUSINESS FINANCE', 2, 2, 3, 1),
(5157, 'BFN 212', 'FINANCIAL INSTITUTIONS', 3, 2, 12, 1),
(5158, 'BFN 213', 'BUSINESS RESEARCH METHODS', 2, 2, 12, 1),
(5159, 'BFN 213', 'BUSINESS RESEARCH METHODS', 2, 2, 3, 1),
(5160, 'BFN 215', 'BANKING LAWS AND REGULATIONS', 3, 2, 12, 1),
(5161, 'BFN 216', 'INTRODUCTION TO PUBLIC FINANCE', 3, 2, 12, 1),
(5167, 'ARC 112', 'BUILDING CONSTRUCTION I', 3, 1, 14, 1),
(5168, 'BLD 111', 'BUILDING SCIENCE & PROPERTIES OF MATERIALS I', 2, 1, 26, 1),
(5171, 'BLD 113', 'BUILDING CONSTRUCTION I', 3, 1, 26, 1),
(5173, 'BLD 115', 'WORKSHOP PRACTICE & TECHNOLOGY I', 2, 1, 26, 1),
(5175, 'BLD 117', 'TECHNICAL DRAWING', 2, 1, 26, 1),
(5178, 'BLD 111', 'CONCRETE WORKSHOP PRACTICE', 2, 1, 14, 1),
(5183, 'ARC 212', 'BUILDING CONSTRUCTION III', 3, 2, 14, 1),
(5184, 'BLD 211', 'BUILDING CONSTRUCTION I', 3, 2, 10, 1),
(5187, 'BLD 212', 'INTRODUCTION TO THEORY OF STRUCTURES', 2, 2, 26, 1),
(5188, 'BLD 213', 'BUILDING CONSTRUCTION III', 3, 2, 26, 1),
(5190, 'BLD 215', 'WORKSHOP PRACTICE & TECHNOLOGY III', 2, 2, 26, 1),
(5192, 'BLD 217', 'BUILDING SERVICES', 2, 2, 26, 1),
(5194, 'BLD 219', 'SITE MANAGEMENT I', 2, 2, 26, 1),
(5195, 'BLD 211', 'PRINCIPLES OF LAW AND BUILDING CONTRACTS', 2, 2, 26, 1),
(5196, 'COM 213', 'COMPUTER PACKAGES I', 3, 2, 26, 1),
(5202, 'BPH 111', 'PHYSICS I (MECHANICS & PROPERTIES OF MATTER & HEAT', 2, 1, 27, 1),
(5203, 'BPH 111', 'MECHANICS AND PROPERTIES OF MATTER AND HEAT ENERGY', 3, 1, 15, 1),
(5204, 'BPH 111', 'MECHANICS AND PROPERTIES OF MATTER AND HEAT ENERGY', 2, 1, 14, 1),
(5207, 'STP 214', 'PHYSICS II (OPTICS, WAVES, ELECTRICITY & MAGNETISM', 3, 2, 27, 1),
(5209, 'CME 211', 'BASIC WORKSHOP TECHNOLOGY AND PRACTICE', 2, 2, 15, 1),
(5210, 'COM 111', 'INTRODUCTION TO COMPUTING', 3, 1, 2, 1),
(5211, 'COM 111', 'INTRODUCTIN TO COMPUTER', 2, 1, 1, 1),
(5212, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 4, 1),
(5213, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 8, 1),
(5214, 'COM 111', 'COMPUTER APPRECIATION', 3, 1, 9, 1),
(5215, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 5, 1),
(5216, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 7, 1),
(5217, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 3, 1),
(5218, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 10, 1),
(5219, 'COM 111', 'INTRODUCTION TO COMPUTING', 2, 1, 15, 1),
(5220, 'COM 111', 'INTRODUCTION TO COMPUTING', 2, 1, 13, 1),
(5221, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 14, 1),
(5222, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 12, 1),
(5223, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 11, 1),
(5224, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 27, 1),
(5225, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 26, 1),
(5226, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 6, 1),
(5227, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 22, 1),
(5228, 'COM 112', 'INTRODUCTION TO DIGITAL ELECTRONICS', 3, 1, 2, 1),
(5229, 'COM 113', 'INTRODUCTION TO PROGRAMMING', 3, 1, 2, 1),
(5243, 'COM 211', 'COMPUTER PROGRAMMING USING OOBASIC', 3, 2, 2, 1),
(5244, 'COM 212', 'INTRODUCTION TO SYSTEM PROGRAMMING', 3, 2, 2, 1),
(5245, 'COM 213', 'COMMERCIAL PROGRAMMING LANGUAGE USING OO COBOL', 3, 2, 2, 1),
(5246, 'COM 213', 'COMPUTER PACKAGES I', 2, 2, 22, 1),
(5247, 'COM 214', 'FILE ORGANIZATION AND MANAGEMENT', 3, 2, 2, 1),
(5248, 'COM 215', 'COMPUTER PACKAGES II', 3, 2, 2, 1),
(5249, 'COM 215', 'COMPUTER PACKAGES II', 2, 2, 7, 1),
(5250, 'COM 215', 'COMPUTER PACKAGES II', 2, 2, 15, 1),
(5251, 'COM 216', 'COMPUTER SYSTEM TROUBLE SHOOTING', 3, 2, 2, 1),
(5252, 'COM 218', 'DATABASE DESIGN', 2, 2, 2, 1),
(5253, 'COM 218', 'COMPUTER PROGRAMMING USING C++', 2, 2, 1, 1),
(5263, 'COM 316', 'COMPUTER APPLICATION PACKAGE', 2, 3, 16, 1),
(5264, 'COM 316', 'COMPUTER APPLICATION', 2, 3, 18, 1),
(5265, 'COM 316', 'COMPUTER APPLICATION PACKAGE', 3, 3, 17, 1),
(5266, 'COM 311', 'OPERATING SYSTEM I', 3, 3, 2, 1),
(5267, 'COM 312', 'DATABASE DESIGN I', 3, 3, 2, 1),
(5268, 'COM 313', 'COMPUTER PROGRAMMING USING C++', 3, 3, 2, 1),
(5269, 'COM 314', 'COMPUTER ARCHITECTURE', 3, 3, 2, 1),
(5270, 'COM 315', 'ADVANCED WEB PROGRAMMING', 3, 3, 2, 1),
(5277, 'COM 411', 'COMPUTER MODELLING AND SIMULATION', 3, 4, 2, 1),
(5278, 'COM 412', 'COMPUTER PROGRAMMING IN PASCAL', 3, 4, 2, 1),
(5279, 'COM 413', 'PROJECT MANAGEMENT', 3, 4, 2, 1),
(5280, 'COM 414', 'COMPILER CONSTRUCTION', 3, 4, 2, 1),
(5281, 'COM 415', 'DATA COMMUNICATION AND COMPUTER NETWORK', 3, 4, 2, 1),
(5282, 'COM 416', 'MULTIMEDIA', 3, 4, 2, 1),
(5292, 'CTE 111', 'MICRO COMPUTER FUNDAMENTALS', 2, 1, 1, 1),
(5293, 'CTE 112', 'COMPUTER WORKSHOP PRACTICE I', 1, 1, 1, 1),
(5294, 'CTE 113', 'RUDIMENT OF CIRCUIT DESIGN AND CONSTRUCTION (PRACT', 1, 1, 1, 1),
(5296, 'CTE 213', 'DIGITAL COMPUTER FUNDAMENTALS II', 3, 2, 1, 1),
(5297, 'CTE 214', 'COMPUTER ARCHITECTURE', 1, 2, 1, 1),
(5298, 'CTE 216', 'SEMINAR', 2, 2, 1, 1),
(5304, 'CTE 313', 'COMPUTER PROGRAMMING USING C/C++ LANGUAGE', 2, 3, 1, 1),
(5305, 'CTE 314', 'OPERATING SYSTEM II', 2, 3, 1, 1),
(5310, 'CTE 410', 'COMPUTER TECHNOLOGY', 3, 4, 1, 1),
(5311, 'CTE 411', 'DATA COMMUNICATION AND COMPUTER NETWORK', 3, 4, 1, 1),
(5312, 'CTE 412', 'COMPUTER ARCHITECTURE II', 2, 4, 1, 1),
(5313, 'CTE 413', 'COMPUTER INSTALLATION AND MAINTENANCE', 2, 4, 1, 1),
(5314, 'CTE 419', 'PROJECT I', 1, 4, 1, 1),
(5320, 'EEC 111', 'ELECTRICAL GRAPHICS', 2, 1, 6, 1),
(5321, 'EEC 112', 'INTRODUCTION TO COMPUTER SOFTWARE', 2, 1, 6, 1),
(5322, 'EEC 114', 'REPORT WRITING', 2, 1, 6, 1),
(5323, 'EEC 115', 'ELECTRICAL ENGINEERING SCIENCE I', 2, 1, 6, 1),
(5324, 'EEC 115', 'ELECTRICAL ENGINEERING SCIENCE I', 2, 1, 13, 1),
(5325, 'EEC 116', 'ELECTRICAL WORKSHOP PRACTICE I', 2, 1, 6, 1),
(5326, 'EEC 116', 'ELECTRICAL WORKSHOP PRACTICE I', 2, 1, 1, 1),
(5327, 'EEC 117', 'COMPUTER HARDWARE I', 2, 1, 6, 1),
(5328, 'EEC 118', 'ELECTRICAL ENGINEERING SCIENCE', 3, 1, 1, 1),
(5343, 'EEC 210', 'ELECTRICAL CIRCUIT THEORY I', 2, 2, 6, 1),
(5344, 'EEC 210', 'ELECTRICAL CIRCUIT THEORY I', 2, 2, 1, 1),
(5345, 'EEC 212', 'ELECTRICAL POWER II', 2, 2, 6, 1),
(5346, 'EEC 213', 'ELECTRICAL MACHINE II', 2, 2, 6, 1),
(5347, 'EEC 214', 'ELECTRONICS II', 2, 2, 6, 1),
(5348, 'EEC 214', 'ELECTRONICS II', 3, 2, 1, 1),
(5349, 'EEC 215', 'ELECTRICAL MEASUREMNET AND INSTRUMENTATION II', 2, 2, 1, 1),
(5350, 'EEC 216', 'ELECTRICAL AND ELECTRONIC INSTRUMENT II', 2, 2, 6, 1),
(5351, 'EEC 217', 'ELECTRICAL/ELECTRONIC MAINTENANCE AND REPAIR', 2, 2, 6, 1),
(5352, 'EEC 217', 'ELECTRICAL/ELECTRONIC MAINTENANCE AND REPAIR', 2, 2, 1, 1),
(5353, 'EEC 218', 'TELECOMMUNICATIONS II', 2, 2, 6, 1),
(5362, 'EEC 211', 'SEMINAR', 2, 2, 6, 1),
(5363, 'EEC 311', 'ELECTRICAL MATERIAL SCIENCE', 2, 3, 6, 1),
(5364, 'EEC 311', 'ELECTRICAL MATERIAL SCIENCE', 2, 3, 1, 1),
(5365, 'EEC 313', 'ELECTRICAL CIRCUIT THEORY III', 2, 3, 1, 1),
(5366, 'EEC 313', 'ELECTRICAL CIRCUIT THEORY III', 3, 3, 6, 1),
(5367, 'EEC 314', 'ANALOGUE ELECTRONICS III', 3, 3, 6, 1),
(5368, 'EEC 314', 'ELECTRICAL MEASUREMENT AND INSTRUMENTATION', 2, 3, 1, 1),
(5369, 'EEC 315', 'ELECTRONICS III', 3, 3, 1, 1),
(5370, 'EEC 316', 'TELECOMMUNICATIONS II', 3, 3, 1, 1),
(5371, 'EEC 317', 'ELECTRONIC DESIGN AND DRAFTING', 2, 3, 1, 1),
(5372, 'EEC 318', 'DIGITAL ELECTRONICS', 2, 3, 6, 1),
(5378, 'EEC 411', 'ELECTROMAGNETIC FIELD THEORY', 2, 4, 6, 1),
(5379, 'EEC 413', 'CONTROL ENGINEERING SYSTEM', 3, 4, 6, 1),
(5380, 'EEC 413', 'CONTROL ENGINEERING II', 3, 4, 1, 1),
(5381, 'EEC 419', 'PROJECT I', 2, 4, 6, 1),
(5384, 'EED 116', 'BUSINESS ENTREPRENEURSHIP', 2, 1, 6, 1),
(5385, 'EED 116', 'PRACTICE OF ENTREPRENEURSHIP', 2, 1, 8, 1),
(5400, 'EED 216', 'PRACTICE OF ENTREPRENEURSHIP', 2, 2, 22, 1),
(5401, 'EED 216', 'PRACTICE OF ENTREPRENEURSHIP', 2, 2, 12, 1),
(5402, 'EED 216', 'PRACTICE OF ENTREPRENEURSHIP', 2, 2, 15, 1),
(5403, 'EED 216', 'ENTRPRENEURSHIP DEVELOPMENT II', 2, 2, 11, 1),
(5404, 'EED 216', 'PRACTICE OF ENTREPRENEURSHIP', 2, 2, 3, 1),
(5405, 'EED 216', 'PRACTICE OF ENTREPRENEURSHIP', 2, 2, 9, 1),
(5406, 'EED 216', 'PRACTICE OF ENTREPRENEURSHIP', 2, 2, 4, 1),
(5409, 'EED 316', 'PRACTICE OF ENTREPRENEURSHIP', 2, 3, 16, 1),
(5410, 'EED 316', 'ENTREPRENEURSHIP DEVELOPMENT I', 2, 3, 17, 1),
(5411, 'EED 316', 'BUSINESS ENTREPRENEURSHIP', 2, 3, 6, 1),
(5413, 'EED 413', 'ENTRPRENEURSHIP DEVELOPMENT II', 2, 4, 1, 1),
(5414, 'EED 413', 'ENTREPRENEURSHIP DEVELOPMENT', 2, 4, 4, 1),
(5415, 'EED 416', 'ENTREPRENEURSHIP DEVELOPMENT', 2, 4, 18, 1),
(5421, 'EEE 414', 'ANALOGUE ELECTRONICS III', 3, 4, 6, 1),
(5422, 'EEE 415', 'DIGITAL COMMUNICATION II', 3, 4, 6, 1),
(5423, 'EEE 417', 'ELECTRONIC DESIGN AND DRAFTING', 3, 4, 6, 1),
(5424, 'EEE 418', 'MICROPROCESSOR APPLICATIONS', 3, 4, 6, 1),
(5428, 'EEI 311', 'ELECTRICAL MEASUREMENT & CONTROL III', 3, 3, 6, 1),
(5429, 'EEI 411', 'ELECTRONIC MEASUREMENT AND CONTROL IV', 3, 4, 6, 1),
(5431, 'EST 111', 'INTRODUCTION TO ESTATE MANAGEMENT', 2, 1, 10, 1),
(5432, 'EST 112', 'INTRODUCTION TO ACCOUNTING', 2, 1, 10, 1),
(5433, 'EST 113', 'NIGERIA LEGAL SYSTEMS', 2, 1, 10, 1),
(5439, 'EST 211', 'PRINCIPLES OF VALUATION I', 3, 2, 10, 1),
(5440, 'EST 212', 'LAND LAW I', 2, 2, 10, 1),
(5441, 'EST 213', 'INTRODUCTION TO PROPERTY DEVELOPMENT', 2, 2, 10, 1),
(5442, 'EST 214', 'RURAL LAND USE ECONOMICS', 2, 2, 10, 1),
(5443, 'EST 215', 'PROPERTY TAXATION', 2, 2, 10, 1),
(5444, 'EST 216', 'ESTATE REPORT WRITING', 2, 2, 10, 1),
(5454, 'FST 111', 'INTRODUCTION TO FOOD SCIENCE AND COMMODITIES', 3, 1, 15, 1),
(5457, 'FST 211', 'FOOD BIOCHEMISTRY', 2, 2, 15, 1),
(5458, 'FST 212', 'FOOD ANALYSIS', 2, 2, 15, 1),
(5459, 'FST 213', 'FOOD PROCESS ENGINEERING', 2, 2, 15, 1),
(5460, 'FST 214', 'FOOD MICROBIOLOGY', 2, 2, 15, 1),
(5461, 'FST 215', 'BASIC HEAT TRANSFER AND FLUID MECHANICS ', 2, 2, 15, 1),
(5462, 'FST 216', 'PROCESSING AND PRESERVATION OF PLANT FOOD PRODUCTS', 3, 2, 15, 1),
(5469, 'GIT 211', 'ELEMENTS OF GEOINFORMATICS', 2, 2, 27, 1),
(5470, 'GIT 213', 'DATABASE CREATION & USAGE IN GEOINFORMATICS', 2, 2, 27, 1),
(5471, 'GLT 111', 'MODULES I AND II', 2, 1, 15, 1),
(5472, 'GLT 111', 'GENERAL LABORATORY TECHNIQUES', 2, 1, 7, 1),
(5476, 'GLT 311', 'LABORATORY MANAGEMENT', 2, 3, 17, 1),
(5477, 'GLT 311', 'LABORATORY MANAGEMENT', 2, 3, 18, 1),
(5478, 'GLT 311', 'LABORATORY MANAGEMENT', 2, 3, 16, 1),
(5479, 'GLT 312', 'GENERAL INSTRUMENTATION', 2, 3, 16, 1),
(5480, 'GLT 312', 'INSTRUMENTATION (GENERAL)', 3, 3, 18, 1),
(5481, 'GLT 312', 'GENERAL INSTRUMENTATION', 2, 3, 17, 1),
(5485, 'GLT 311', 'LABORATORY MANAGEMENT', 2, 3, 19, 1),
(5486, 'GLT 312', 'GENERAL INSTRUMENTATION', 3, 3, 19, 1),
(5488, 'GNS 112', 'USE OF ENGLISH I', 2, 1, 11, 1),
(5489, 'GNS 112', 'USE OF ENGLISH I', 2, 1, 13, 1),
(5490, 'GNS 112', 'TECHNICAL ENGLISH I', 2, 1, 12, 1),
(5491, 'GNS 112', 'USE OF ENGLISH', 2, 1, 14, 1),
(5492, 'GNS 112', 'USE OF ENGLISH I', 2, 1, 26, 1),
(5493, 'GNS 112', 'USE OF ENGLISH I', 2, 1, 27, 1),
(5494, 'GNS 112', 'USE OF ENGLISH', 2, 1, 22, 1),
(5495, 'GNS 112', 'USE OF ENGLISH', 2, 1, 6, 1),
(5496, 'GNS 112', 'USE OF ENGLISH I', 2, 1, 10, 1),
(5497, 'GNS 112', 'TECHNICAL ENGLISH I', 2, 1, 2, 1),
(5498, 'GNS 112', 'TECHNICAL ENGLISH I', 2, 1, 3, 1),
(5499, 'GNS 112', 'USE OF ENGLISH I', 2, 1, 1, 1),
(5500, 'GNS 112', 'USE OF ENGLISH I', 2, 1, 9, 1),
(5501, 'GNS 112', 'COMMUNICATION IN ENGLISH (GRAMMAR)', 2, 1, 5, 1),
(5502, 'GNS 112', 'TECHNICAL ENGLISH', 2, 1, 4, 1),
(5503, 'GNS 112', 'USE OF ENGLISH', 2, 1, 8, 1),
(5519, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 11, 1),
(5520, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 13, 1),
(5521, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 15, 1),
(5522, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 12, 1),
(5523, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 14, 1),
(5524, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 26, 1),
(5525, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 22, 1),
(5526, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 27, 1),
(5527, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 6, 1),
(5528, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 10, 1),
(5529, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 3, 1),
(5530, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 2, 1),
(5531, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 1, 1),
(5532, 'GNS 111', 'CITIZENSHIP EDUCATION', 1, 1, 9, 1),
(5533, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 5, 1),
(5534, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 4, 1),
(5535, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 8, 1),
(5536, 'GNS 113', 'GENERAL PRINCIPLES OF LAW', 2, 1, 22, 1),
(5537, 'GNS 118', 'USE OF LIBRARY', 1, 1, 22, 1),
(5538, 'GNS 118', 'USE OF LIBRARY', 1, 1, 26, 1),
(5539, 'GNS 118', 'USE OF LIBRARY', 1, 1, 27, 1),
(5540, 'GNS 118', 'USE OF LIBRARY', 1, 1, 14, 1),
(5541, 'GNS 118', 'USE OF LIBRARY', 1, 1, 12, 1),
(5542, 'GNS 118', 'USE OF LIBRARY', 1, 1, 15, 1),
(5543, 'GNS 118', 'USE OF LIBRARY', 2, 1, 13, 1),
(5544, 'GNS 118', 'USE OF LIBRARY', 1, 1, 11, 1),
(5545, 'GNS 118', 'USE OF LIBRARY', 1, 1, 8, 1),
(5546, 'GNS 118', 'USE OF LIBRARY', 1, 1, 4, 1),
(5547, 'GNS 118', 'USE OF LIBRARY', 1, 1, 5, 1),
(5548, 'GNS 118', 'USE OF LIBRARY', 1, 1, 9, 1),
(5549, 'GNS 118', 'USE OF LIBRARY', 1, 1, 1, 1),
(5550, 'GNS 118', 'USE OF LIBRARY', 1, 1, 2, 1),
(5551, 'GNS 118', 'USE OF LIBRARY', 1, 1, 3, 1),
(5552, 'GNS 118', 'USE OF LIBRARY', 1, 1, 10, 1),
(5553, 'GNS 118', 'USE OF LIBRARY', 1, 1, 6, 1),
(5554, 'GNS 118', 'USE OF LIBRARY', 1, 1, 7, 1),
(5572, 'GNS 211', 'TECHNICAL ENGLISH', 2, 2, 2, 1),
(5573, 'GNS 211', 'USE OF ENGLISH', 2, 2, 10, 1),
(5574, 'GNS 211', 'USE OF ENGLISH II', 2, 2, 1, 1),
(5575, 'GNS 211', 'USE OF ENGLISH II', 2, 2, 8, 1),
(5576, 'GNS 211', 'COMMUNICATION SKILLS II', 2, 2, 9, 1),
(5577, 'GNS 211', 'USE OF ENGLISH II', 2, 2, 26, 1),
(5578, 'GNS 211', 'USE OF ENGLISH II', 2, 2, 22, 1),
(5579, 'GNS 211', 'USE OF ENGLISH II', 2, 2, 14, 1),
(5580, 'GNS 211', 'USE OF ENGLISH II', 2, 2, 11, 1),
(5581, 'GNS 211', 'USE OF ENGLISH I', 2, 2, 15, 1),
(5592, 'GNS 212', 'INTRODUCTION TO SOCIOLOGY', 2, 2, 8, 1),
(5593, 'GNS 212', 'INTRODUCTION TO SOCIOLOGY', 2, 2, 27, 1),
(5594, 'GNS 211', 'TECHNICAL ENGLISH', 2, 2, 4, 1),
(5598, 'GNS 318', 'BUSINESS COMMUNICATION I', 2, 3, 4, 1),
(5599, 'GNS 318', 'BUSINESS COMMUNICATION', 2, 3, 2, 1),
(5600, 'GNS 318', 'BUSINESS COMMUNICATION I', 3, 3, 3, 1),
(5601, 'GNS 318', 'USE OF ENGLISH', 2, 3, 16, 1),
(5602, 'GNS 318', 'USE OF ENGLISH', 2, 3, 18, 1),
(5603, 'GNS 318', 'USE OF ENGLISH', 2, 3, 17, 1),
(5611, 'GNS 311', 'ENGINEERING IN SOCIETY', 2, 3, 1, 1),
(5614, 'GNS 416', 'BUSINESS COMMUNICATION II', 2, 4, 3, 1),
(5615, 'GNS 411', 'LITERARY APPRECIATION AND ORAL COMPOSITION', 2, 4, 17, 1),
(5616, 'GNS 411', 'LITERARY APPRECIATION AND ORAL COMPOSITION', 2, 4, 18, 1),
(5618, 'GNS 413', 'INDUSTRIAL MANAGEMENT', 3, 4, 16, 1),
(5619, 'GNS 414', 'COMMUNICATION SKILLS', 2, 4, 4, 1),
(5621, 'HBF 315', 'ICT OFFICE APPLICATIONS I', 3, 3, 4, 1),
(5622, 'HLT 311', 'GENERAL HORTICULTURE', 3, 3, 17, 1),
(5623, 'ICT 111', 'INTRODUCTION TO COMPUTING', 2, 1, 5, 1),
(5624, 'ICT 111', 'INFORMATION TECHNOLOGY ESSENTIALS I', 2, 1, 2, 1),
(5625, 'ICT 115', 'NETWORK FUNDAMENTAL (CCNA)', 2, 1, 6, 1),
(5626, 'ICT 115', 'NETWORK FUNDAMENTAL (CCNA)', 2, 1, 1, 1),
(5648, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 5, 1),
(5649, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 9, 1),
(5650, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 8, 1),
(5651, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 1, 1),
(5652, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 4, 1),
(5653, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 6, 1),
(5654, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 7, 1),
(5655, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 10, 1),
(5656, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 3, 1),
(5657, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS III', 2, 2, 2, 1),
(5658, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 26, 1),
(5659, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 27, 1),
(5660, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS III', 3, 2, 15, 1),
(5661, 'ICT 211', 'INFORMATION AND COMMUNICATIONS TECHNOLOGY', 2, 2, 22, 1),
(5662, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 13, 1),
(5663, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 14, 1),
(5664, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 12, 1),
(5665, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 11, 1),
(5666, 'ICT 215', 'SWITCHING AND WIRELESS (CCNA)', 2, 2, 6, 1),
(5667, 'ICT 215', 'SWITCHING AND WIRELESS (CCNA)', 2, 2, 1, 1),
(5671, 'ICT 312', 'COMPUTER PACKAGES (AUTOCAD)', 3, 3, 1, 1),
(5672, 'ICT 312', 'COMPUTER PACKAGES I', 3, 3, 6, 1),
(5674, 'ICT 415', 'DATABASE PROGRAMMING WITH ORACLE', 2, 4, 1, 1),
(5677, 'INS 111', 'INTRODUCTION TO INSURANCE', 2, 1, 3, 1),
(5678, 'INS 111', 'INTRODUCTION TO INSURANCE', 2, 1, 12, 1),
(5680, 'LGS 212', 'LOCAL GOVERNMENT ADMINISTRATION II', 2, 2, 22, 1),
(5681, 'MAC 111', 'ENGLISH FOR MASS COMMUNICATION I', 2, 1, 8, 1),
(5682, 'MAC 112', 'FRENCH I', 2, 1, 8, 1),
(5683, 'MAC 113', 'YORUBA I', 2, 1, 8, 1),
(5684, 'MAC 114', 'INTRODUCTION TO COMMUNICATION', 3, 1, 8, 1),
(5685, 'MAC 115', 'INTRODUCTION TO NEWS GATHERING AND WRITING', 3, 1, 8, 1),
(5686, 'MAC 116', 'GRAPHIC ARTS AND DESIGN', 3, 1, 8, 1),
(5687, 'MAC 117', 'HISTORY AND POLITICS OF NIGERIA', 2, 1, 8, 1),
(5696, 'MAC 210', 'INTRODUCTION TO BOOK PUBLISHING', 2, 2, 8, 1),
(5697, 'MAC 211', 'ENGLISH FOR MASS COMMUNICATION II', 2, 2, 8, 1),
(5698, 'MAC 212', 'INTRODUCTION TO RESEARCH METHOD', 2, 2, 8, 1),
(5699, 'MAC 213', 'NEWSPAPER EDITING AND PRODUCTION', 2, 2, 8, 1),
(5700, 'MAC 214', 'FEATURE WRITING', 3, 2, 8, 1),
(5701, 'MAC 215', 'MASS MEDIA AND SOCIETY', 2, 2, 8, 1),
(5702, 'MAC 216', 'PHOTOGRAPHY AND PHOTO JOURNALISM', 2, 2, 8, 1),
(5703, 'MAC 217', 'BROADCASTING EDITING AND PRODUCTION I', 2, 2, 8, 1),
(5704, 'MAC 218', 'ACCOUNT AND BRAND MANAGEMENT', 2, 2, 8, 1),
(5716, 'MEC 117', 'MECHANICAL ENGINEERING SCIENCE', 2, 1, 5, 1),
(5717, 'MEC 111', 'MECHANICAL ENGINEERING SCIENCE', 3, 1, 1, 1),
(5719, 'MEC 112', 'TECHNICAL DRAWING', 2, 1, 1, 1),
(5720, 'MEC 112', 'TECHNICAL DRAWING', 2, 1, 5, 1),
(5721, 'MEC 112', 'TECHNICAL DRAWING', 1, 1, 6, 1),
(5722, 'MEC 111', 'MECHANICAL ENGINEERING SCIENCE (STATICS)', 3, 1, 13, 1),
(5723, 'MEC 112', 'TECHNICAL DRAWING', 3, 1, 13, 1),
(5724, 'MEC 113', 'BASIC WORKSHOP TECHNOLOGY AND PRACTICE', 2, 1, 6, 1),
(5725, 'MEC 113', 'MECHANICAL WORKSHOP TECHNIQUE AND PRACTICE I', 2, 1, 1, 1),
(5726, 'MEC 113', 'BASIC WORKSHOP TECHNOLOGY AND PRACTICE', 3, 1, 13, 1),
(5733, 'MEC 211', 'ENGINEERING DRAWING', 3, 2, 5, 1),
(5734, 'MEC 211', 'ENGINEERING DRAWING I', 3, 2, 13, 1),
(5735, 'MEC 212', 'ENGINEERING MEASUREMENT', 2, 2, 13, 1),
(5736, 'MEC 212', 'ENGINEERING MEASUREMENT', 2, 2, 5, 1),
(5737, 'MEC 213', 'THERMODYNAMICS II', 3, 2, 13, 1),
(5738, 'MEC 214', 'FLUID MECHANICS', 3, 2, 13, 1),
(5739, 'MEC 214', 'FLUIDS MECHANICS', 2, 2, 5, 1),
(5740, 'MEC 215', 'FOUNDRY TECHNOLOGY AND FORGING OPERATIONS', 2, 2, 13, 1),
(5741, 'MEC 217', 'TECHNICAL REPORT WRITING', 2, 2, 13, 1),
(5742, 'MEC 217', 'TECHNICAL REPORT WRITING', 2, 2, 5, 1),
(5743, 'MEC 219', 'INTRODUCTION TO COMPUTER AIDED DESIGN (CAD)', 2, 2, 13, 1),
(5754, 'MKT 111', 'FUNDAMENTAL OF MARKETING', 3, 1, 9, 1),
(5755, 'MKT 111', 'FUNDAMENTAL OF MARKETING', 2, 1, 8, 1),
(5756, 'MKT 112', 'BUSINESS MATHEMATICS I', 2, 1, 9, 1),
(5757, 'MKT 113', 'PRINCIPLE OF LAW', 2, 1, 9, 1),
(5758, 'MKT 114', 'PRINCIPLES OF ECONOMICS I', 2, 1, 9, 1),
(5759, 'MKT 115', 'CONSUMER BEHAVIOUR', 2, 1, 9, 1),
(5760, 'MKT 116', 'MARKETING ENVIRONMENT', 2, 1, 9, 1),
(5765, 'MKT 211', 'MARKETING MANAGEMENT', 2, 2, 9, 1),
(5766, 'MKT 212', 'BUSINESS STATISTICS I', 2, 2, 9, 1),
(5768, 'MKT 214', 'RESEARCH METHODOLOGY', 2, 2, 9, 1),
(5769, 'MKT 215', 'INTRODUCTION TO ADVERTISING & PUBLIC RELATIONS', 2, 2, 9, 1),
(5775, 'MKT 415', 'MARKETING MANAGEMENT', 3, 4, 4, 1),
(5776, 'MTH 111', 'LOGIC AND LINEAR ALGEBRA', 2, 1, 2, 1),
(5777, 'MTH 111', 'LOGIC AND LINEAR ALGEBRA', 2, 1, 10, 1),
(5778, 'MTH 111', 'LOGIC AND LINEAR ALGEBRA', 2, 1, 27, 1),
(5779, 'MTH 111', 'LOGIC AND LINEAR ALGEBRA', 2, 1, 26, 1),
(5780, 'MTH 111', 'LOGIC AND LINEAR ALGEBRA', 2, 1, 13, 1),
(5781, 'MTH 111', 'LOGIC AND LINEAR ALGEBRA', 2, 1, 15, 1),
(5783, 'MTH 113', 'FUNCTIONS AND GOEMETRY', 2, 1, 14, 1),
(5784, 'MTH 113', 'FUNCTIONS AND GOEMETRY', 2, 1, 13, 1),
(5785, 'MTH 112', 'ALGEBRA AND ELEMENTARY TRIGONOMETRY', 2, 1, 26, 1),
(5786, 'MTH 113', 'FUNCTIONS AND GOEMETRY', 2, 1, 6, 1),
(5787, 'MTH 113', 'FUNCTIONS AND GOEMETRY', 2, 1, 2, 1),
(5788, 'MTH 113', 'FUNCTIONS AND GOEMETRY', 2, 1, 1, 1),
(5789, 'MTH 113', 'FUNCTIONS AND GOEMETRY', 2, 1, 5, 1),
(5793, 'MTH 113', 'FUNCTIONS AND GOEMETRY', 2, 1, 10, 1),
(5796, 'MTH 121', 'CALCULUS', 2, 2, 14, 1),
(5798, 'MTH 212', 'LOGIC AND LINEAR ALGEBRA', 2, 2, 6, 1),
(5799, 'MTH 212', 'LOGIC AND LINEAR ALGEBRA', 2, 2, 1, 1),
(5800, 'MTH 212', 'LOGIC AND LINEAR ALGEBRA', 2, 2, 5, 1),
(5806, 'MTH 211', 'CALCULUS', 2, 2, 27, 1),
(5808, 'MTH 311', 'ADVANCE ALGEBRA', 3, 3, 6, 1),
(5809, 'MTH 311', 'MATHEMATICS III (ADVANCED ALGEBRA)', 2, 3, 1, 1),
(5810, 'MTH 312', 'NUMERICAL METHODS', 2, 3, 2, 1),
(5811, 'MTH 316', 'MATHEMATICAL METHODS I', 2, 3, 2, 1),
(5815, 'MTH 411', 'MATHEMATICS(NUMERICAL METHODS)', 2, 4, 1, 1),
(5816, 'MTH 411', 'NUMERICAL METHODS', 2, 4, 6, 1),
(5820, 'OTM 114', 'BEGINNERS FRENCH I', 2, 1, 11, 1),
(5822, 'OTM 111', 'SHORTHAND I (40WPM)', 3, 1, 11, 1),
(5823, 'OTM 112', 'KEYBOARDING I (20WPM)', 3, 1, 11, 1),
(5824, 'OTM 113', 'OFFICE PRACTICE I', 2, 1, 11, 1),
(5829, 'OTM 213', 'BEGINNERS FRENCH III', 2, 2, 11, 1),
(5831, 'OTM 211', 'SHORTHAND III (80WPM)', 3, 2, 11, 1),
(5832, 'OTM 212', 'KEYBOARDING III (35WPM)', 3, 2, 11, 1),
(5833, 'OTM 215', 'ELECTRONIC OFFICE TECHNOLOGY', 3, 2, 11, 1),
(5834, 'OTM 214', 'OFFICE PRACTICE II', 2, 2, 11, 1),
(5835, 'OTM 216', 'RESEARCH TECHNIQUES', 2, 2, 11, 1),
(5845, 'PAD 111', 'ELEMENTS OF PUBLIC ADMINISTRATION', 3, 1, 22, 1),
(5846, 'PAD 112', 'THEORIES OF ADMINISTRATION & MANAGEMENT', 2, 1, 22, 1),
(5847, 'PAD 113', 'ELEMENTS OF GOVERNMENT', 3, 1, 22, 1),
(5848, 'PAD 114', 'PRINCIPLES OF ECONOMICS I', 3, 1, 22, 1),
(5849, 'PAD 115', 'INTRODUCTION TO PSYCHOLOGY', 2, 1, 22, 1),
(5850, 'PAD 116', 'BUSINESS MATHEMATICS', 2, 1, 22, 1),
(5857, 'PAD 211', 'INTRODUCTION TO PUBLIC FINANCE', 3, 2, 22, 1),
(5858, 'PAD 212', 'NIGERIAN GOVERNMENT & POLITICS II', 2, 2, 22, 1),
(5859, 'PAD 213', 'PRINCIPLES OF HUMAN RESOURCES MANAGEMENT', 3, 2, 22, 1),
(5860, 'PAD 214', 'INTRODUCTION TO PUBLIC ENTERPRISES MANAGEMENT', 2, 2, 22, 1),
(5861, 'PAD 215', 'RESEARCH METHODS', 2, 2, 22, 1),
(5862, 'PAD 217', 'OFFICE MANAGEMENT', 2, 2, 22, 1),
(5869, 'PAS 111', 'PRINCIPLES OF PURCHASING', 2, 1, 9, 1),
(5871, 'PHE 111', 'PHYSICAL AND HEALTH EDUCATION', 1, 1, 10, 1),
(5872, 'PTD 111', 'TECHNICAL DRAWING', 2, 1, 15, 1),
(5874, 'QUS 213', 'MEASURING OF BUILDING WORKS', 2, 2, 26, 1),
(5875, 'QUS 211', 'TENDERING & ESTIMATING I', 2, 2, 26, 1),
(5877, 'STA 111', 'INTRODUCTION TO STATISTICS', 2, 1, 27, 1),
(5878, 'STA 111', 'INTRODUCTION TO STATISTICS', 2, 1, 11, 1),
(5879, 'STA 111', 'INTRODUCTION TO STATISTICS', 2, 1, 10, 1),
(5880, 'STA 111', 'DESCRIPTIVE STATISTICS I', 2, 1, 7, 1),
(5881, 'STA 111', 'INTRODUCTION TO STATISTICS', 2, 1, 1, 1),
(5882, 'STA 111', 'DESCRIPTIVE STATISTICS I', 2, 1, 2, 1),
(5883, 'STA 112', 'ELEMENTARY PROBABILITY THEORY', 2, 1, 2, 1),
(5887, 'STA 311', 'STATISTICAL THEORY I', 3, 3, 2, 1),
(5888, 'STA 314', 'OPERATING RESEARCH I', 3, 3, 2, 1),
(5890, 'STA 411', 'OPERATIONS RESEARCH II', 3, 4, 2, 1),
(5891, 'STA 418', 'SMALL BUSINESS MANAGEMENT II', 2, 4, 19, 1),
(5892, 'STB 111', 'PLANT AND ANIMAL TAXONOMY', 3, 1, 7, 1),
(5893, 'STB 112', 'MORPHOLOGY AND PHYSIOLOGY OF LIVING THINGS', 2, 1, 7, 1),
(5894, 'STB 112', 'MORPHOLOGY AND PHYSIOLOGY OF LIVING ORGANISM', 3, 1, 15, 1),
(5895, 'STB 113', 'GENERAL BIOLOGY', 2, 1, 12, 1),
(5896, 'STB 113', 'GENERAL BIOLOGY', 2, 1, 22, 1),
(5897, 'STB 113', 'GENERAL BIOLOGY', 2, 1, 3, 1),
(5898, 'STB 113', 'GENERAL BIOLOGY', 2, 1, 4, 1),
(5901, 'STB 211', 'PEST AND PESTS CONTROL', 2, 2, 7, 1),
(5905, 'STB 311', 'APPLIED ECOLOGY AND ENVIRONMENTAL MANAGEMENT', 3, 3, 17, 1),
(5906, 'STB 312', 'ECOLOGICAL DISASTER AND CONTROL', 2, 3, 17, 1),
(5907, 'STB 313', 'APPLIED GENETICS (PLANT BREEDING)', 3, 3, 17, 1),
(5908, 'STB 314', 'BIOLOGICAL TECHNIQUES I', 3, 3, 17, 1),
(5917, 'STB 411', 'PRINCIPLES OF TOXICOLOGY II', 3, 4, 17, 1),
(5918, 'STB 412', 'ENVIRONMENTAL IMPACT ASSESSMENT AND MONITORING', 3, 4, 17, 1),
(5919, 'STB 413', 'ENVIRONMENTAL MICROBIOLOGY', 2, 4, 17, 1),
(5920, 'STB 414', 'HYDROBIOLOGY AND FISHERIES', 3, 4, 17, 1),
(5921, 'STB 415', 'PRINCIPLES OF NATIONAL RESOURCES MANAGEMENT', 2, 4, 17, 1),
(5922, 'STB 416', 'BIOLOGICAL TECHNIQUES III', 2, 4, 17, 1),
(5923, 'STB 417', 'SEMINAR', 2, 4, 17, 1),
(5931, 'STC 111', 'GENERAL PRINCIPLES OF CHEMISTRY', 3, 1, 15, 1),
(5932, 'STC 111', 'GENERAL PRINCIPLE OF CHEMISTRY', 3, 1, 7, 1),
(5933, 'STC 112', 'INORGANIC CHEMISTRY I', 2, 1, 7, 1),
(5934, 'GNS 112', 'TECHNICAL ENGLISH', 2, 1, 7, 1),
(5939, 'STC 211', 'INORGANIC CHEMISTRY II', 2, 2, 7, 1),
(5940, 'STC 212', 'INSTRUMENTAL ANALYTICAL CHEMISTRY QUALITY CONTROL', 3, 2, 7, 1),
(5943, 'STC 311', 'INORGANIC CHEMISTRY I', 3, 3, 19, 1),
(5944, 'STC 312', 'PHYSICAL CHEMISTRY I', 3, 3, 19, 1),
(5945, 'STC 313', 'ORGANIC CHEMISTRY I', 3, 3, 19, 1),
(5946, 'STC 314', 'ANALYTICAL CHEMISTRY I', 3, 3, 19, 1),
(5947, 'STC 316', 'HIGHER TECHNICAL ENGLISH', 3, 3, 19, 1),
(5954, 'STC 411', 'INORGANIC CHEMISTRY II', 3, 4, 19, 1),
(5955, 'STC 412', 'PHYSICAL CHEMISTRY III', 3, 4, 19, 1),
(5956, 'STC 413', 'ORGANIC AND HETEROCYCLIC CHEMISTRY', 3, 4, 19, 1),
(5957, 'STC 414', 'ANALYTICAL CHEMISTRY III', 3, 4, 19, 1),
(5958, 'STC 415', 'PETROLEUM AND PETROCHEMICALS', 3, 4, 19, 1),
(5959, 'STC 416', 'COMPUTER APPLICATIONS IN CHEMISTRY', 2, 4, 19, 1),
(5960, 'STC 417', 'SEMINAR', 2, 4, 19, 1),
(5966, 'STH 314', 'MICROBIAL BIOCHEMISTRY', 2, 3, 16, 1),
(5967, 'STH 311', 'BIOCHEMICAL METHODS I', 3, 3, 18, 1),
(5968, 'STH 312', 'PHYSICAL BIOCHEMISTRY I', 2, 3, 18, 1),
(5969, 'STH 313', 'MICROBIAL IMMUNOCHEMISTRY', 3, 3, 18, 1),
(5975, 'STH 411', 'INTERMEDIARY METABOLISM II', 2, 4, 18, 1),
(5976, 'STH 412', 'NUTRITIONAL BIOCHEMISTRY II', 2, 4, 18, 1),
(5977, 'STH 413', 'BIOTECHNOLOGY AND GENETIC ENGINEERING', 3, 4, 18, 1),
(5978, 'STH 414', 'SEMINAR', 2, 4, 18, 1),
(5985, 'STM 211', 'MICROBIOLOGY', 2, 2, 7, 1),
(5986, 'STM 311', 'BACTERIOLOGY', 3, 3, 16, 1),
(5987, 'STM 312', 'MICROBIOLOGICAL TECHNIQUES I', 2, 3, 16, 1),
(5995, 'STM 411', 'MICROBIAL GENETICS', 2, 4, 16, 1),
(5996, 'STM 412', 'MICROBIOLOGICAL TECHNIQUES III', 2, 4, 16, 1),
(5997, 'STM 413', 'PHARMACEUTICAL MICROBIOLOGY', 3, 4, 16, 1),
(5998, 'STM 414', 'PATHOGENIC MICROBIOLOGY', 3, 4, 16, 1),
(5999, 'STM 415', 'IMMUNOLOGY AND PUBLIC HEALTH', 2, 4, 16, 1),
(6000, 'STM 416', 'SEMINAR', 2, 4, 16, 1),
(6001, 'STM 418', 'APPLIED GENETICS (PLANT BREEDING)', 3, 4, 16, 1),
(6006, 'STP 111', 'MECHANICS', 3, 1, 7, 1),
(6007, 'STP 112', 'HEAT ENERGY', 2, 1, 7, 1),
(6008, 'STP 113', 'ALGEBRA FOR SCIENCE', 2, 1, 7, 1),
(6012, 'STP 211', 'ELECTRONICS', 2, 2, 7, 1),
(6013, 'STP 212', 'THERMODYNAMICS AND ELECTRO MAGNETISM', 2, 2, 7, 1),
(6014, 'STP 213', 'CALCULUS FOR SCIENCE', 2, 2, 7, 1),
(6016, 'STS 211', 'CITIZENSHIP EDUCATION', 2, 2, 7, 1),
(6017, 'STS 212', 'SEMINAR', 2, 2, 7, 1),
(6019, 'SUG 111', 'PRINCIPLE OF SURVEYING I', 2, 1, 10, 1),
(6020, 'SUG 111', 'BASIC PRINCIPLES OF SURVEYING I', 2, 1, 14, 1),
(6021, 'SUG 111', 'BASIC PRINCIPLES IN SURVEYING I', 3, 1, 27, 1),
(6024, 'SUG 113', 'INTRODUCTION TO PHOTOGRAMMETRY & REMOTE SENSING I', 3, 1, 27, 1),
(6026, 'SUG 115', 'BASIC PRINCIPLES IN CARTOGRAPHY I', 3, 1, 27, 1),
(6030, 'SUG 211', 'CADASTRAL SURVEYING II', 3, 2, 27, 1),
(6032, 'SUG 213', 'FIELD ASTRONOMY I', 2, 2, 27, 1),
(6034, 'SUG 217', 'SURVEYING INSTRUMENT I', 2, 2, 27, 1),
(6036, 'SUG 219', 'CONTROL SURVEYS', 2, 2, 27, 1),
(6057, 'SUG 111', 'BASIC PRINCIPLES IN SURVEYING I', 3, 1, 26, 1),
(6059, 'URP 217', 'URBAN AND REGIONAL PLANNING PRINCIPLES AND', 2, 2, 10, 1),
(6060, 'WEC 110', 'MATERIAL SCIENCE I', 2, 1, 5, 1),
(6061, 'WEC 111', 'FABRICATION TECHNOLOGY', 3, 1, 5, 1),
(6062, 'WEC 112', 'WELDING TECHNOLOGY I', 3, 1, 5, 1),
(6063, 'WEC 113', 'WELDING AND ENVIRONMENT SAFETY', 2, 1, 5, 1),
(6069, 'WEC 210', 'WELDING METALLURGY II', 2, 2, 5, 1),
(6070, 'WEC 211', 'WELDING TECHNOLOGY III', 3, 2, 5, 1),
(6071, 'WEC 212', 'BASIC THERMODYNAMICS', 2, 2, 5, 1),
(6072, 'WEC 219', 'PROJECT/SEMINAR', 2, 2, 5, 1),
(6079, 'GNS 311', 'ENGINEERING IN SOCIETY', 2, 3, 6, 1),
(6081, 'PCT 111', 'INTRODUCTION TO PHARMACOLOGY', 3, 1, 34, 1),
(6082, 'PCT 112', 'FIRST AID ETHICS', 2, 1, 34, 1),
(6083, 'BCH 111', 'GENERAL PRINCIPLES OF CHEMISTRY', 3, 1, 34, 1),
(6084, 'BPH 111', 'MECHANICS AND PROPERTIES OF MATTER AND HEAT ENERGY', 3, 1, 34, 1),
(6085, 'PTD 111', 'TECHNICAL DRAWING', 3, 1, 34, 1),
(6086, 'GLT 111', 'GENERAL LABORATORY TECHNIQUES', 3, 1, 34, 1),
(6087, 'COM 111', 'INTRODUCTION TO COMPUTING', 2, 1, 34, 1),
(6088, 'MTH 112', 'ALGEBRA AND ELEMENTARY TRIGONOMETRY', 2, 1, 34, 1),
(6089, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 34, 1),
(6090, 'GNS 118', 'USE OF LIBRARY', 1, 1, 34, 1),
(6091, 'GNS 112', 'USE OF ENGLISH', 2, 1, 34, 1),
(6092, 'CHE 111', 'INTRODUCTION TO CHEMICAL ENGINEERING AND PROCESSES', 2, 1, 34, 1),
(6104, 'PCT 211', 'COMPOUNDING I', 2, 2, 34, 1),
(6105, 'PCT 212', 'GENERAL DISPENSING PRACTICE', 2, 2, 34, 1),
(6106, 'PCT 213', 'INTRODUCTION TO DRUG QUALITY CONTROL', 2, 2, 34, 1),
(6107, 'CME 212', 'UNIT OPERATION I', 3, 2, 34, 1),
(6108, 'FST 212', 'FOOD ANALYSIS', 3, 2, 34, 1),
(6109, 'EED 216', 'PRACTICE OF ENTREPRENEURSHIP', 2, 2, 34, 1),
(6110, 'COM 215', 'COMPUTER PACKAGES II', 2, 2, 34, 1),
(6111, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 3, 2, 34, 1),
(6112, 'GNS 211', 'USE OF ENGLISH II', 2, 2, 34, 1),
(6123, 'GNS 212', 'INTRODUCTION TO MEDICAL SOCIOLOGY', 2, 2, 34, 1),
(6124, 'PAS 111', 'PRINCIPLES OF PROCUREMENT', 3, 1, 30, 1),
(6125, 'BAM 112', 'BUSINESS MATHEMATICS I', 2, 1, 30, 1),
(6126, 'PAS 113', 'PRINCIPLES OF LAW', 2, 1, 30, 1),
(6127, 'PAS 114', 'PRINCIPLES OF ECONOMICS I', 2, 1, 30, 1),
(6128, 'PAS 115', 'INVENTORY ADMINISTRATION AND CONTROL I', 3, 1, 30, 1),
(6129, 'PAS 116', 'LOGISTICS MANAGEMENT AND DISTRIBUTION I', 2, 1, 30, 1),
(6130, 'ACC 111', 'PRINCIPLES OF ACCOUNTS I', 2, 1, 30, 1),
(6131, 'MKT 111', 'FUNDAMENTAL OF MARKETING', 2, 1, 30, 1),
(6132, 'COM 111', 'COMPUTER APPRECIATION', 2, 1, 30, 1),
(6133, 'GNS 112', 'USE OF ENGLISH I', 2, 1, 30, 1),
(6134, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 30, 1),
(6135, 'GNS 118', 'USE OF LIBRARY', 1, 1, 30, 1),
(6148, 'PAS 211', 'PRACTICE OF PROCUREMENT I', 2, 2, 30, 1),
(6149, 'PAS 212', 'STORE DESIGN AND MATERIAL HANDLING I', 2, 2, 30, 1),
(6150, 'PAS 213', 'INTRODUCTION TO SUPPLY CHAIN MANAGEMENT', 2, 2, 30, 1),
(6151, 'PAS 214', 'BUSINESS RESEARCH METHODS', 2, 2, 30, 1),
(6152, 'MKT 211', 'MARKETING MANAGEMENT', 2, 2, 30, 1),
(6153, 'BAM 211', 'PRINCIPLES OF MANAGEMENT I', 2, 2, 30, 1),
(6154, 'BAM 214', 'BUSINESS LAW', 2, 2, 30, 1),
(6155, 'ACC 212', 'COST ACCOUNTING I', 2, 2, 30, 1),
(6156, 'GNS 211', 'COMMUNICATION SKILLS II', 2, 2, 30, 1),
(6157, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 2, 2, 30, 1),
(6168, 'INS 111', 'INTRODUCTION TO INSURANCE', 3, 1, 25, 1),
(6169, 'BAM 112', 'BUSINESS MATHEMATICS I', 2, 1, 25, 1),
(6170, 'GNS 112', 'TECHNICAL ENGLISH I', 2, 1, 25, 1),
(6171, 'BFN 112', 'PRINCIPLES OF ECONOMICS I', 2, 1, 25, 1),
(6172, 'BAM 113', 'PRINCIPLES OF LAW', 2, 1, 25, 1),
(6173, 'BAM 111', 'PRINCIPLES OF MANAGEMENT I', 2, 1, 25, 1),
(6174, 'ACC 111', 'PRINCIPLES OF ACCOUNTS I', 2, 1, 25, 1),
(6175, 'GNS 111', 'CITIZENSHIP EDUCATION', 2, 1, 25, 1),
(6176, 'BFN 111', 'ELEMENTS OF BANKING I', 2, 1, 25, 1),
(6177, 'BAM 115', 'PRINCIPLES OF MARKETING', 2, 1, 25, 1),
(6178, 'GNS 118', 'USE OF LIBRARY', 1, 1, 25, 1),
(6179, 'COM 111', 'INTRODUCTION TO COMPUTER', 2, 1, 25, 1),
(6180, 'STB 113', 'GENERAL BIOLOGY', 2, 1, 25, 1),
(6192, 'INS 211', 'LIFE ASSURANCE UNDERWRITING I', 3, 2, 25, 1),
(6193, 'INS 212', 'INSURANCE OF LIABILITY I', 2, 2, 25, 1),
(6194, 'INS 213', 'INSURANCE OF PERSON I', 2, 2, 25, 1),
(6195, 'INS 214', 'MOTOR INSURANCE I', 2, 2, 25, 1),
(6196, 'INS 215', 'PROPERTY AND PECUNIARY INSURANCE I', 3, 2, 25, 1),
(6197, 'INS 216', 'RESEARCH METHODOLOGY', 2, 2, 25, 1),
(6198, 'MKT 215', 'MARKETING OF INSURANCE SERVICES', 2, 2, 25, 1),
(6199, 'BAM 212', 'BUSINESS STATISTICS I', 2, 2, 25, 1),
(6200, 'EED 216', 'PRACTICE OF ENTREPRENEURSHIP', 2, 2, 25, 1),
(6201, 'ACC 211', 'FINANCIAL ACCOUNTING I', 2, 2, 25, 1),
(6202, 'ICT 211', 'INFORMATION TECHNOLOGY ESSENTIALS II', 2, 2, 25, 1);

-- --------------------------------------------------------

--
-- Table structure for table `days`
--

CREATE TABLE `days` (
  `day_id` int(5) NOT NULL,
  `day` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `days`
--

INSERT INTO `days` (`day_id`, `day`) VALUES
(1, 'Monday'),
(2, 'Tuesday'),
(3, 'Wednesday'),
(4, 'Thursday'),
(5, 'Friday'),
(6, 'Saturday'),
(7, 'Sunday');

-- --------------------------------------------------------

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `department_id` int(255) NOT NULL,
  `department_name` varchar(50) NOT NULL,
  `dept_code` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`department_id`, `department_name`, `dept_code`) VALUES
(1, 'COMPUTER ENGINEERING', 'C/E'),
(2, 'COMPUTER SCIENCE', 'C/S'),
(3, 'ACCOUNTANCY', 'ACC'),
(4, 'BUSINESS ADMINISTRATION', 'B/A'),
(5, 'WELDING AND FABRICATION', 'WELD'),
(6, 'ELECTRICAL / ELECTRONICS ENGINEERING', 'E/E'),
(7, 'SCIENCE LABORATORY TECHNOLOGY', 'SLT'),
(8, 'MASS COMMUNICATION', 'M/C'),
(9, 'MARKETING', 'MKT'),
(10, 'ESTATE MANAGEMENT AND VALUATION', 'EST'),
(11, 'OFFICE TECHNOLOGY AND MANAGEMENT', 'OTM'),
(12, 'BANKING AND FINANCE', 'B/F'),
(13, 'MECHANICAL ENGINEERING', 'M/E'),
(14, 'ARCHITECTURE', 'ARC'),
(15, 'FOOD TECHNOLOGY', 'FST'),
(16, 'MICROBIOLOGY', 'MICR'),
(17, 'ENVIRONMENTAL BIOLOGY', 'E/B'),
(18, 'BIO-CHEMISTRY', 'B/C'),
(19, 'CHEMISTRY', 'CHEM'),
(22, 'PUBLIC ADMINISTRATION', 'PAD'),
(25, 'INSURANCE', 'INS'),
(26, 'BUILDING TECHNOLOGY', 'B/T'),
(27, 'SURVEYING AND GEO-INFORMATICS', 'SURVEY'),
(30, 'PURCHASING AND SUPPLY', 'P/S'),
(31, 'ANIMAL HEALTH AND PRODUCTION', 'ANI'),
(32, 'FISHERIES TECHNOLOGY', 'FISH'),
(33, 'WILDLIFE AND ECO-TOURISM', 'WILDLIFE'),
(34, 'PHARMACEUTICAL TECHNOLOGY', 'P/T'),
(35, 'RENEWABLE ENGINEERING', 'R/E');

-- --------------------------------------------------------

--
-- Table structure for table `lecture`
--

CREATE TABLE `lecture` (
  `lecture_id` int(255) NOT NULL,
  `course_id` int(255) NOT NULL,
  `combined_id` int(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lecture`
--

INSERT INTO `lecture` (`lecture_id`, `course_id`, `combined_id`) VALUES
(1, 5030, 1),
(2, 5031, 2),
(3, 5043, 3),
(4, 5046, 4),
(5, 5785, 5),
(6, 6088, 6),
(7, 6008, 7),
(8, 5946, 8),
(9, 5044, 9),
(10, 5014, 10),
(11, 6071, 11),
(12, 5209, 12),
(13, 5724, 13),
(14, 5726, 14),
(15, 5167, 16),
(16, 5171, 16),
(17, 5184, 17),
(18, 5599, 18),
(19, 5598, 19),
(20, 5600, 20),
(21, 5614, 21),
(22, 5384, 22),
(23, 5411, 23),
(24, 5155, 24),
(25, 5156, 24),
(26, 5107, 26),
(27, 5108, 27),
(28, 6154, 28),
(29, 5850, 33),
(30, 5078, 30),
(31, 5079, 32),
(32, 5080, 32),
(33, 5756, 33),
(34, 6125, 34),
(35, 6169, 35),
(36, 5132, 36),
(37, 5110, 37),
(38, 5158, 38),
(39, 5159, 39),
(40, 6151, 40),
(41, 5103, 41),
(42, 5104, 42),
(43, 5105, 42),
(44, 5766, 44),
(45, 6199, 45),
(46, 5796, 46),
(47, 5806, 47),
(48, 6014, 47),
(49, 5519, 49),
(50, 5520, 50),
(51, 5521, 51),
(52, 5522, 52),
(53, 5523, 53),
(54, 5524, 54),
(55, 5525, 55),
(56, 5526, 56),
(57, 5527, 57),
(58, 5528, 58),
(59, 5529, 59),
(60, 5530, 60),
(61, 5531, 61),
(62, 5532, 62),
(63, 5533, 63),
(64, 5534, 64),
(65, 5535, 65),
(66, 6016, 66),
(67, 6089, 67),
(68, 6134, 68),
(69, 6175, 69),
(70, 5245, 70),
(71, 5501, 71),
(72, 5619, 72),
(73, 5576, 73),
(74, 6156, 74),
(75, 5135, 75),
(76, 5280, 76),
(77, 5263, 77),
(78, 5265, 78),
(79, 5214, 79),
(80, 6132, 80),
(81, 5269, 81),
(82, 5297, 82),
(83, 5312, 83),
(84, 5327, 84),
(85, 5313, 85),
(86, 5277, 86),
(87, 5671, 87),
(88, 5196, 88),
(89, 5246, 89),
(90, 5672, 90),
(91, 5248, 93),
(92, 5249, 92),
(93, 5250, 93),
(94, 6110, 94),
(95, 5278, 95),
(96, 5253, 96),
(97, 5268, 97),
(98, 5304, 98),
(99, 5243, 99),
(100, 5251, 100),
(101, 5310, 101),
(102, 5293, 102),
(103, 5380, 103),
(104, 5008, 104),
(105, 5010, 105),
(106, 5011, 106),
(107, 5012, 107),
(108, 5013, 108),
(109, 6155, 109),
(110, 5281, 110),
(111, 5311, 111),
(112, 5109, 112),
(113, 5252, 113),
(114, 5267, 114),
(115, 5674, 115),
(116, 5880, 264),
(117, 5882, 264),
(118, 5296, 118),
(119, 5372, 119),
(120, 5350, 120),
(121, 5343, 121),
(122, 5344, 122),
(123, 5365, 123),
(124, 5366, 124),
(125, 5328, 125),
(126, 5323, 125),
(127, 5324, 125),
(128, 5320, 128),
(129, 5346, 129),
(130, 5363, 130),
(131, 5364, 131),
(132, 5368, 132),
(133, 5349, 133),
(134, 5345, 134),
(135, 5325, 135),
(136, 5326, 136),
(137, 5351, 138),
(138, 5352, 138),
(139, 5371, 139),
(140, 5423, 140),
(141, 6012, 141),
(142, 5347, 142),
(143, 5348, 143),
(144, 5369, 144),
(145, 5883, 145),
(146, 5145, 146),
(147, 5146, 146),
(148, 6176, 148),
(149, 5089, 149),
(150, 5845, 150),
(151, 5733, 151),
(152, 5611, 152),
(153, 6079, 153),
(154, 5735, 154),
(155, 5736, 155),
(156, 5681, 156),
(157, 5697, 157),
(158, 5414, 158),
(159, 5415, 159),
(160, 5410, 160),
(161, 5403, 317),
(162, 5413, 162),
(163, 5032, 163),
(164, 6061, 164),
(165, 5700, 165),
(166, 5247, 166),
(167, 5007, 167),
(168, 5009, 168),
(169, 6201, 169),
(170, 5045, 170),
(171, 5123, 171),
(172, 5739, 172),
(173, 5682, 173),
(174, 5783, 174),
(175, 5784, 175),
(176, 5786, 176),
(177, 5787, 177),
(178, 5788, 178),
(179, 5789, 179),
(180, 5793, 180),
(181, 5754, 181),
(182, 5755, 182),
(183, 6131, 183),
(184, 5895, 184),
(185, 5896, 186),
(186, 5897, 186),
(187, 5898, 184),
(188, 6180, 188),
(189, 5472, 568),
(190, 6086, 190),
(191, 5932, 565),
(192, 5686, 192),
(193, 6007, 193),
(194, 5687, 194),
(195, 5122, 195),
(196, 5621, 196),
(197, 5618, 197),
(198, 5134, 198),
(199, 5661, 199),
(200, 5624, 200),
(201, 5648, 201),
(202, 5649, 214),
(203, 5650, 203),
(204, 5651, 220),
(205, 5652, 205),
(206, 5653, 206),
(207, 5654, 207),
(208, 5655, 208),
(209, 5656, 215),
(210, 5658, 210),
(211, 5659, 211),
(212, 5662, 212),
(213, 5663, 213),
(214, 5664, 214),
(215, 5665, 215),
(216, 6111, 216),
(217, 6157, 217),
(218, 6202, 218),
(219, 5657, 219),
(220, 5660, 220),
(221, 5933, 221),
(222, 5943, 222),
(223, 5939, 223),
(224, 5954, 224),
(225, 5940, 225),
(226, 5211, 233),
(227, 5432, 227),
(228, 5076, 533),
(229, 5077, 533),
(230, 5684, 230),
(231, 5212, 231),
(232, 5213, 232),
(233, 5215, 233),
(234, 5216, 247),
(235, 5217, 235),
(236, 5218, 241),
(237, 5221, 241),
(238, 5222, 243),
(239, 5223, 239),
(240, 5224, 240),
(241, 5225, 241),
(242, 5226, 233),
(243, 5227, 243),
(244, 6179, 244),
(245, 5321, 245),
(246, 5210, 246),
(247, 5219, 247),
(248, 5220, 233),
(249, 5623, 249),
(250, 6087, 250),
(251, 5228, 251),
(252, 5431, 252),
(253, 5677, 254),
(254, 5678, 254),
(255, 6168, 255),
(256, 5685, 256),
(257, 5229, 257),
(258, 5441, 258),
(259, 5849, 259),
(260, 5698, 260),
(261, 5592, 261),
(262, 5593, 262),
(263, 5877, 263),
(264, 5878, 264),
(265, 5879, 263),
(266, 5881, 264),
(267, 5244, 267),
(268, 5440, 268),
(269, 5776, 269),
(270, 5777, 270),
(271, 5778, 271),
(272, 5779, 272),
(273, 5780, 273),
(274, 5781, 274),
(275, 5798, 275),
(276, 5799, 275),
(277, 5800, 275),
(278, 5047, 278),
(279, 5048, 279),
(280, 5036, 280),
(281, 5037, 281),
(282, 5133, 282),
(283, 5765, 283),
(284, 5775, 284),
(285, 6152, 285),
(286, 5701, 286),
(287, 6060, 287),
(288, 5811, 288),
(289, 5809, 289),
(290, 5815, 303),
(291, 5716, 291),
(292, 5717, 291),
(293, 5725, 293),
(294, 6006, 548),
(295, 5292, 295),
(296, 5985, 296),
(297, 5893, 567),
(298, 5282, 298),
(299, 5625, 299),
(300, 5626, 300),
(301, 5433, 301),
(302, 5810, 302),
(303, 5816, 303),
(304, 5106, 305),
(305, 5862, 305),
(306, 5888, 306),
(307, 5266, 307),
(308, 5305, 308),
(309, 5890, 309),
(310, 5945, 310),
(311, 5120, 311),
(312, 5901, 312),
(313, 5702, 313),
(314, 5892, 314),
(315, 5385, 315),
(316, 5400, 316),
(317, 5401, 317),
(318, 5402, 318),
(319, 5404, 319),
(320, 5405, 320),
(321, 5406, 321),
(322, 5409, 160),
(323, 6109, 323),
(324, 6200, 324),
(325, 5119, 325),
(326, 5757, 345),
(327, 4989, 332),
(328, 4990, 328),
(329, 4991, 329),
(330, 4992, 330),
(331, 4993, 331),
(332, 4994, 332),
(333, 4995, 333),
(334, 6130, 334),
(335, 6174, 335),
(336, 5085, 339),
(337, 5086, 337),
(338, 5147, 341),
(339, 5148, 339),
(340, 5758, 337),
(341, 5848, 337),
(342, 6127, 342),
(343, 6171, 343),
(344, 5081, 602),
(345, 5082, 345),
(346, 5083, 345),
(347, 5084, 602),
(348, 6126, 348),
(349, 6172, 349),
(350, 4996, 351),
(351, 4997, 351),
(352, 5101, 352),
(353, 5102, 353),
(354, 6153, 354),
(355, 6173, 355),
(356, 5087, 181),
(357, 5088, 181),
(358, 6177, 358),
(359, 5090, 359),
(360, 5869, 360),
(361, 5439, 361),
(362, 5314, 362),
(363, 5381, 363),
(364, 5279, 364),
(365, 6072, 365),
(366, 5443, 366),
(367, 5034, 367),
(368, 5035, 368),
(369, 5033, 369),
(370, 5121, 370),
(371, 5322, 371),
(372, 5768, 538),
(373, 6197, 373),
(374, 5294, 374),
(375, 5442, 375),
(376, 5298, 376),
(377, 5362, 377),
(378, 5923, 378),
(379, 5960, 379),
(380, 5978, 380),
(381, 6000, 381),
(382, 6017, 382),
(383, 5137, 383),
(384, 5136, 383),
(385, 5887, 385),
(386, 5666, 386),
(387, 5667, 387),
(388, 5015, 388),
(389, 5057, 391),
(390, 5058, 391),
(391, 5175, 391),
(392, 5719, 392),
(393, 5720, 393),
(394, 5721, 394),
(395, 5723, 395),
(396, 5872, 396),
(397, 6085, 397),
(398, 5502, 398),
(399, 5572, 399),
(400, 5594, 400),
(401, 5934, 401),
(402, 5490, 402),
(403, 5497, 403),
(404, 5498, 404),
(405, 6170, 405),
(406, 5741, 406),
(407, 5742, 407),
(408, 5353, 408),
(409, 5370, 409),
(410, 6013, 410),
(411, 6059, 411),
(412, 5491, 412),
(413, 5494, 413),
(414, 5495, 414),
(415, 5503, 415),
(416, 5573, 434),
(417, 5601, 417),
(418, 5602, 418),
(419, 5603, 419),
(420, 6091, 420),
(421, 5488, 421),
(422, 5489, 422),
(423, 5492, 423),
(424, 5493, 424),
(425, 5496, 425),
(426, 5499, 426),
(427, 5500, 427),
(428, 5581, 434),
(429, 6133, 429),
(430, 5574, 434),
(431, 5575, 431),
(432, 5577, 432),
(433, 5578, 433),
(434, 5579, 434),
(435, 5580, 435),
(436, 6112, 436),
(437, 5537, 437),
(438, 5538, 452),
(439, 5539, 452),
(440, 5540, 452),
(441, 5541, 452),
(442, 5542, 452),
(443, 5543, 452),
(444, 5544, 452),
(445, 5545, 452),
(446, 5546, 446),
(447, 5547, 452),
(448, 5548, 448),
(449, 5549, 452),
(450, 5550, 452),
(451, 5551, 451),
(452, 5552, 452),
(453, 5553, 452),
(454, 5554, 452),
(455, 6090, 455),
(456, 6135, 456),
(457, 6178, 457),
(458, 6063, 458),
(459, 6069, 459),
(460, 6062, 460),
(461, 6070, 461),
(462, 5367, 462),
(463, 5421, 463),
(464, 5428, 464),
(465, 5759, 465),
(466, 5760, 466),
(467, 5769, 467),
(468, 6019, 578),
(469, 5683, 469),
(470, 5699, 470),
(471, 5703, 471),
(472, 5696, 472),
(473, 5704, 473),
(474, 5049, 474),
(475, 5871, 475),
(476, 5444, 476),
(477, 5808, 477),
(478, 5378, 478),
(479, 5422, 479),
(480, 5429, 480),
(481, 5424, 481),
(482, 5379, 482),
(483, 5944, 483),
(484, 5947, 484),
(485, 5476, 485),
(486, 5477, 485),
(487, 5478, 485),
(488, 5485, 488),
(489, 5479, 489),
(490, 5481, 490),
(491, 5486, 491),
(492, 5861, 538),
(493, 5955, 493),
(494, 5956, 494),
(495, 5957, 495),
(496, 5958, 496),
(497, 5959, 497),
(498, 5891, 498),
(499, 5967, 499),
(500, 5968, 500),
(501, 5969, 501),
(502, 5264, 502),
(503, 5480, 503),
(504, 5976, 504),
(505, 5975, 505),
(506, 5622, 506),
(507, 5905, 507),
(508, 5906, 508),
(509, 5907, 509),
(510, 6001, 510),
(511, 5908, 511),
(512, 5917, 512),
(513, 5918, 513),
(514, 5919, 514),
(515, 5920, 515),
(516, 5921, 516),
(517, 5922, 517),
(518, 5615, 518),
(519, 5616, 519),
(520, 5966, 520),
(521, 5986, 521),
(522, 5987, 522),
(523, 5460, 523),
(524, 5995, 524),
(525, 5996, 525),
(526, 5997, 526),
(527, 5998, 527),
(528, 5999, 528),
(529, 5822, 529),
(530, 5823, 530),
(531, 5824, 531),
(532, 5820, 532),
(533, 5075, 533),
(534, 5831, 534),
(535, 5832, 535),
(536, 5833, 536),
(537, 5834, 537),
(538, 5835, 538),
(539, 5829, 539),
(540, 5157, 540),
(541, 5160, 541),
(542, 5161, 542),
(543, 5857, 543),
(544, 6020, 578),
(545, 5059, 545),
(546, 5178, 546),
(547, 5203, 547),
(548, 5204, 548),
(549, 6084, 549),
(550, 5065, 550),
(551, 5067, 581),
(552, 5068, 552),
(553, 5066, 553),
(554, 5183, 554),
(555, 5188, 555),
(556, 5069, 556),
(557, 5192, 557),
(558, 5722, 291),
(559, 5734, 559),
(560, 5737, 560),
(561, 5738, 561),
(562, 5740, 562),
(563, 5743, 563),
(564, 5454, 564),
(565, 5931, 565),
(566, 6083, 566),
(567, 5894, 567),
(568, 5471, 568),
(569, 5457, 569),
(570, 5458, 570),
(571, 6108, 571),
(572, 5459, 572),
(573, 5461, 573),
(574, 5462, 574),
(575, 5977, 575),
(576, 5168, 576),
(577, 5173, 577),
(578, 6021, 578),
(579, 6057, 578),
(580, 5187, 580),
(581, 5190, 581),
(582, 5875, 582),
(583, 5874, 583),
(584, 5194, 584),
(585, 5195, 585),
(586, 6024, 586),
(587, 6026, 587),
(588, 5202, 588),
(589, 6030, 589),
(590, 6032, 590),
(591, 6034, 591),
(592, 6036, 592),
(593, 5207, 593),
(594, 5469, 594),
(595, 5470, 595),
(596, 5846, 596),
(597, 5847, 597),
(598, 5858, 598),
(599, 5859, 599),
(600, 5860, 600),
(601, 5680, 601),
(602, 5536, 602),
(603, 5270, 603),
(604, 6081, 604),
(605, 6082, 605),
(606, 6104, 606),
(607, 6105, 607),
(608, 6106, 608),
(609, 6107, 609),
(610, 6123, 610),
(611, 6092, 611),
(612, 6124, 612),
(613, 6128, 613),
(614, 6129, 614),
(615, 6148, 615),
(616, 6149, 616),
(617, 6150, 617),
(618, 6192, 618),
(619, 6193, 619),
(620, 6194, 620),
(621, 6195, 621),
(622, 6196, 622),
(623, 6198, 623);

-- --------------------------------------------------------

--
-- Table structure for table `lecturer`
--

CREATE TABLE `lecturer` (
  `lecturer_id` int(255) NOT NULL,
  `staff_id` int(255) DEFAULT NULL,
  `surname` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lecturer`
--

INSERT INTO `lecturer` (`lecturer_id`, `staff_id`, `surname`) VALUES
(1, 1, 'ABOYADE'),
(2, 2, 'ADEBANJO'),
(3, 3, 'ADEBESAN'),
(4, 4, 'ADEDOYIN'),
(5, 5, 'ADEEKO'),
(6, 6, 'ADEFULU'),
(7, 7, 'ADEGBESAN'),
(8, 8, 'ADEKUNLE'),
(9, 9, 'ADELOLA'),
(10, 10, 'ADENIKE'),
(11, 11, 'ADEODOYIN'),
(12, 12, 'ADEOYE'),
(13, 13, 'ADERANTI'),
(14, 14, 'ADEYEMI'),
(15, 15, 'ADEYEMO'),
(16, 16, 'ADUEWEEEZE'),
(17, 17, 'AFOLABI'),
(18, 18, 'AGIDA'),
(19, 19, 'AINA '),
(20, 20, 'AKAH'),
(21, 21, 'AKINTODE'),
(22, 22, 'AKINTUNDE'),
(23, 23, 'ALABA'),
(24, 24, 'ALADENIKA'),
(25, 25, 'AMNIYA'),
(26, 26, 'AMONIYAN'),
(27, 27, 'AMUSA'),
(28, 28, 'AMUSA/OBA'),
(29, 29, 'ANIH'),
(30, 30, 'ANINKAN'),
(31, 31, 'ARIBI'),
(32, 32, 'ARIYIBI'),
(33, 33, 'AROWOSEGBE'),
(34, 34, 'AWODOYIN'),
(35, 35, 'AWOFODU'),
(36, 36, 'AWONIYI'),
(37, 37, 'AWONUGA'),
(38, 38, 'AYENI'),
(39, 39, 'BALOGUN'),
(40, 40, 'BANJO'),
(41, 41, 'BELLO'),
(42, 42, 'BIYA'),
(43, 43, 'BURAIMOH'),
(44, 44, 'BUSARIMOH'),
(45, 45, 'CLEMENT'),
(46, 46, 'CYRIL'),
(47, 47, 'DADA'),
(48, 48, 'DARAMOLA'),
(49, 49, 'EKO'),
(50, 50, 'ELEYOWO'),
(51, 51, 'ERINFOLAMI'),
(52, 52, 'FAWOLE'),
(53, 53, 'GIWA'),
(54, 54, 'HOD ACC'),
(55, 55, 'HOD ARCH'),
(56, 56, 'HOD B/F'),
(57, 57, 'HOD B/TECH'),
(58, 58, 'HOD BA'),
(59, 59, 'HOD BA'),
(60, 60, 'HOD BA'),
(61, 61, 'HOD BA'),
(62, 62, 'HOD BIO CHEM'),
(63, 63, 'HOD CHEM'),
(64, 64, 'HOD CHEM'),
(65, 65, 'HOD COM ENGR'),
(66, 66, 'HOD COM ENGR'),
(67, 67, 'HOD ELECT'),
(68, 68, 'HOD ELECT'),
(69, 69, 'HOD ENVR'),
(70, 70, 'HOD ENVR'),
(71, 71, 'HOD ENVR'),
(72, 72, 'HOD MKT'),
(73, 73, 'HOD MKT'),
(74, 74, 'HOD OTM'),
(75, 75, 'HOD PAD'),
(76, 76, 'IBIKUNLE '),
(77, 77, 'IBRAHIM'),
(78, 78, 'IDOWU [Mrs]'),
(79, 79, 'JAIYESIMI'),
(80, 80, 'JAMES'),
(81, 81, 'KAREEM'),
(82, 82, 'KAYODE'),
(83, 83, 'KAZEEM'),
(84, 84, 'KOLAWOLE'),
(85, 85, 'KUPONIYI'),
(86, 86, 'LAWAL'),
(87, 87, 'LOGUNLEKO'),
(88, 88, 'MAMORA'),
(89, 89, 'MATTEW '),
(90, 90, 'MUSARI'),
(91, 91, 'OBA'),
(92, 92, 'OGINI'),
(93, 93, 'OGUNBANJO'),
(94, 94, 'OGUNIRAN'),
(95, 95, 'OGUNMEFUN'),
(96, 96, 'OGUNSANYA'),
(97, 97, 'OGUNSOLA'),
(98, 98, 'OGUNTUGA'),
(99, 99, 'OGUNYEMI'),
(100, 100, 'OGUNYINKA'),
(101, 101, 'OJOYE'),
(102, 102, 'OKOKO'),
(103, 103, 'OKUNBANJO'),
(104, 104, 'OKUNUGA'),
(105, 105, 'OLA'),
(106, 106, 'OLAIYA'),
(107, 107, 'OLAJIDE'),
(108, 108, 'OLANIYAN'),
(109, 109, 'OLUGBADE'),
(110, 110, 'OLUGBEMI'),
(111, 111, 'OMISANDE'),
(112, 112, 'ONALAJA'),
(113, 113, 'ONANUBI'),
(114, 114, 'ONI'),
(115, 115, 'OPALEYE'),
(116, 116, 'OSIFESO'),
(117, 117, 'OSINAIKE'),
(118, 118, 'OSIYOYE'),
(119, 119, 'OWOLABI'),
(120, 120, 'OYEBOLA'),
(121, 121, 'OYEKUNLE'),
(122, 122, 'RAJI'),
(123, 123, 'SADIKU'),
(124, 124, 'SALAKO'),
(125, 125, 'SALAMI'),
(126, 126, 'SHOFOYEKE'),
(127, 127, 'SHOYOOLA[Mrs]'),
(128, 128, 'SOLARU'),
(129, 129, 'SOTAYO'),
(130, 130, 'SOTONWA'),
(131, 131, 'TAIWO'),
(132, 132, 'TOBINSPIFF'),
(133, 133, 'USMAN'),
(134, 134, 'WALE');

-- --------------------------------------------------------

--
-- Table structure for table `lecture_details`
--

CREATE TABLE `lecture_details` (
  `LDID` int(255) NOT NULL,
  `comibined_id` int(255) NOT NULL,
  `lecturer_id` int(255) NOT NULL,
  `duration` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lecture_details`
--

INSERT INTO `lecture_details` (`LDID`, `comibined_id`, `lecturer_id`, `duration`) VALUES
(1, 452, 5, 1),
(2, 263, 76, 2),
(3, 533, 36, 3),
(4, 548, 34, 3),
(5, 254, 16, 2),
(6, 125, 29, 2),
(7, 604, 81, 3),
(8, 479, 13, 3),
(9, 582, 10, 2),
(10, 511, 118, 3),
(11, 329, 78, 3),
(12, 327, 101, 2),
(13, 167, 96, 3),
(14, 108, 78, 3),
(15, 388, 45, 3),
(16, 1, 45, 3),
(17, 170, 78, 3),
(18, 368, 27, 3),
(19, 280, 100, 3),
(20, 281, 27, 3),
(21, 331, 84, 3),
(22, 328, 93, 3),
(23, 332, 45, 3),
(24, 351, 97, 3),
(25, 168, 84, 3),
(26, 105, 84, 3),
(27, 107, 93, 3),
(28, 106, 96, 3),
(29, 2, 78, 3),
(30, 163, 41, 2),
(31, 369, 41, 3),
(32, 367, 1, 3),
(33, 3, 101, 3),
(34, 474, 78, 3),
(35, 4, 84, 3),
(36, 278, 78, 3),
(37, 279, 84, 3),
(38, 552, 32, 2),
(39, 391, 9, 2),
(40, 545, 31, 2),
(41, 550, 32, 3),
(42, 581, 32, 2),
(43, 30, 130, 2),
(44, 359, 103, 2),
(45, 352, 91, 3),
(46, 305, 97, 2),
(47, 370, 8, 3),
(48, 0, 0, 0),
(49, 320, 30, 2),
(50, 32, 50, 2),
(51, 345, 51, 2),
(52, 602, 51, 2),
(53, 336, 27, 2),
(54, 339, 91, 3),
(55, 181, 90, 3),
(56, 149, 30, 3),
(57, 42, 50, 2),
(58, 26, 51, 2),
(59, 27, 51, 2),
(60, 112, 42, 3),
(61, 37, 36, 2),
(62, 325, 30, 3),
(63, 311, 93, 3),
(64, 195, 17, 3),
(65, 171, 101, 3),
(66, 36, 8, 3),
(67, 282, 27, 3),
(68, 198, 17, 2),
(69, 75, 51, 2),
(70, 383, 103, 2),
(71, 341, 125, 3),
(72, 146, 41, 2),
(73, 24, 79, 2),
(74, 38, 98, 2),
(75, 540, 98, 3),
(76, 0, 0, 0),
(77, 541, 79, 3),
(78, 461, 94, 3),
(79, 11, 122, 2),
(80, 460, 94, 3),
(81, 164, 83, 3),
(82, 287, 122, 2),
(83, 459, 83, 2),
(84, 458, 23, 2),
(85, 411, 86, 2),
(86, 382, 128, 2),
(87, 66, 35, 2),
(88, 141, 35, 2),
(89, 231, 19, 2),
(90, 233, 114, 2),
(91, 86, 123, 3),
(92, 99, 123, 3),
(93, 579, 52, 3),
(94, 589, 86, 3),
(95, 587, 52, 3),
(96, 592, 86, 2),
(97, 591, 86, 2),
(98, 590, 86, 2),
(99, 586, 52, 3),
(100, 578, 52, 3),
(101, 7, 130, 2),
(102, 410, 35, 2),
(103, 499, 12, 3),
(104, 8, 110, 3),
(105, 296, 124, 2),
(106, 521, 88, 3),
(107, 221, 11, 2),
(108, 565, 81, 3),
(109, 184, 24, 2),
(110, 186, 116, 2),
(111, 312, 12, 2),
(112, 222, 39, 3),
(113, 145, 50, 2),
(114, 223, 116, 2),
(115, 224, 11, 3),
(116, 225, 39, 3),
(117, 47, 130, 2),
(118, 337, 125, 2),
(119, 434, 126, 2),
(120, 241, 121, 2),
(121, 275, 95, 2),
(122, 291, 15, 3),
(123, 485, 4, 2),
(124, 16, 9, 3),
(125, 568, 4, 2),
(126, 567, 124, 3),
(127, 317, 81, 2),
(128, 303, 130, 2),
(129, 247, 123, 2),
(130, 243, 112, 2),
(131, 220, 121, 3),
(132, 215, 18, 3),
(133, 214, 7, 3),
(134, 138, 49, 2),
(135, 93, 112, 2),
(136, 33, 130, 2),
(137, 538, 93, 2),
(138, 264, 76, 2),
(139, 603, 87, 3),
(140, 600, 6, 2),
(141, 599, 93, 3),
(142, 150, 6, 3),
(143, 259, 109, 2),
(144, 396, 15, 2),
(145, 555, 57, 3),
(146, 547, 35, 3),
(147, 374, 120, 1),
(148, 557, 22, 2),
(149, 576, 22, 2),
(150, 92, 114, 2),
(151, 70, 121, 3),
(152, 76, 18, 3),
(153, 577, 94, 2),
(154, 580, 111, 2),
(155, 584, 53, 2),
(156, 585, 51, 2),
(157, 546, 55, 2),
(158, 553, 32, 2),
(159, 114, 114, 3),
(160, 79, 121, 3),
(161, 232, 42, 2);

-- --------------------------------------------------------

--
-- Table structure for table `lecture_schedule`
--

CREATE TABLE `lecture_schedule` (
  `LSID` int(255) NOT NULL,
  `combine_id` int(255) NOT NULL,
  `start_time` int(10) DEFAULT NULL,
  `end_time` int(10) DEFAULT NULL,
  `venue_id` int(255) NOT NULL,
  `day` int(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `level`
--

CREATE TABLE `level` (
  `level_id` int(255) NOT NULL,
  `level_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `level`
--

INSERT INTO `level` (`level_id`, `level_name`) VALUES
(1, 'ND I'),
(2, 'ND II'),
(3, 'HND I'),
(4, 'HND II');

-- --------------------------------------------------------

--
-- Table structure for table `schol_open_details`
--

CREATE TABLE `schol_open_details` (
  `open_id` int(2) NOT NULL,
  `time_open` time NOT NULL,
  `time_close` time NOT NULL,
  `days` varchar(20) NOT NULL,
  `total_days` int(5) NOT NULL,
  `total_hours` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `schol_open_details`
--

INSERT INTO `schol_open_details` (`open_id`, `time_open`, `time_close`, `days`, `total_days`, `total_hours`) VALUES
(1, '08:00:00', '18:00:00', '1,2,3,4,5', 5, 10);

-- --------------------------------------------------------

--
-- Table structure for table `semester`
--

CREATE TABLE `semester` (
  `semester_id` int(20) NOT NULL,
  `semester_name` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `semester`
--

INSERT INTO `semester` (`semester_id`, `semester_name`) VALUES
(1, 'FIRST'),
(2, 'SECOND');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `admin_id` int(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`admin_id`, `username`, `password`) VALUES
(1, 'admin', 'admin');

-- --------------------------------------------------------

--
-- Table structure for table `venue`
--

CREATE TABLE `venue` (
  `venue_id` int(255) NOT NULL,
  `venue_name` varchar(50) NOT NULL,
  `length` int(255) DEFAULT NULL,
  `width` int(244) DEFAULT NULL,
  `area` int(255) DEFAULT NULL,
  `capacity` int(255) NOT NULL,
  `exclusive` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `venue`
--

INSERT INTO `venue` (`venue_id`, `venue_name`, `length`, `width`, `area`, `capacity`, `exclusive`) VALUES
(1, 'A001', 0, 0, 0, 156, 0),
(2, 'A002', 0, 0, 0, 95, 0),
(3, 'A003', 0, 0, 0, 96, 0),
(4, 'A004', 0, 0, 0, 136, 0),
(5, 'ArcTech S 1', 0, 0, 0, 40, 1),
(6, 'ArcTech S 2', 0, 0, 0, 40, 1),
(7, 'AUD', 0, 0, 0, 1000, 0),
(8, 'B001', 0, 0, 0, 105, 0),
(9, 'B002', 0, 0, 0, 220, 0),
(10, 'BIO LAB', 0, 0, 0, 100, 1),
(11, 'CHM LAB', 0, 0, 0, 100, 1),
(12, 'Comp Main W/S', 0, 0, 0, 145, 1),
(13, 'Comp Sci Lab2', 0, 0, 0, 60, 1),
(14, 'DIG LAB', 0, 0, 0, 40, 1),
(15, 'E001', 0, 0, 0, 90, 0),
(16, 'E002', 0, 0, 0, 75, 0),
(17, 'EEE Lab', 0, 0, 0, 60, 1),
(18, 'F001 ', 0, 0, 0, 60, 1),
(19, 'F002', 0, 0, 0, 180, 0),
(20, 'F003', 0, 0, 0, 580, 0),
(21, 'F005', 0, 0, 0, 180, 0),
(22, 'F006', 0, 0, 0, 350, 0),
(23, 'FT Lab', 0, 0, 0, 60, 1),
(24, 'FT W/S', 0, 0, 0, 40, 1),
(25, 'GC 101', 0, 0, 0, 230, 0),
(26, 'GC 201', 0, 0, 0, 230, 0),
(27, 'GC 202', 0, 0, 0, 230, 0),
(28, 'GC 203', 0, 0, 0, 230, 0),
(29, 'GC 204', 0, 0, 0, 230, 0),
(30, 'GL 102', 0, 0, 0, 80, 1),
(31, 'GL 103', 0, 0, 0, 80, 1),
(32, 'H001', 0, 0, 0, 550, 0),
(33, 'H002', 0, 0, 0, 550, 0),
(34, 'Mech Eng W/S', 0, 0, 0, 60, 1),
(35, 'PHY LAB', 0, 0, 0, 100, 1),
(36, 'TD ROOM', 0, 0, 0, 60, 1);

-- --------------------------------------------------------

--
-- Stand-in structure for view `vw_course_class`
-- (See below for the actual view)
--
CREATE TABLE `vw_course_class` (
`course_id` int(255)
,`course_code` varchar(10)
,`course_title` varchar(50)
,`course_unit` int(10)
,`class_id` int(255)
,`semester_id` int(255)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `vw_department_full`
-- (See below for the actual view)
--
CREATE TABLE `vw_department_full` (
`class_id` int(255)
,`level_id` int(5)
,`level_name` varchar(50)
,`department_id` int(255)
,`dept_code` varchar(10)
,`department_name` varchar(50)
,`population` int(255)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `vw_full_course`
-- (See below for the actual view)
--
CREATE TABLE `vw_full_course` (
`course_id` int(255)
,`course_code` varchar(10)
,`course_title` varchar(50)
,`course_unit` int(10)
,`department_id` int(255)
,`dept_code` varchar(10)
,`level_id` int(255)
,`level_name` varchar(50)
,`population` int(255)
,`class_id` int(255)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `vw_lecture_details_full`
-- (See below for the actual view)
--
CREATE TABLE `vw_lecture_details_full` (
`LDID` int(255)
,`combined_id` int(255)
,`combined_list` mediumtext
,`combined_count` bigint(21)
,`combined_population` decimal(65,0)
,`duration` int(5)
,`lecturer_id` int(255)
,`surname` varchar(50)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `vw_lecture_population`
-- (See below for the actual view)
--
CREATE TABLE `vw_lecture_population` (
`lecture_id` int(255)
,`course_id` int(255)
,`combined_id` int(255)
,`combined_count` bigint(21)
,`combined_list` mediumtext
,`combined_population` decimal(65,0)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `vw_lecture_schedule_full`
-- (See below for the actual view)
--
CREATE TABLE `vw_lecture_schedule_full` (
`LDID` int(255)
,`combined_id` int(255)
,`combined_list` mediumtext
,`combined_count` bigint(21)
,`combined_population` decimal(65,0)
,`duration` int(5)
,`lecturer_id` int(255)
,`surname` varchar(50)
,`level_id` int(255)
,`level_name` varchar(50)
,`LSID` int(255)
,`combine_id` int(255)
,`start_time` int(10)
,`end_time` int(10)
,`venue_id` int(255)
,`venue_name` varchar(50)
,`day` int(5)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `vw_level_combined`
-- (See below for the actual view)
--
CREATE TABLE `vw_level_combined` (
`comibined_id` int(255)
,`duration` int(5)
,`combined_population` decimal(65,0)
,`combined_list` mediumtext
,`course_id` int(255)
,`course_code` varchar(10)
,`course_title` varchar(50)
,`course_unit` int(10)
,`department_id` int(255)
,`dept_code` varchar(10)
,`level_id` int(255)
,`level_name` varchar(50)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `vw_venue_report`
-- (See below for the actual view)
--
CREATE TABLE `vw_venue_report` (
`LDID` int(255)
,`combined_id` int(255)
,`combined_list` mediumtext
,`combined_count` bigint(21)
,`combined_population` decimal(65,0)
,`duration` int(5)
,`lecturer_id` int(255)
,`surname` varchar(50)
,`LSID` int(255)
,`combine_id` int(255)
,`start_time` int(10)
,`end_time` int(10)
,`venue_id` int(255)
,`day` int(5)
,`SUM(duration)` decimal(32,0)
,`COUNT(venue_id)` bigint(21)
);

-- --------------------------------------------------------

--
-- Structure for view `vw_course_class`
--
DROP TABLE IF EXISTS `vw_course_class`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_course_class`  AS  select `t1`.`course_id` AS `course_id`,`t1`.`course_code` AS `course_code`,`t1`.`course_title` AS `course_title`,`t1`.`course_unit` AS `course_unit`,`t2`.`class_id` AS `class_id`,`t1`.`semester_id` AS `semester_id` from (`course` `t1` left join `class` `t2` on(`t1`.`level_id` = `t2`.`level_id` and `t1`.`department_id` = `t2`.`department_id`)) ;

-- --------------------------------------------------------

--
-- Structure for view `vw_department_full`
--
DROP TABLE IF EXISTS `vw_department_full`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_department_full`  AS  select `t1`.`class_id` AS `class_id`,`t1`.`level_id` AS `level_id`,`t3`.`level_name` AS `level_name`,`t1`.`department_id` AS `department_id`,`t2`.`dept_code` AS `dept_code`,`t2`.`department_name` AS `department_name`,`t1`.`population` AS `population` from ((`class` `t1` left join `department` `t2` on(`t1`.`department_id` = `t2`.`department_id`)) left join `level` `t3` on(`t1`.`level_id` = `t3`.`level_id`)) ;

-- --------------------------------------------------------

--
-- Structure for view `vw_full_course`
--
DROP TABLE IF EXISTS `vw_full_course`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_full_course`  AS  select `t1`.`course_id` AS `course_id`,`t1`.`course_code` AS `course_code`,`t1`.`course_title` AS `course_title`,`t1`.`course_unit` AS `course_unit`,`t1`.`department_id` AS `department_id`,`t2`.`dept_code` AS `dept_code`,`t1`.`level_id` AS `level_id`,`t3`.`level_name` AS `level_name`,`t4`.`population` AS `population`,`t4`.`class_id` AS `class_id` from (((`course` `t1` left join `department` `t2` on(`t1`.`department_id` = `t2`.`department_id`)) left join `level` `t3` on(`t1`.`level_id` = `t3`.`level_id`)) left join `class` `t4` on(`t2`.`department_id` = `t4`.`department_id` and `t3`.`level_id` = `t4`.`level_id`)) ;

-- --------------------------------------------------------

--
-- Structure for view `vw_lecture_details_full`
--
DROP TABLE IF EXISTS `vw_lecture_details_full`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_lecture_details_full`  AS  select `t2`.`LDID` AS `LDID`,`t1`.`combined_id` AS `combined_id`,`t1`.`combined_list` AS `combined_list`,`t1`.`combined_count` AS `combined_count`,`t1`.`combined_population` AS `combined_population`,`t2`.`duration` AS `duration`,`t2`.`lecturer_id` AS `lecturer_id`,`t3`.`surname` AS `surname` from ((`vw_lecture_population` `t1` left join `lecture_details` `t2` on(`t1`.`combined_id` = `t2`.`comibined_id`)) left join `lecturer` `t3` on(`t3`.`lecturer_id` = `t2`.`lecturer_id`)) ;

-- --------------------------------------------------------

--
-- Structure for view `vw_lecture_population`
--
DROP TABLE IF EXISTS `vw_lecture_population`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_lecture_population`  AS  select `t1`.`lecture_id` AS `lecture_id`,`t1`.`course_id` AS `course_id`,`t1`.`combined_id` AS `combined_id`,count(`t1`.`lecture_id`) AS `combined_count`,group_concat(`t1`.`lecture_id` separator ',') AS `combined_list`,sum(`t2`.`population`) AS `combined_population` from (`lecture` `t1` left join `vw_full_course` `t2` on(`t1`.`course_id` = `t2`.`course_id`)) group by `t1`.`combined_id` ;

-- --------------------------------------------------------

--
-- Structure for view `vw_lecture_schedule_full`
--
DROP TABLE IF EXISTS `vw_lecture_schedule_full`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_lecture_schedule_full`  AS  select `t1`.`LDID` AS `LDID`,`t1`.`combined_id` AS `combined_id`,`t1`.`combined_list` AS `combined_list`,`t1`.`combined_count` AS `combined_count`,`t1`.`combined_population` AS `combined_population`,`t1`.`duration` AS `duration`,`t1`.`lecturer_id` AS `lecturer_id`,`t1`.`surname` AS `surname`,`t3`.`level_id` AS `level_id`,`t3`.`level_name` AS `level_name`,`t2`.`LSID` AS `LSID`,`t2`.`combine_id` AS `combine_id`,`t2`.`start_time` AS `start_time`,`t2`.`end_time` AS `end_time`,`t2`.`venue_id` AS `venue_id`,`t4`.`venue_name` AS `venue_name`,`t2`.`day` AS `day` from (((`vw_lecture_details_full` `t1` left join `lecture_schedule` `t2` on(`t1`.`combined_id` = `t2`.`combine_id`)) left join `vw_level_combined` `t3` on(`t1`.`combined_id` = `t3`.`comibined_id`)) left join `venue` `t4` on(`t4`.`venue_id` = `t2`.`venue_id`)) ;

-- --------------------------------------------------------

--
-- Structure for view `vw_level_combined`
--
DROP TABLE IF EXISTS `vw_level_combined`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_level_combined`  AS  select `t1`.`comibined_id` AS `comibined_id`,`t1`.`duration` AS `duration`,`t2`.`combined_population` AS `combined_population`,`t2`.`combined_list` AS `combined_list`,`t3`.`course_id` AS `course_id`,`t3`.`course_code` AS `course_code`,`t3`.`course_title` AS `course_title`,`t3`.`course_unit` AS `course_unit`,`t3`.`department_id` AS `department_id`,`t3`.`dept_code` AS `dept_code`,`t3`.`level_id` AS `level_id`,`t3`.`level_name` AS `level_name` from ((`lecture_details` `t1` left join `vw_lecture_population` `t2` on(`t2`.`combined_id` = `t1`.`comibined_id`)) left join `vw_full_course` `t3` on(`t2`.`course_id` = `t3`.`course_id`)) ;

-- --------------------------------------------------------

--
-- Structure for view `vw_venue_report`
--
DROP TABLE IF EXISTS `vw_venue_report`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vw_venue_report`  AS  select `vw_lecture_schedule_full`.`LDID` AS `LDID`,`vw_lecture_schedule_full`.`combined_id` AS `combined_id`,`vw_lecture_schedule_full`.`combined_list` AS `combined_list`,`vw_lecture_schedule_full`.`combined_count` AS `combined_count`,`vw_lecture_schedule_full`.`combined_population` AS `combined_population`,`vw_lecture_schedule_full`.`duration` AS `duration`,`vw_lecture_schedule_full`.`lecturer_id` AS `lecturer_id`,`vw_lecture_schedule_full`.`surname` AS `surname`,`vw_lecture_schedule_full`.`LSID` AS `LSID`,`vw_lecture_schedule_full`.`combine_id` AS `combine_id`,`vw_lecture_schedule_full`.`start_time` AS `start_time`,`vw_lecture_schedule_full`.`end_time` AS `end_time`,`vw_lecture_schedule_full`.`venue_id` AS `venue_id`,`vw_lecture_schedule_full`.`day` AS `day`,sum(`vw_lecture_schedule_full`.`duration`) AS `SUM(duration)`,count(`vw_lecture_schedule_full`.`venue_id`) AS `COUNT(venue_id)` from `vw_lecture_schedule_full` group by `vw_lecture_schedule_full`.`venue_id` ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `class`
--
ALTER TABLE `class`
  ADD PRIMARY KEY (`class_id`);

--
-- Indexes for table `course`
--
ALTER TABLE `course`
  ADD PRIMARY KEY (`course_id`);

--
-- Indexes for table `days`
--
ALTER TABLE `days`
  ADD PRIMARY KEY (`day_id`);

--
-- Indexes for table `department`
--
ALTER TABLE `department`
  ADD PRIMARY KEY (`department_id`);

--
-- Indexes for table `lecture`
--
ALTER TABLE `lecture`
  ADD PRIMARY KEY (`lecture_id`);

--
-- Indexes for table `lecturer`
--
ALTER TABLE `lecturer`
  ADD PRIMARY KEY (`lecturer_id`);

--
-- Indexes for table `lecture_details`
--
ALTER TABLE `lecture_details`
  ADD PRIMARY KEY (`LDID`);

--
-- Indexes for table `lecture_schedule`
--
ALTER TABLE `lecture_schedule`
  ADD PRIMARY KEY (`LSID`),
  ADD UNIQUE KEY `combine_id` (`combine_id`);

--
-- Indexes for table `level`
--
ALTER TABLE `level`
  ADD PRIMARY KEY (`level_id`);

--
-- Indexes for table `schol_open_details`
--
ALTER TABLE `schol_open_details`
  ADD PRIMARY KEY (`open_id`);

--
-- Indexes for table `semester`
--
ALTER TABLE `semester`
  ADD PRIMARY KEY (`semester_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`admin_id`);

--
-- Indexes for table `venue`
--
ALTER TABLE `venue`
  ADD PRIMARY KEY (`venue_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `class`
--
ALTER TABLE `class`
  MODIFY `class_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `course`
--
ALTER TABLE `course`
  MODIFY `course_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6203;

--
-- AUTO_INCREMENT for table `days`
--
ALTER TABLE `days`
  MODIFY `day_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `department_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3333335;

--
-- AUTO_INCREMENT for table `lecture`
--
ALTER TABLE `lecture`
  MODIFY `lecture_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=624;

--
-- AUTO_INCREMENT for table `lecturer`
--
ALTER TABLE `lecturer`
  MODIFY `lecturer_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135;

--
-- AUTO_INCREMENT for table `lecture_details`
--
ALTER TABLE `lecture_details`
  MODIFY `LDID` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=162;

--
-- AUTO_INCREMENT for table `lecture_schedule`
--
ALTER TABLE `lecture_schedule`
  MODIFY `LSID` int(255) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `level`
--
ALTER TABLE `level`
  MODIFY `level_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `schol_open_details`
--
ALTER TABLE `schol_open_details`
  MODIFY `open_id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `semester`
--
ALTER TABLE `semester`
  MODIFY `semester_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `admin_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `venue`
--
ALTER TABLE `venue`
  MODIFY `venue_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;