File "scheduling_classroom_reservation.sql"
Full Path: /home/scheduling/public_html/database/scheduling_classroom_reservation.sql
File size: 68.05 KB
MIME-type: text/plain
Charset: utf-8
-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 04, 2025 at 07:19 AM
-- Server version: 8.0.35-cll-lve
-- PHP Version: 8.3.25
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `scheduling_classroom_reservation`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE `admin` (
`id` int NOT NULL,
`name` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`username` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`password` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`id`, `name`, `username`, `password`) VALUES
(1, 'admin', 'admin', 'admin');
-- --------------------------------------------------------
--
-- Table structure for table `approval`
--
CREATE TABLE `approval` (
`id` int NOT NULL,
`curriculum_id` int DEFAULT NULL,
`name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`degree` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`position` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`type` enum('Prepared by','Checked by','Verified by') COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `approval`
--
INSERT INTO `approval` (`id`, `curriculum_id`, `name`, `degree`, `position`, `type`) VALUES
(1, 1, 'LIEZL S. ABUZO', 'PhD, DITS', 'Collage Secretary', 'Prepared by'),
(2, 5, 'JESUS M. LINDO', 'DIT', 'Program Chair', 'Checked by'),
(3, 7, 'JANE B. GELINDON', 'MIT', 'Program Chair', 'Checked by'),
(4, 2, 'CHERRY R. GUMIRAN', 'D. ENG', 'Program Chair', 'Checked by'),
(5, 5, 'PROF. ARNEL C. FAJARDO', 'PhD', 'Collage Dean', 'Verified by'),
(6, 2, 'LIEZL S. ABUZO', 'PhD, DIT', 'Collage Secretary', 'Prepared by'),
(7, 3, 'LIEZL S. ABUZO', 'PhD, DIT', 'Collage Secretary', 'Prepared by'),
(8, 4, 'LIEZL S. ABUZO', 'PhD, DIT', 'Collage Secretary', 'Prepared by'),
(9, 5, 'LIEZL S. ABUZO', 'PhD, DIT', 'Collage Secretary', 'Prepared by'),
(10, 6, 'LIEZL S. ABUZO', 'PhD, DIT', 'Collage Secretary', 'Prepared by'),
(11, 7, 'LIEZL S. ABUZO', 'PhD, DIT', 'Collage Secretary', 'Prepared by'),
(12, 8, 'LIEZL S. ABUZO', 'PhD, DIT', 'Collage Secretary', 'Prepared by'),
(13, 8, 'JANE B. GELINDON', 'MIT', 'Program Chair', 'Checked by'),
(14, 1, 'CHERRY R. GUMIRAN', 'D. ENG', 'Program Chair', 'Checked by'),
(15, 3, 'CHERRY R. GUMIRAN', 'D. ENG', 'Program Chair', 'Checked by'),
(16, 4, 'CHERRY R. GUMIRAN', 'D. ENG', 'Program Chair', 'Checked by'),
(17, 6, 'JESUS M. LINDO', 'DIT', 'Program Chair', 'Checked by'),
(18, 1, 'PROF. ARNEL C. FAJARDO', 'PhD', 'Collage Dean', 'Verified by'),
(19, 2, 'PROF. ARNEL C. FAJARDO', 'PhD, DIT', 'Collage Dean', 'Verified by'),
(20, 3, 'PROF. ARNEL C. FAJARDO', 'PhD, DIT', 'Collage Dean', 'Verified by'),
(21, 4, 'PROF. ARNEL C. FAJARDO', 'PhD, DIT', 'Collage Dean', 'Verified by'),
(22, 6, 'PROF. ARNEL C. FAJARDO', 'PhD, DIT', 'Collage Dean', 'Verified by'),
(23, 7, 'PROF. ARNEL C. FAJARDO', 'PhD, DIT', 'Collage Dean', 'Verified by'),
(24, 8, 'PROF. ARNEL C. FAJARDO', 'PhD, DIT', 'Collage Dean', 'Verified by');
-- --------------------------------------------------------
--
-- Table structure for table `curriculum`
--
CREATE TABLE `curriculum` (
`id` int NOT NULL,
`name` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`track` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`code` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `curriculum`
--
INSERT INTO `curriculum` (`id`, `name`, `track`, `code`, `status`) VALUES
(1, 'BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY', 'Network and Security', 'BSIT', 'Active'),
(2, 'BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY', 'Web and Mobile Application Development', 'BSIT', 'Active'),
(3, 'BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY', 'Business Analytics', 'BSIT', 'Active'),
(4, 'BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY', 'Business Process Outsourcing', 'BSIT', 'Active'),
(5, 'BACHELOR OF SCIENCE IN COMPUTER SCIENCE', 'Data Mining', 'BSCS', 'Active'),
(6, 'BACHELOR OF SCIENCE IN COMPUTER SCIENCE', 'Business Analytics', 'BSCS', 'Active'),
(7, 'BACHELOR OF SCIENCE IN ENTERTAINMENT MULTIMEDIA COMPUTING', 'Game Development', 'BSEMC', 'Active'),
(8, 'BACHELOR OF SCIENCE IN ENTERTAINMENT MULTIMEDIA COMPUTING', 'Digital Animiation', 'BSEMC', 'Active'),
(10, 'Doctor in Information Technology', 'nonee', 'DIT', 'Active'),
(11, 'Master in Information Technology', 'nonee', 'MIT', 'Active'),
(12, 'Diploma in Data Science and Analytics', 'nonee', 'DDSA', 'Active');
-- --------------------------------------------------------
--
-- Table structure for table `faculty`
--
CREATE TABLE `faculty` (
`id` int NOT NULL,
`id_no` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`faculty_name` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `faculty`
--
INSERT INTO `faculty` (`id`, `id_no`, `faculty_name`, `password`, `status`) VALUES
(1, 'IT1', 'CHERRY R. GUMIRAN, D.Eng', '1', 'Active'),
(2, 'IT2', 'LIEZL S. ABUZO, DIT', '2', 'Active'),
(3, 'IT3', 'BETCHIE E. AGUINALDO, DIT', '3', 'Active'),
(4, 'IT4', 'REMIE-BIE D. ANDRES, DIT', '4', 'Active'),
(5, 'IT5', 'ANGELO C. GALAPON, DIT', '5', 'Active'),
(6, 'IT6', 'DIONICIO D. GANTE, MIT', '6', 'Active'),
(7, 'IT7', 'JOEL M. GUMIRAN, DIT', '7', 'Active'),
(8, 'IT8', 'JAYSON S. LIQUIGAN, MIT', '8', 'Active'),
(9, 'IT9', 'AIMEE D. MOLATO, DIT', '9', 'Active'),
(10, 'IT10', 'MARVEE CHESKA D. NATIVIDAD, DIT', '10', 'Active'),
(11, 'IT11', 'MAY PRINCEFORD REYNO, MIT', '11', 'Active'),
(12, 'IT12', 'HARLEY N. CADIZ', '12', 'Active'),
(13, 'IT13', 'APRIL JOY LUNG AYAN', '13', 'Active'),
(14, 'CS1', 'JESUS M. LINDO, DIT', '01', 'Active'),
(15, 'CS2', 'PROF. MARY JANE S. BITANGA, DIT', '02', 'Active'),
(16, 'CS3', 'REYNALDO R. CORPUZ, DIT', '03', 'Active'),
(17, 'CS4', 'CHRISTOPHER R. CHE, MIT', '04', 'Active'),
(18, 'CS5', 'SHERYL A. CHE, MIT', '05', 'Active'),
(19, 'CS6', 'PEARLY ANN A. ESCALAMBRE', '06', 'Active'),
(20, 'CS7', 'PROF. ARNEL C. FAJARDO, Ph.D', '07', 'Active'),
(21, 'CS8', 'ALVIN V. MODALES, MIT', '08', 'Active'),
(22, 'CS9', 'EDDIE I. PERU, Ph.D', '09', 'Active'),
(23, 'CS10', 'MARK ANTHONY REYES', '010', 'Active'),
(24, 'CS11', 'ROSE MARY A. VELASCO, DIT', '1234', 'Active'),
(25, 'EMC1', 'JANE B. GELINDON, MIT', '001', 'Active'),
(26, 'EMC2', 'ERICK R. ABUZO, DIT', '12345', 'Active'),
(27, 'EMC3', 'BRYAN JAY J. ALI, MIT', '003', 'Active'),
(28, 'EMC4', 'KENNETH ANCHETA', '004', 'Active'),
(29, 'EMC5', 'CHRISTOPHER H. GUIANG, MIT', '005', 'Active'),
(30, 'EMC6', 'RYAN M. MARAMAG, MIT', '006', 'Active'),
(31, 'EMC7', 'ARHYLL JOHN A. MANZOLIM, BSMA', '007', 'Active'),
(32, 'EMC8', 'PAULO V. OPIÑA, JR., DIT', '008', 'Active'),
(33, 'EMC9', 'JASMINE DANIELLA', '009', 'Active');
-- --------------------------------------------------------
--
-- Table structure for table `room`
--
CREATE TABLE `room` (
`id` int NOT NULL,
`room_code` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`room_name` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`room_information` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`type` enum('Laboratory','Lecture','Other') COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `room`
--
INSERT INTO `room` (`id`, `room_code`, `room_name`, `room_information`, `type`, `status`) VALUES
(1, NULL, 'RMB 102', '', 'Laboratory', 'Active'),
(2, NULL, 'RMB 103', '', 'Laboratory', 'Active'),
(3, NULL, 'RMB 104', '', 'Laboratory', 'Active'),
(4, NULL, 'IT RM 101', '', 'Lecture', 'Active'),
(5, NULL, 'IT RM 102', '', 'Lecture', 'Active'),
(6, NULL, 'IT RM 103', '', 'Lecture', 'Active'),
(7, NULL, 'IT RM 104', '', 'Lecture', 'Active'),
(8, NULL, 'IT LAB 201', '', 'Laboratory', 'Active'),
(9, NULL, 'IT LAB 202', '', 'Laboratory', 'Active'),
(10, NULL, 'IT LAB 203', '', 'Laboratory', 'Active'),
(11, NULL, 'IT LAB 204', '', 'Lecture', 'Active'),
(12, NULL, 'IT LAB 301', '', 'Laboratory', 'Active'),
(13, NULL, 'IT RM 302', '', 'Lecture', 'Active'),
(14, NULL, 'IT RM 303', '', 'Lecture', 'Active'),
(15, NULL, 'IT RM 304', '', 'Laboratory', 'Active');
-- --------------------------------------------------------
--
-- Table structure for table `schedule`
--
CREATE TABLE `schedule` (
`id` int NOT NULL,
`days` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`faculty_id` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`curriculum_id` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`section_id` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`year_level` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`semester` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`subject_id` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`start_time` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`end_time` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`room_id` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`date` date DEFAULT (curdate())
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `schedule`
--
INSERT INTO `schedule` (`id`, `days`, `faculty_id`, `curriculum_id`, `section_id`, `year_level`, `semester`, `subject_id`, `start_time`, `end_time`, `room_id`, `date`) VALUES
(1, 'Monday', '14', '5', '19', '1st Year', '1st', '447', '08:30', '09:30', '4', '2025-10-24'),
(2, 'Thursday', '17', '2', '6', '2nd Year', '1st', '79', '10:00', '12:00', '8', '2025-10-24'),
(3, 'Monday', '24', '4', '18', '4th Year', '1st', '217', '08:00', '09:30', '7', '2025-10-24'),
(5, 'Wednesday', '11', '8', '35', '2nd Year', '2nd', '308', '07:08', '14:57', '2', '2025-10-24'),
(7, 'Monday', '26', '2', '6', '2nd Year', '2nd', '91', '08:00', '10:00', '11', '2025-10-27'),
(8, 'Tuesday', '26', '2', '6', '2nd Year', '2nd', '91', '07:00', '10:00', '3', '2025-10-27'),
(9, 'Monday', '4', '1', '1', '1st Year', '2nd', '10', '08:00', '10:00', '13', '2025-10-28'),
(10, 'Tuesday', '9', '1', '1', '1st Year', '2nd', '13', '10:00', '12:00', '7', '2025-10-28'),
(12, 'Wednesday', '24', '4', '18', '4th Year', '1st', '217', '08:00', '09:30', '7', '2025-11-22'),
(16, 'Tuesday', '5', '4', '18', '4th Year', '1st', '220', '08:00', '10:00', '4', '2025-12-01'),
(17, 'Wednesday', '5', '4', '18', '4th Year', '1st', '220', '10:00', '13:00', '4', '2025-12-01');
-- --------------------------------------------------------
--
-- Table structure for table `school_year`
--
CREATE TABLE `school_year` (
`id` int NOT NULL,
`sy` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `school_year`
--
INSERT INTO `school_year` (`id`, `sy`, `status`) VALUES
(1, '2025-2026', 'Active');
-- --------------------------------------------------------
--
-- Table structure for table `section`
--
CREATE TABLE `section` (
`id` int NOT NULL,
`curriculum_id` int DEFAULT NULL,
`section_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`year_level` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `section`
--
INSERT INTO `section` (`id`, `curriculum_id`, `section_name`, `year_level`, `status`) VALUES
(1, 1, 'BSIT 1A NS', '1st Year', 'Active'),
(2, 1, 'BSIT 2A NS', '2nd Year', 'Active'),
(3, 1, 'BSIT 3A NS', '3rd Year', 'Active'),
(4, 1, 'BSIT 4A NS', '4th Year', 'Active'),
(5, 2, 'BSIT 1A WMAD', '1st Year', 'Active'),
(6, 2, 'BSIT 2A WMAD', '2nd Year', 'Active'),
(7, 2, 'BSIT 3A WMAD', '3rd Year', 'Active'),
(8, 2, 'BSIT 4A WMAD', '4th Year', 'Active'),
(9, 3, 'BSIT 1A BA', '1st Year', 'Active'),
(10, 3, 'BSIT 2A BA', '2nd Year', 'Active'),
(11, 3, 'BSIT 3A BA', '3rd Year', 'Active'),
(12, 3, 'BSIT 4A BA', '4th Year', 'Active'),
(13, 4, 'BSIT 1A BPO', '1st Year', 'Active'),
(14, 4, 'BSIT 1B BPO', '1st Year', 'Active'),
(15, 4, 'BSIT 2A BPO', '2nd Year', 'Active'),
(16, 4, 'BSIT 3A BPO', '3rd Year', 'Active'),
(17, 4, 'BSIT 3B BPO', '3rd Year', 'Active'),
(18, 4, 'BSIT 4A BPO', '4th Year', 'Active'),
(19, 5, 'BSCS 1A DM', '1st Year', 'Active'),
(20, 5, 'BSCS 1B DM', '1st Year', 'Active'),
(21, 5, 'BSCS 2A DM', '2nd Year', 'Active'),
(22, 5, 'BSCS 3A DM', '3rd Year', 'Active'),
(23, 5, 'BSCS 4A DM', '4th Year', 'Active'),
(24, 6, 'BSCS 1A BA', '1st Year', 'Active'),
(25, 6, 'BSCS 2A BA', '2nd Year', 'Active'),
(26, 6, 'BSCS 3A BA', '3rd Year', 'Active'),
(27, 6, 'BSCS 4A BA', '4th Year', 'Active'),
(28, 7, 'BSEMC 1A GD', '1st Year', 'Active'),
(29, 7, 'BSEMC 2A GD', '2nd Year', 'Active'),
(30, 7, 'BSEMC 3A GD', '3rd Year', 'Active'),
(31, 7, 'BSEMC 4A GD', '4th Year', 'Active'),
(32, 8, 'BSEMC 1A DA', '1st Year', 'Active'),
(33, 8, 'BSEMC 1B DA', '1st Year', 'Active'),
(34, 8, 'BSEMC 2A DA', '2nd Year', 'Active'),
(35, 8, 'BSEMC 2B DA', '2nd Year', 'Active'),
(36, 8, 'BSEMC 3A DA', '4th Year', 'Active'),
(37, 8, 'BSEMC 4A DA', '4th Year', 'Inactive');
-- --------------------------------------------------------
--
-- Table structure for table `student`
--
CREATE TABLE `student` (
`id` int NOT NULL,
`fullname` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`age` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`gender` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`student_id` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`username` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`password` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`year` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`date` date DEFAULT (curdate())
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `subject`
--
CREATE TABLE `subject` (
`id` int NOT NULL,
`curriculum_id` int DEFAULT NULL,
`track_id` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`subject_code` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`subject_description` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
`semester` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`lab` int DEFAULT NULL,
`lec` int DEFAULT NULL,
`year` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`pre_requisite` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `subject`
--
INSERT INTO `subject` (`id`, `curriculum_id`, `track_id`, `subject_code`, `subject_description`, `semester`, `lab`, `lec`, `year`, `pre_requisite`) VALUES
(1, 1, NULL, 'GEC 4', 'Purposive Communication', '1st', 0, 3, '1st Year', 'None'),
(2, 1, NULL, 'GEC 5', 'Art Appreciation', '1st', 0, 3, '1st Year', 'None'),
(3, 1, NULL, 'IT INST 1', 'Climate Change And Disaster Risk Management', '1st', 0, 2, '1st Year', 'None'),
(4, 1, NULL, 'IT GE ELEC 1', 'Health And Wellness Science', '1st', 0, 3, '1st Year', 'None'),
(5, 1, NULL, 'IT GE ELEC 2', 'Foreign Language 1', '1st', 0, 3, '1st Year', 'None'),
(6, 1, NULL, 'IT 111', 'Introduction To Computing', '1st', 1, 2, '1st Year', 'None'),
(7, 1, NULL, 'IT 112', 'Computer Programming 1', '1st', 1, 2, '1st Year', 'None'),
(8, 1, NULL, 'PE 1', 'Physical Activity Towards Health And Fitness 1', '1st', 0, 2, '1st Year', 'None'),
(9, 1, NULL, 'NSTP 1', 'Cwts/Lts/Ms 1', '1st', 0, 3, '1st Year', 'None'),
(10, 1, NULL, 'GEC 1', 'Understanding The Self', '2nd', 0, 3, '1st Year', 'None'),
(11, 1, NULL, 'GEC 2', 'Readings In The Philippines History', '1st', 0, 3, '1st Year', 'None'),
(12, 1, NULL, 'GEC 3', 'Mathematics In The Modern World', '2nd', 0, 3, '1st Year', 'None'),
(13, 1, NULL, 'GEC 7', 'Ethics', '2nd', 0, 3, '1st Year', 'None'),
(14, 1, NULL, 'IT 121', 'Computer Programming 2', '2nd', 1, 2, '1st Year', 'IT 112'),
(15, 1, NULL, 'IT 122', 'Human Interaction 1', '2nd', 1, 2, '1st Year', 'IT 112'),
(16, 1, NULL, 'IT 123', 'Discrete Mathematics', '1st', 0, 3, '1st Year', 'None'),
(17, 1, NULL, 'PE 2', 'Physical Activity Towards Health And Fitness 2', '2nd', 0, 2, '1st Year', 'PE 1'),
(18, 1, NULL, 'NSTP 2', 'Cwts/Lts/Ms 2', '2nd', 0, 3, '1st Year', 'NSTP 1'),
(19, 1, NULL, 'GEC 6', 'Science, Technology And Society', '1st', 0, 3, '2nd Year', 'None'),
(20, 1, NULL, 'GEC 8', 'The Comtemporary World', '1st', 0, 3, '2nd Year', 'None'),
(21, 1, NULL, 'IT INST 2', 'Creative And Critical Thinking', '1st', 1, 1, '2nd Year', 'None'),
(22, 1, NULL, 'IT GE ELEC 3', 'Foreign Language 2', '1st', 0, 3, '2nd Year', 'None'),
(23, 1, NULL, 'IT 211', 'Data Structures And Algorithms', '1st', 1, 2, '2nd Year', 'IT 121'),
(24, 1, NULL, 'IT ELEC 1', 'Platform Technologies', '1st', 1, 2, '2nd Year', 'IT 121'),
(25, 1, NULL, 'IT ELEC 2', 'Object-Oriented Programming', '1st', 1, 2, '2nd Year', 'IT 121'),
(26, 1, NULL, 'IT BPO 1', 'Business Communication', '1st', 0, 3, '2nd Year', 'None'),
(27, 1, NULL, 'PE 3', 'Physical Activity Towards Health And Fitness III', '1st', 0, 2, '2nd Year', 'PE 1, PE 2'),
(28, 1, NULL, 'IT GE ELEC 4', 'The Entreprenurial Mind', '2nd', 0, 3, '2nd Year', 'None'),
(29, 1, NULL, 'GEC 9', 'The Life And Works Of Rizal', '2nd', 0, 3, '2nd Year', 'None'),
(30, 1, NULL, 'IT 221', 'Information Management', '2nd', 1, 2, '2nd Year', 'IT 121'),
(31, 1, NULL, 'IT 222', 'Networking 1', '2nd', 1, 2, '2nd Year', 'IT ELEC 1'),
(32, 1, NULL, 'IT 223', 'Quantitative Methods (Including Modeling And Simulations)', '2nd', 0, 3, '2nd Year', 'IT 221, IT 123'),
(33, 1, NULL, 'IT 224', 'Integrative Programming Technologies', '2nd', 1, 2, '2nd Year', 'IT ELEC 1, IT ELEC 2'),
(34, 1, NULL, 'IT 225', 'Accounting For Information Technology', '2nd', 0, 3, '2nd Year', 'None'),
(35, 1, NULL, 'IT NS 1', 'Cybersecurity Principles and Emerging Technologies', '2nd', 1, 2, '2nd Year', 'IT ELEC 1, CO-REQ IT 222'),
(36, 1, NULL, 'PE 4', 'Physical Activity Towards Health And Fitness VI (Dance, Team Sports,Outdorr, And Adventure Activities)', '2nd', 0, 2, '2nd Year', 'PE 1, PE 2, PE 3'),
(37, 1, NULL, 'IT 226', 'Applications Development And Emerging Technologies', 'Summer/MidYear', 1, 2, '2nd Year', 'IT 221'),
(38, 1, NULL, 'IT ELEC 3', 'Web Systems And Technologies', 'Summer/MidYear', 1, 2, '2nd Year', 'None'),
(39, 1, NULL, 'IT Inst 3', 'Data Science And Analytics', '1st', 1, 1, '3rd Year', 'None'),
(40, 1, NULL, 'IT 311', 'Advanced Database Systems', '1st', 1, 2, '3rd Year', 'IT 221'),
(41, 1, NULL, 'IT 312', 'Networking 2', '1st', 1, 2, '3rd Year', 'IT 222'),
(42, 1, NULL, 'IT 313', 'System Integration And Architecture', '1st', 1, 2, '3rd Year', 'IT 224'),
(43, 1, NULL, 'IT 314', 'Information Assurance And Technology 1', '1st', 1, 2, '3rd Year', 'IT 224'),
(44, 1, NULL, 'IT NS 2', 'Virtual Systems And Services', '1st', 1, 2, '3rd Year', 'IT 222'),
(45, 1, NULL, 'IT GE ELEC 5', 'Multicultural Education', '2nd', 0, 3, '3rd Year', 'None'),
(46, 1, NULL, 'IT 321', 'Information Assurance And Security 2', '2nd', 1, 2, '3rd Year', 'IT 314'),
(47, 1, NULL, 'IT 322', 'Social And Professional Issues', '2nd', 0, 3, '3rd Year', 'GEC 7'),
(48, 1, NULL, 'IT 323', 'Capstone Project And Research 1', '2nd', 1, 2, '3rd Year', 'IT 226, IT 314'),
(49, 1, NULL, 'IT NS 3', 'Applied Networks', '2nd', 1, 2, '3rd Year', 'IT 312, IT NS 2'),
(50, 1, NULL, 'IT NS 4', 'Internet Of Things', '2nd', 1, 2, '3rd Year', 'IT 312, IT NS 2'),
(51, 1, NULL, 'IT GE ELEC 6', 'Leadership And Management In The Profession', '1st', 0, 3, '4th Year', 'None'),
(52, 1, NULL, 'IT 411', 'System Administration And Maintenance', '1st', 1, 2, '4th Year', 'IT 312'),
(53, 1, NULL, 'IT ELEC 4', 'Human Computer Interaction 2', '1st', 1, 2, '4th Year', 'IT 122'),
(54, 1, NULL, 'IT 412', 'Capstone Project And Research 2', '1st', 1, 2, '4th Year', 'IT 323'),
(55, 1, NULL, 'IT NS 5', 'Introduction To Network Career Certification', '1st', 1, 2, '4th Year', '4th Year Standing'),
(56, 1, NULL, 'IT 421', 'Internship/Ojt/Practicum(486 Hours)', '2nd', 0, 9, '4th Year', '4th Year Standing'),
(57, 2, NULL, 'GEC 4', 'Purposive Communication', '1st', 0, 3, '1st Year', 'None'),
(58, 2, NULL, 'GEC 5', 'Art Appreciation', '1st', 0, 3, '1st Year', 'None'),
(59, 2, NULL, 'IT INST 1', 'Climate Change And Disaster Risk Management', '1st', 0, 2, '1st Year', 'None'),
(60, 2, NULL, 'IT GE ELEC 1', 'Health And Wellness Science', '1st', 0, 3, '1st Year', 'None'),
(61, 2, NULL, 'IT GE ELEC 2', 'Foreign Language 1', '1st', 0, 3, '1st Year', 'None'),
(62, 2, NULL, 'IT 111', 'Introduction To Computing', '1st', 1, 2, '1st Year', 'None'),
(63, 2, NULL, 'IT 112', 'Computer Programming 1', '1st', 1, 2, '1st Year', 'None'),
(64, 2, NULL, 'PE 1', 'Physical Activity Towards Health And Fitness 1', '1st', 0, 2, '1st Year', 'None'),
(65, 2, NULL, 'NSTP 1', 'Cwts/Lts/Ms 1', '1st', 0, 3, '1st Year', 'None'),
(66, 2, NULL, 'GEC 1', 'Understanding The Self', '2nd', 0, 3, '1st Year', 'None'),
(67, 2, NULL, 'GEC 2', 'Readings In The Philippines History', '2nd', 0, 3, '1st Year', 'None'),
(68, 2, NULL, 'GEC 3', 'Mathematics In The Modern World', '2nd', 0, 3, '1st Year', 'None'),
(69, 2, NULL, 'GEC 7', 'Ethics', '2nd', 0, 3, '1st Year', 'None'),
(70, 2, NULL, 'IT 121', 'Computer Programming 2', '2nd', 1, 2, '1st Year', 'IT 112'),
(71, 2, NULL, 'IT 122', 'Human Interaction 1', '2nd', 1, 2, '1st Year', 'IT 112'),
(72, 2, NULL, 'IT 123', 'Discrete Mathematics', '2nd', 0, 3, '1st Year', 'None'),
(73, 2, NULL, 'PE 2', 'Physical Activity Towards Health And Fitness 2', '2nd', 0, 2, '1st Year', 'PE 1'),
(74, 2, NULL, 'NSTP 2', 'Cwts/Lts/Ms 2', '2nd', 0, 3, '1st Year', 'NSTP 1'),
(75, 2, NULL, 'GEC 6', 'Science, Technology And Society', '1st', 0, 3, '2nd Year', 'None'),
(76, 2, NULL, 'GEC 8', 'The Comtemporary World', '1st', 0, 3, '2nd Year', 'None'),
(77, 2, NULL, 'IT INST 2', 'Creative And Critical Thinking', '1st', 1, 1, '2nd Year', 'None'),
(78, 2, NULL, 'IT GE ELEC 3', 'Foreign Language 2', '1st', 0, 3, '2nd Year', 'None'),
(79, 2, NULL, 'IT 211', 'Data Structures And Algorithms', '1st', 1, 2, '2nd Year', 'IT 121'),
(80, 2, NULL, 'IT ELEC 1', 'Platform Technologies', '1st', 1, 2, '2nd Year', 'IT 121'),
(81, 2, NULL, 'IT ELEC 2', 'Object-Oriented Programming', '1st', 1, 2, '2nd Year', 'IT 121'),
(82, 2, NULL, 'IT BPO 1', 'Business Communication', '1st', 0, 3, '2nd Year', 'None'),
(83, 2, NULL, 'PE 3', 'Physical Activity Towards Health And Fitness III', '1st', 0, 2, '2nd Year', 'PE 1, PE 2'),
(84, 2, NULL, 'IT GE ELEC 4', 'The Entreprenurial Mind', '2nd', 0, 3, '2nd Year', 'None'),
(85, 2, NULL, 'GEC 9', 'The Life And Works Of Rizal', '2nd', 0, 3, '2nd Year', 'None'),
(86, 2, NULL, 'IT 221', 'Information Management', '2nd', 1, 2, '2nd Year', 'IT 121'),
(87, 2, NULL, 'IT 222', 'Networking 1', '2nd', 1, 2, '2nd Year', 'IT ELEC 1'),
(88, 2, NULL, 'IT 223', 'Quantitative Methods (Including Modeling And Simulations)', '2nd', 0, 3, '2nd Year', 'IT 221, IT 123'),
(89, 2, NULL, 'IT 224', 'Integrative Programming Technologies', '2nd', 1, 2, '2nd Year', 'IT ELEC 1, IT ELEC 2'),
(90, 2, NULL, 'IT 225', 'Accounting For Information Technology', '2nd', 0, 3, '2nd Year', 'None'),
(91, 2, NULL, 'IT APPDEV 1', 'Fundamentals Of Mobile Technology', '2nd', 1, 2, '2nd Year', 'IT ELEC 1, IT ELEC 2'),
(92, 2, NULL, 'PE 4', 'Physical Activity Towards Health And Fitness VI (Dance, Team Sports,Outdorr, And Adventure Activities)', '2nd', 0, 2, '2nd Year', 'PE 1, PE 2, PE 3'),
(93, 2, NULL, 'IT 226', 'Applications Development And Emerging Technologies', 'Summer/MidYear', 1, 2, '2nd Year', 'IT 221'),
(94, 2, NULL, 'IT ELEC 3', 'Web Systems And Technologies', 'Summer/MidYear', 1, 2, '2nd Year', 'None'),
(95, 2, NULL, 'IT Inst 3', 'Data Science And Analytics', '1st', 0, 2, '3rd Year', 'None'),
(96, 2, NULL, 'IT 311', 'Advanced Database Systems', '1st', 1, 2, '3rd Year', 'IT 221'),
(97, 2, NULL, 'IT 312', 'Networking 2', '1st', 0, 2, '3rd Year', 'IT 222'),
(98, 2, NULL, 'IT 313', 'System Integration And Architecture', '1st', 0, 3, '3rd Year', 'IT 224'),
(99, 2, NULL, 'IT 314', 'Information Assurance And Technology 1', '1st', 0, 3, '3rd Year', 'IT 224'),
(100, 2, NULL, 'IT APPDEV 2', 'Web Applications', '1st', 1, 2, '3rd Year', 'IT ELEC 3'),
(101, 2, NULL, 'IT APPDEV 3', 'Mobile Applications', '1st', 1, 2, '3rd Year', 'IT APPDEV 1'),
(102, 2, NULL, 'IT GE ELEC 5', 'Multicultural Education', '2nd', 0, 3, '3rd Year', 'None'),
(103, 2, NULL, 'IT 321', 'Information Assurance And Security 2', '2nd', 1, 2, '3rd Year', 'IT 314'),
(104, 2, NULL, 'IT 322', 'Social And Professional Issues', '2nd', 0, 3, '3rd Year', 'GEC 7'),
(105, 2, NULL, 'IT 323', 'Capstone Project And Research 1', '2nd', 1, 2, '2nd Year', 'IT 226, IT 314'),
(106, 2, NULL, 'IT 323', 'Capstone Project And Research 1', '2nd', 1, 2, '3rd Year', 'IT 226, IT 314'),
(107, 2, NULL, 'IT APPDEV 4', 'Game Development', '2nd', 1, 2, '3rd Year', 'IT APPDEV 2, IT APPDEV 3'),
(108, 2, NULL, 'IT APPDEV 5', 'Cloud Computing', '2nd', 1, 2, '3rd Year', 'IT APPDEV 2, IT APPDEV 3'),
(109, 2, NULL, 'IT GE ELEC 6', 'Leadership And Management In The Profession', '1st', 0, 3, '4th Year', 'None'),
(110, 2, NULL, 'IT 411', 'System Administration And Maintenance', '1st', 1, 2, '4th Year', 'IT 321'),
(111, 2, NULL, 'IT ELEC 4', 'Human Computer Interaction 2', '1st', 1, 2, '4th Year', 'IT 122'),
(112, 2, NULL, 'IT 412', 'Capstone Project And Research 2', '1st', 1, 2, '4th Year', 'IT 323'),
(113, 3, NULL, 'GEC 4', 'Purposive Communication', '1st', 0, 3, '1st Year', 'None'),
(114, 3, NULL, 'GEC 5', 'Art Appreciation', '1st', 0, 3, '1st Year', 'None'),
(115, 3, NULL, 'IT INST 1', 'Climate Change And Disaster Risk Management', '1st', 0, 2, '1st Year', 'None'),
(116, 3, NULL, 'IT GE ELEC 1', 'Health And Wellness Science', '1st', 0, 3, '1st Year', 'None'),
(117, 3, NULL, 'IT GE ELEC 2', 'Foreign Language 1', '1st', 0, 3, '1st Year', 'None'),
(118, 3, NULL, 'IT 111', 'Introduction To Computing', '1st', 1, 2, '1st Year', 'None'),
(119, 3, NULL, 'IT 112', 'Computer Programming 1', '1st', 1, 2, '1st Year', 'None'),
(120, 3, NULL, 'PE 1', 'Physical Activity Towards Health And Fitness 1', '1st', 0, 2, '1st Year', 'None'),
(121, 3, NULL, 'NSTP 1', 'Cwts/Lts/Ms 1', '1st', 0, 3, '1st Year', 'None'),
(122, 3, NULL, 'GEC 1', 'Understanding The Self', '2nd', 0, 3, '1st Year', 'None'),
(123, 3, NULL, 'GEC 2', 'Readings In The Philippines History', '2nd', 0, 3, '1st Year', 'None'),
(124, 3, NULL, 'GEC 3', 'Mathematics In The Modern World', '2nd', 0, 3, '1st Year', 'None'),
(125, 3, NULL, 'GEC 7', 'Ethics', '2nd', 0, 3, '1st Year', 'None'),
(126, 3, NULL, 'IT 121', 'Computer Programming 2', '2nd', 1, 2, '1st Year', 'IT 112'),
(127, 3, NULL, 'IT 122', 'Human Interaction 1', '2nd', 1, 2, '1st Year', 'IT 112'),
(128, 3, NULL, 'IT 123', 'Discrete Mathematics', '2nd', 0, 3, '1st Year', 'None'),
(129, 3, NULL, 'PE 2', 'Physical Activity Towards Health And Fitness 2', '2nd', 0, 2, '1st Year', 'PE 1'),
(130, 3, NULL, 'NSTP 2', 'Cwts/Lts/Ms 2', '2nd', 0, 3, '1st Year', 'NSTP 1'),
(131, 3, NULL, 'GEC 6', 'Science, Technology And Society', '1st', 0, 3, '2nd Year', 'None'),
(132, 3, NULL, 'GEC 8', 'The Comtemporary World', '1st', 0, 3, '2nd Year', 'None'),
(133, 3, NULL, 'IT INST 2', 'Creative And Critical Thinking', '1st', 1, 1, '2nd Year', 'None'),
(134, 3, NULL, 'IT GE ELEC 3', 'Foreign Language 2', '1st', 0, 3, '2nd Year', 'None'),
(135, 3, NULL, 'IT 211', 'Data Structures And Algorithms', '1st', 1, 2, '2nd Year', 'IT 121'),
(136, 3, NULL, 'IT ELEC 1', 'Platform Technologies', '1st', 1, 2, '2nd Year', 'IT 121'),
(137, 3, NULL, 'IT ELEC 2', 'Object-Oriented Programming', '1st', 1, 2, '2nd Year', 'IT 121'),
(138, 3, NULL, 'IT BPO 1', 'Business Communication', '1st', 0, 3, '2nd Year', 'None'),
(139, 3, NULL, 'PE 3', 'Physical Activity Towards Health And Fitness III', '1st', 0, 2, '2nd Year', 'PE 1, PE 2'),
(140, 3, NULL, 'IT GE ELEC 4', 'The Entreprenurial Mind', '2nd', 0, 3, '2nd Year', 'None'),
(141, 3, NULL, 'GEC 9', 'The Life And Works Of Rizal', '2nd', 0, 3, '2nd Year', 'None'),
(142, 3, NULL, 'IT 221', 'Information Management', '2nd', 2, 3, '2nd Year', 'IT 121'),
(143, 3, NULL, 'IT 222', 'Networking 1', '2nd', 1, 2, '2nd Year', 'IT ELEC 1'),
(144, 3, NULL, 'IT 223', 'Quantitative Methods (Including Modeling And Simulations)', '2nd', 0, 3, '2nd Year', 'IT 221, IT 123'),
(145, 3, NULL, 'IT 224', 'Integrative Programming Technologies', '2nd', 1, 2, '2nd Year', 'IT ELEC 1, IT ELEC 2'),
(146, 3, NULL, 'IT 225', 'Accounting For Information Technology', '2nd', 0, 3, '2nd Year', 'None'),
(147, 3, NULL, 'PE 4', 'Physical Activity Towards Health And Fitness VI (Dance, Team Sports,Outdorr, And Adventure Activities)', '2nd', 0, 2, '2nd Year', 'PE 1, PE 2, PE 3'),
(148, 3, NULL, 'IT 226', 'Applications Development And Emerging Technologies', 'Summer/MidYear', 1, 2, '2nd Year', 'IT 221'),
(149, 3, NULL, 'IT ELEC 3', 'Web Systems And Technologies', 'Summer/MidYear', 1, 2, '2nd Year', 'None'),
(150, 3, NULL, 'IT 311', 'Advanced Database Systems', '1st', 1, 2, '3rd Year', 'IT 221'),
(151, 3, NULL, 'IT 312', 'Networking 2', '1st', 1, 2, '3rd Year', 'IT 222'),
(152, 3, NULL, 'IT 313', 'System Integration And Architecture', '1st', 1, 2, '3rd Year', 'IT 224'),
(153, 3, NULL, 'IT 314', 'Information Assurance And Technology 1', '1st', 1, 2, '3rd Year', 'IT 224'),
(154, 3, NULL, 'IT BA 1', 'Fundamentals Of Business Analytics', '1st', 1, 2, '3rd Year', 'None'),
(155, 3, NULL, 'IT BA 2', 'Fundamentals Of Enterprise Data Management', '1st', 1, 2, '3rd Year', 'None'),
(156, 3, NULL, 'IT GE ELEC 5', 'Multicultural Education', '2nd', 0, 3, '3rd Year', 'None'),
(157, 3, NULL, 'IT 321', 'Information Assurance And Security 2', '2nd', 1, 2, '3rd Year', 'IT 314'),
(158, 3, NULL, 'IT 322', 'Social And Professional Issues', '2nd', 0, 3, '3rd Year', 'GEC 7'),
(159, 3, NULL, 'IT 323', 'Capstone Project And Research 1', '2nd', 1, 2, '3rd Year', 'IT 226, IT 314'),
(160, 3, NULL, 'IT BA 3', 'Fundamnetals Of Analytics Modeling', '2nd', 1, 2, '3rd Year', 'IT BA 1'),
(161, 3, NULL, 'IT BA 4', 'Analytics Techniques And Tools', '2nd', 1, 2, '3rd Year', 'IT BA 2'),
(162, 3, NULL, 'IT GE ELEC 6', 'Leadership And Management In The Profession', '1st', 0, 3, '4th Year', 'None'),
(163, 3, NULL, 'IT 411', 'System Administration And Maintenance', '1st', 1, 2, '4th Year', 'IT 321'),
(164, 3, NULL, 'IT ELEC 4', 'Human Computer Interaction 2', '1st', 1, 2, '4th Year', 'IT 122'),
(165, 3, NULL, 'IT 412', 'Capstone Project And Research 2', '1st', 1, 2, '4th Year', 'IT 323'),
(166, 3, NULL, 'IT BA 5', 'Analytics Application', '1st', 1, 2, '4th Year', 'IT BA 1, IT BA 2'),
(167, 3, NULL, 'IT 421', 'Internship/Ojt/Practicum(486 Hours)', '2nd', 0, 9, '4th Year', '4th Year Standing'),
(168, 4, NULL, 'GEC 4', 'Purposive Communication', '1st', 0, 3, '1st Year', 'None'),
(169, 4, NULL, 'GEC 5', 'Art Appreciation', '1st', 0, 3, '1st Year', 'None'),
(170, 4, NULL, 'IT INST 1', 'Climate Change And Disaster Risk Management', '1st', 0, 2, '1st Year', 'None'),
(171, 4, NULL, 'IT GE ELEC 1', 'Health And Wellness Science', '1st', 0, 3, '1st Year', 'None'),
(172, 4, NULL, 'IT GE ELEC 2', 'Foreign Language 1', '1st', 0, 3, '1st Year', 'None'),
(173, 4, NULL, 'IT 111', 'Introduction To Computing', '1st', 1, 2, '1st Year', 'None'),
(174, 4, NULL, 'IT 112', 'Computer Programming 1', '1st', 1, 2, '1st Year', 'None'),
(175, 4, NULL, 'PE 1', 'Physical Activity Towards Health And Fitness 1', '1st', 0, 2, '1st Year', 'None'),
(176, 4, NULL, 'NSTP 1', 'Cwts/Lts/Ms 1', '1st', 0, 3, '1st Year', 'None'),
(177, 4, NULL, 'GEC 1', 'Understanding The Self', '2nd', 0, 3, '1st Year', 'None'),
(178, 4, NULL, 'GEC 2', 'Readings In The Philippines History', '2nd', 0, 3, '1st Year', 'None'),
(179, 4, NULL, 'GEC 3', 'Mathematics In The Modern World', '2nd', 0, 3, '1st Year', 'None'),
(180, 4, NULL, 'GEC 7', 'Ethics', '2nd', 0, 3, '1st Year', 'None'),
(181, 4, NULL, 'IT 121', 'Computer Programming 2', '2nd', 1, 2, '1st Year', 'IT 112'),
(182, 4, NULL, 'IT 122', 'Human Interaction 1', '2nd', 1, 2, '1st Year', 'IT 112'),
(183, 4, NULL, 'IT 123', 'Discrete Mathematics', '2nd', 0, 3, '1st Year', 'None'),
(184, 4, NULL, 'PE 2', 'Physical Activity Towards Health And Fitness 2', '2nd', 0, 2, '1st Year', 'PE 1'),
(185, 4, NULL, 'NSTP 2', 'Cwts/Lts/Ms 2', '2nd', 0, 3, '1st Year', 'NSTP 1'),
(186, 4, NULL, 'GEC 6', 'Science, Technology And Society', '1st', 0, 3, '2nd Year', 'None'),
(187, 4, NULL, 'GEC 8', 'The Comtemporary World', '1st', 0, 3, '2nd Year', 'None'),
(188, 4, NULL, 'IT INST 2', 'Creative And Critical Thinking', '1st', 1, 1, '2nd Year', 'None'),
(189, 4, NULL, 'IT GE ELEC 3', 'Foreign Language 2', '1st', 0, 3, '2nd Year', 'None'),
(190, 4, NULL, 'IT 211', 'Data Structures And Algorithms', '1st', 1, 2, '2nd Year', 'IT 121'),
(191, 4, NULL, 'IT ELEC 1', 'Platform Technologies', '1st', 1, 2, '2nd Year', 'IT 121'),
(192, 4, NULL, 'IT ELEC 2', 'Object-Oriented Programming', '1st', 1, 2, '2nd Year', 'IT 121'),
(193, 4, NULL, 'IT BPO 1', 'Business Communication', '1st', 0, 3, '2nd Year', 'None'),
(194, 4, NULL, 'PE 3', 'Physical Activity Towards Health And Fitness III', '1st', 0, 2, '2nd Year', 'PE 1, PE 2'),
(195, 4, NULL, 'IT GE ELEC 4', 'The Entreprenurial Mind', '2nd', 0, 3, '2nd Year', 'None'),
(196, 4, NULL, 'GEC 9', 'The Life And Works Of Rizal', '2nd', 0, 3, '2nd Year', 'None'),
(197, 4, NULL, 'IT 221', 'Information Management', '2nd', 1, 2, '2nd Year', 'IT 121'),
(198, 4, NULL, 'IT 222', 'Networking 1', '2nd', 1, 2, '2nd Year', 'IT ELEC 1'),
(199, 4, NULL, 'IT 223', 'Quantitative Methods (Including Modeling And Simulations)', '2nd', 0, 3, '2nd Year', 'IT 221, IT 123'),
(200, 4, NULL, 'IT 224', 'Integrative Programming Technologies', '2nd', 1, 2, '2nd Year', 'IT ELEC 1, IT ELEC 2'),
(201, 4, NULL, 'IT 225', 'Accounting For Information Technology', '2nd', 0, 3, '2nd Year', 'None'),
(202, 4, NULL, 'IT BPO 2', 'Service Culture', '2nd', 1, 2, '2nd Year', 'None'),
(203, 4, NULL, 'PE 4', 'Physical Activity Towards Health And Fitness VI (Dance, Team Sports,Outdorr, And Adventure Activities)', '2nd', 0, 2, '2nd Year', 'PE 1, PE 2, PE 3'),
(204, 4, NULL, 'IT 226', 'Applications Development And Emerging Technologies', 'Summer/MidYear', 1, 2, '2nd Year', 'IT 221'),
(205, 4, NULL, 'IT ELEC 3', 'Web Systems And Technologies', 'Summer/MidYear', 1, 2, '2nd Year', 'None'),
(206, 4, NULL, 'IT 311', 'Advanced Database Systems', '1st', 1, 2, '3rd Year', 'IT 221'),
(207, 4, NULL, 'IT 312', 'Networking 2', '1st', 1, 2, '3rd Year', 'IT 222'),
(208, 4, NULL, 'IT 313', 'System Integration And Arcitecture', '1st', 1, 2, '3rd Year', 'IT 224'),
(209, 4, NULL, 'IT 314', 'Information Assurance And Technology 1', '1st', 1, 2, '3rd Year', 'IT 224'),
(210, 4, NULL, 'IT BPO 3', 'Fundamentals of Business Process Outsourcing 101', '1st', 1, 2, '3rd Year', 'IT BPO 1, IT BPO 2'),
(211, 4, NULL, 'IT BPO 4', 'System Thinking', '1st', 1, 2, '3rd Year', 'IT BPO 1, IT BPO 3'),
(212, 4, NULL, 'IT GE ELEC 5', 'Multicultural Education', '2nd', 0, 3, '3rd Year', 'None'),
(213, 4, NULL, 'IT 321', 'Information Assurance And Security 2', '2nd', 1, 2, '3rd Year', 'IT 314'),
(214, 4, NULL, 'IT 322', 'Social And Professional Issues', '2nd', 0, 3, '3rd Year', 'GEC 7'),
(215, 4, NULL, 'IT 323', 'Capstone Project And Research 1', '2nd', 1, 2, '3rd Year', 'IT 226, IT 314'),
(216, 4, NULL, 'IT BPO 5', 'Fundamentals of Business Process Outsourcing 102', '2nd', 1, 2, '3rd Year', 'IT BPO 3'),
(217, 4, NULL, 'IT GE ELEC 6', 'Leadership And Management In The Profession', '1st', 0, 3, '4th Year', 'None'),
(218, 4, NULL, 'IT 411', 'System Administration And Maintenance', '1st', 1, 2, '4th Year', 'IT 321'),
(219, 4, NULL, 'IT ELEC 4', 'Human Computer Interaction 2', '1st', 1, 2, '4th Year', 'IT 122'),
(220, 4, NULL, 'IT 412', 'Capstone Project And Research 2', '1st', 1, 2, '4th Year', 'IT 323'),
(221, 4, NULL, 'IT 421', 'Internship/Ojt/Practicum(486 Hours)', '2nd', 0, 9, '4th Year', '4th Year Standing'),
(222, 9, NULL, 'INST 1', 'Climate Change and Disaster Risk Management', '1st', 0, 2, '1st Year', 'None'),
(223, 9, NULL, 'EMC 111', 'Introduction To Computing', '1st', 0, 3, '1st Year', 'None'),
(224, 9, NULL, 'EMC 112', 'Computer Programming 1', '1st', 1, 2, '1st Year', 'None'),
(225, 9, NULL, 'GEC 1', 'Understanding The Self', '1st', 0, 3, '1st Year', 'None'),
(226, 9, NULL, 'GEC 3', 'Mathematics In The Modern World', '1st', 0, 3, '1st Year', 'None'),
(227, 9, NULL, 'GEC 4', 'Purposive Communication', '1st', 0, 3, '1st Year', 'None'),
(228, 9, NULL, 'GEC 8', 'The Contemporary World', '1st', 0, 3, '1st Year', 'None'),
(229, 9, NULL, 'PE 1', 'Physical Education 1', '1st', 0, 2, '1st Year', 'None'),
(230, 9, NULL, 'NSTP 1', 'Cwts/Lts/Ms 1', '1st', 0, 3, '1st Year', 'None'),
(231, 9, NULL, 'GEC 17', 'IT Infrastructure', '2nd', 0, 3, '1st Year', 'None'),
(232, 9, NULL, 'EMC 121', 'Freehand And Digital Drawing', '2nd', 1, 2, '1st Year', 'None'),
(233, 9, NULL, 'EMC 122', 'Computer Programming 2', '2nd', 1, 2, '1st Year', 'EMC 112'),
(234, 9, NULL, 'GEC 2', 'Readings In Philippine History', '2nd', 0, 3, '1st Year', 'None'),
(235, 9, NULL, 'GEC 5', 'Art Appreciation', '2nd', 0, 3, '1st Year', 'None'),
(236, 9, NULL, 'GEC 6', 'Science, Technology and Society', '2nd', 0, 3, '1st Year', 'None'),
(237, 9, NULL, 'GEC 10', 'Reading Comprehension', '2nd', 0, 3, '1st Year', 'None'),
(238, 9, NULL, 'PE 2', 'Physical Education 2', '2nd', 0, 2, '1st Year', 'PE 1'),
(239, 9, NULL, 'NSTP 2', 'Cwts/Lts/Ms 2', '2nd', 0, 3, '1st Year', 'NSTP 1'),
(240, 9, NULL, 'INST 2', 'Creative And Critical Thinking', '1st', 0, 2, '2nd Year', 'None'),
(241, 9, NULL, 'EMC 211', 'Introduction To Game Design and Development', '1st', 1, 2, '2nd Year', 'EMC 122'),
(242, 9, NULL, 'EMC 212', 'Principles Of 2D Animation', '1st', 1, 2, '2nd Year', 'EMC 121'),
(243, 9, NULL, 'EMC 213', 'Data Structures And Algorithms', '1st', 1, 2, '2nd Year', 'EMC 122'),
(244, 9, NULL, 'GEC 9', 'Life And Works of Rizal', '1st', 0, 3, '2nd Year', 'None'),
(245, 9, NULL, 'GEC 13', 'Analytic Geometry', '1st', 0, 3, '2nd Year', 'GEC 3'),
(246, 9, NULL, 'GEC 15', 'Elementary Physics', '1st', 0, 3, '2nd Year', 'None'),
(247, 9, NULL, 'PE 3', 'Physical Education 3', '1st', 0, 2, '2nd Year', 'PE 2'),
(248, 9, NULL, 'EMC DA 1', 'Image And Video Processing', '2nd', 1, 2, '2nd Year', 'EMC 213'),
(249, 9, NULL, 'EMC 221', 'Computer Graphics Programming', '2nd', 1, 2, '2nd Year', 'EMC 213'),
(250, 9, NULL, 'EMC 222', 'Usability, HCI and User Interface Design', '2nd', 1, 2, '2nd Year', 'EMC 122'),
(251, 9, NULL, 'EMC 223', 'Principles Of 3D Animation', '2nd', 1, 2, '2nd Year', 'EMC 212'),
(252, 9, NULL, 'GEC 11', 'Creative Writing', '2nd', 0, 3, '2nd Year', 'None'),
(253, 9, NULL, 'GEC 14', 'Trigometry', '2nd', 0, 3, '2nd Year', 'GEC 13'),
(254, 9, NULL, 'GEC 16', 'General Physics', '2nd', 0, 3, '2nd Year', 'GEC 15'),
(255, 9, NULL, 'PE 4', 'Physical Education 4', '2nd', 0, 2, '2nd Year', 'PE 3'),
(256, 9, NULL, 'EMC DA 2', 'Modelling And Rigging', '1st', 0, 3, '3rd Year', ''),
(257, 9, NULL, 'EMC DA 3', 'Lightning and Effects', '1st', 0, 3, '3rd Year', ''),
(258, 9, NULL, 'EMC DA 4', 'Texture And Mapping', '1st', 0, 0, '3rd Year', ''),
(259, 9, NULL, 'EMC DA 5', 'Advanced 2D Animation', '1st', 0, 0, '3rd Year', ''),
(260, 9, NULL, 'EMC 311', 'Script Writing And Storyboard Design', '1st', 0, 0, '3rd Year', ''),
(261, 9, NULL, 'EMC 312', 'Design And Production Process', '1st', 0, 0, '3rd Year', ''),
(262, 9, NULL, 'EMC 313', 'Audio Design and Sound Engineering', '1st', 0, 0, '3rd Year', ''),
(263, 9, NULL, 'EMC', 'Reading Visual Arts', '1st', 0, 0, '3rd Year', ''),
(264, 9, NULL, 'ELECTIVE 1', 'Elective 1', '1st', 0, 0, '3rd Year', ''),
(265, 9, NULL, 'EMC DA 6', 'Advanced 3D Animation and Scripting', '2nd', 0, 0, '3rd Year', ''),
(266, 9, NULL, 'EMC DA 7', 'Advanced Sound Production', '2nd', 0, 0, '3rd Year', ''),
(267, 9, NULL, 'EMC DA 8', 'Compositing And Rendering', '2nd', 0, 0, '3rd Year', ''),
(268, 9, NULL, 'EMC 321', 'Capstone Project 1', '2nd', 0, 3, '3rd Year', ''),
(269, 9, NULL, 'EMC 322', 'Information Management', '2nd', 0, 0, '3rd Year', ''),
(270, 9, NULL, 'EMC 323', 'Application Development and Emerging Technologies', '2nd', 0, 0, '3rd Year', ''),
(271, 9, NULL, 'GEC 12', 'Technical Writing in The Discipline', '2nd', 0, 0, '3rd Year', ''),
(272, 9, NULL, 'GEC 7', 'Ethics', 'Summer/MidYear', 0, 3, '3rd Year', 'None'),
(273, 9, NULL, 'EMC', 'Gender And Society', 'Summer/MidYear', 0, 0, '3rd Year', ''),
(274, 9, NULL, 'EMC DA 9', 'Animation Design And Production', '1st', 1, 2, '4th Year', '4th Year Standing'),
(275, 9, NULL, 'EMC ELECIVE 3', 'The Entrepreneurial Mind', '1st', 0, 3, '4th Year', 'None'),
(276, 9, NULL, 'EMC 411', 'Capstone Project 2', '1st', 0, 3, '4th Year', 'EMC 321'),
(277, 9, NULL, 'EMC 421', 'Internship/Ojt/Practicum(486 Hours)', '2nd', 0, 9, '4th Year', '4th Year Standing'),
(278, 8, NULL, 'INST 1', 'Climate Change And Disaster Risk Management', '1st', 0, 2, '1st Year', 'None'),
(279, 8, NULL, 'EMC 111', 'Introduction To Computing', '1st', 0, 3, '1st Year', 'None'),
(280, 8, NULL, 'EMC 112', 'Computer Programming 1', '1st', 1, 2, '1st Year', 'None'),
(281, 8, NULL, 'GEC 1', 'Understanding The Self', '1st', 0, 3, '1st Year', 'None'),
(282, 8, NULL, 'GEC 3', 'Mathematics In The Modern World', '1st', 0, 3, '1st Year', 'None'),
(283, 8, NULL, 'GEC 4', 'Purposive Communication', '1st', 0, 3, '1st Year', 'None'),
(284, 8, NULL, 'GEC 8', 'The Contemporary World', '1st', 0, 3, '1st Year', 'None'),
(285, 8, NULL, 'PE 1', 'Physical Education 1', '1st', 0, 2, '1st Year', 'None'),
(286, 8, NULL, 'NSTP 1', 'Cwts/Lts/Ms 1', '1st', 0, 3, '1st Year', 'None'),
(287, 8, NULL, 'GEC 17', 'IT Infrastructure', '2nd', 0, 3, '1st Year', 'None'),
(288, 8, NULL, 'EMC 121', 'Freehand And Digital Drawing', '2nd', 1, 2, '1st Year', 'None'),
(289, 8, NULL, 'EMC 122', 'Computer Programming 2', '2nd', 1, 2, '1st Year', 'EMC 112'),
(290, 8, NULL, 'GEC 2', 'Readings In Philippine History', '2nd', 0, 3, '1st Year', 'None'),
(291, 8, NULL, 'GEC 5', 'Art Appreciation', '2nd', 0, 3, '1st Year', 'None'),
(292, 8, NULL, 'GEC 6', 'Science, Technology And Society', '2nd', 0, 3, '1st Year', 'None'),
(293, 8, NULL, 'GEC 10', 'Reading Comprehension', '2nd', 0, 3, '1st Year', 'None'),
(294, 8, NULL, 'PE 2', 'Physical Education 2', '2nd', 0, 2, '1st Year', 'PE 1'),
(295, 8, NULL, 'NSTP 2', 'Cwts/Lts/Ms 2', '2nd', 0, 3, '1st Year', 'NSTP 1'),
(296, 8, NULL, 'INST 2', 'Creative And Critical Thinking', '1st', 0, 2, '2nd Year', 'None'),
(297, 8, NULL, 'EMC 211', 'Introduction To Game Design and Development', '1st', 1, 2, '2nd Year', 'EMC 122'),
(298, 8, NULL, 'EMC 212', 'Principles Of 2D Animation', '1st', 1, 2, '2nd Year', 'EMC 121'),
(299, 8, NULL, 'EMC 213', 'Data Structures and Algorithm', '2nd', 1, 2, '2nd Year', 'EMC 122'),
(300, 8, NULL, 'GEC 9', 'Life And Works of Rizal', '1st', 0, 3, '2nd Year', 'None'),
(301, 8, NULL, 'GEC 13', 'Analytic Geometry', '1st', 0, 3, '2nd Year', 'GEC 3'),
(302, 8, NULL, 'GEC 15', 'Elementary Physics', '1st', 0, 3, '2nd Year', 'None'),
(303, 8, NULL, 'PE 3', 'Physical Education 3', '1st', 0, 2, '2nd Year', 'PE 1'),
(304, 8, NULL, 'EMC DA 1', 'Image And Video Processing', '2nd', 1, 2, '2nd Year', 'EMC 213'),
(305, 8, NULL, 'EMC 221', 'Computer Graphics Programming', '2nd', 1, 2, '2nd Year', 'EMC 213'),
(306, 8, NULL, 'EMC 222', 'Usability, HCI and User Interface Design', '2nd', 1, 2, '2nd Year', 'EMC 122'),
(307, 8, NULL, 'EMC 223', 'Principles Of 3D Animation', '2nd', 1, 2, '2nd Year', 'EMC 212'),
(308, 8, NULL, 'GEC 11', 'Creative Writing', '2nd', 0, 3, '2nd Year', 'None'),
(309, 8, NULL, 'GEC 14', 'Trigometry', '2nd', 0, 3, '2nd Year', 'GEC 13'),
(310, 8, NULL, 'GEC 16', 'General Physics', '2nd', 0, 3, '2nd Year', 'GEC 15'),
(311, 8, NULL, 'PE 4', 'Physical Education 4', '2nd', 0, 2, '2nd Year', 'PE 3'),
(312, 8, NULL, 'EMC DA 2', 'Modelling And Rigging', '1st', 0, 0, '3rd Year', ''),
(313, 8, NULL, 'EMC DA 3', 'Lightning and Effects', '1st', 0, 3, '3rd Year', ''),
(314, 8, NULL, 'EMC DA 4', 'Texture And Mapping', '1st', 0, 0, '3rd Year', ''),
(315, 8, NULL, 'EMC DA 5', 'Advanced 2D Animation', '1st', 0, 0, '3rd Year', ''),
(316, 8, NULL, 'EMC 311', 'Script Writing And Storyboard Design', '1st', 0, 0, '3rd Year', ''),
(317, 8, NULL, 'EMC 312', 'Design And Production Process', '1st', 0, 0, '3rd Year', ''),
(318, 8, NULL, 'EMC 313', 'Audio Design and Sound Engineering', '1st', 0, 0, '3rd Year', ''),
(319, 8, NULL, 'EMC', 'Reading Visual Arts', '1st', 0, 0, '3rd Year', ''),
(320, 8, NULL, 'ELECTIVE 1', 'Elective 1', '1st', 0, 0, '3rd Year', ''),
(321, 8, NULL, 'EMC DA 6', 'Advanced 3D Animation and Scripting', '2nd', 0, 0, '3rd Year', ''),
(322, 8, NULL, 'EMC DA 7', 'Advanced Sound Production', '2nd', 0, 0, '3rd Year', ''),
(323, 8, NULL, 'EMC DA 8', 'Compositing And Rendering', '2nd', 0, 0, '3rd Year', ''),
(324, 8, NULL, 'EMC 321', 'Capstone Project 1', '2nd', 0, 3, '3rd Year', ''),
(325, 8, NULL, 'EMC 322', 'Information Management', '2nd', 0, 0, '3rd Year', ''),
(326, 8, NULL, 'EMC 323', 'Application Development and Emerging Technologies', '2nd', 0, 0, '3rd Year', ''),
(327, 8, NULL, 'GEC 12', 'Technical Writing in The Discipline', '2nd', 0, 0, '3rd Year', ''),
(328, 8, NULL, 'GEC 7', 'Ethics', 'Summer/MidYear', 0, 0, '3rd Year', ''),
(329, 8, NULL, 'EMC', 'Gender And Society', 'Summer/MidYear', 0, 0, '3rd Year', ''),
(330, 8, NULL, 'EMC DA 9', 'Animation Design And Production', '1st', 1, 2, '4th Year', '4th Year Standing'),
(331, 8, NULL, 'EMC ELECIVE 3', 'The Entrepreneurial Mind', '1st', 0, 3, '4th Year', 'None'),
(332, 8, NULL, 'EMC 411', 'Capstone Project 2', '1st', 0, 3, '4th Year', 'EMC 321'),
(333, 8, NULL, 'EMC 421', 'Internship/Ojt/Practicum(486 Hours)', '2nd', 0, 9, '4th Year', '4th Year Standing'),
(334, 7, NULL, 'INST 1', 'Climate Change And Disaster Risk Management', '1st', 0, 2, '1st Year', 'None'),
(335, 7, NULL, 'EMC 111', 'Introduction To Computing', '1st', 0, 3, '1st Year', 'None'),
(336, 7, NULL, 'EMC 112', 'Computer Programming 1', '1st', 1, 2, '1st Year', 'None'),
(337, 7, NULL, 'GEC 1', 'Understanding The Self', '1st', 0, 3, '1st Year', 'None'),
(338, 7, NULL, 'GEC 3', 'Mathematics In The Modern World', '1st', 0, 3, '1st Year', 'None'),
(339, 7, NULL, 'GEC 4', 'Purposive Communication', '1st', 0, 3, '1st Year', 'None'),
(340, 7, NULL, 'GEC 8', 'The Contemporary World', '1st', 0, 3, '1st Year', 'None'),
(341, 7, NULL, 'PE 1', 'Physical Education 1', '1st', 0, 2, '1st Year', 'None'),
(342, 7, NULL, 'GEC 17', 'IT Infrastructure', '2nd', 0, 3, '1st Year', 'None'),
(343, 7, NULL, 'EMC 121', 'Freehand And Digital Drawing', '2nd', 1, 2, '1st Year', 'None'),
(344, 7, NULL, 'EMC 122', 'Computer Programming 2', '2nd', 1, 2, '1st Year', 'EMC 112'),
(345, 7, NULL, 'GEC 2', 'Readings In Philippine History', '2nd', 0, 3, '1st Year', 'None'),
(346, 7, NULL, 'GEC 5', 'Art Appreciation', '2nd', 0, 3, '1st Year', 'None'),
(347, 7, NULL, 'GEC 6', 'Science, Technology And Society', '2nd', 0, 3, '1st Year', 'None'),
(348, 7, NULL, 'GEC 10', 'Reading Comprehension', '2nd', 0, 3, '1st Year', 'None'),
(349, 7, NULL, 'PE 2', 'Physical Education 2', '2nd', 0, 2, '1st Year', 'PE 1'),
(350, 7, NULL, 'NSTP 2', 'Cwts/Lts/Ms 2', '2nd', 0, 3, '1st Year', 'NSTP 1'),
(351, 7, NULL, 'NSTP 1', 'Cwts/Lts/Ms 1', '1st', 0, 3, '1st Year', 'None'),
(352, 7, NULL, 'INST 2', 'Creative And Critical Thinking', '1st', 0, 2, '2nd Year', 'None'),
(353, 7, NULL, 'EMC 211', 'Introduction To Game Design And Development', '1st', 1, 2, '2nd Year', 'EMC 122'),
(354, 7, NULL, 'EMC 212', 'Principles Of 2D Animation', '1st', 1, 2, '2nd Year', 'EMC 121'),
(355, 7, NULL, 'EMC 213', 'Data Structures And Algorithm', '1st', 1, 2, '2nd Year', 'EMC 122'),
(356, 7, NULL, 'EMC GD 1', 'Game Programming 1', '1st', 1, 2, '2nd Year', 'EMC 122'),
(357, 7, NULL, 'GEC 9', 'Life And Works Of Rizal', '1st', 0, 3, '2nd Year', 'None'),
(358, 7, NULL, 'GEC 13', 'Analytic Geometry', '1st', 0, 3, '2nd Year', 'GEC 3'),
(359, 7, NULL, 'GEC 15', 'Elementary Physics', '1st', 0, 3, '2nd Year', 'None'),
(360, 7, NULL, 'PE 3', 'Physical Education 3', '1st', 0, 2, '2nd Year', 'PE 2'),
(361, 7, NULL, 'EMC GD 2', 'Game Programming 2', '2nd', 1, 2, '2nd Year', 'EMC GD 2'),
(362, 7, NULL, 'EMC 221', 'Computer Graphics Programming', '2nd', 1, 2, '2nd Year', 'EMC 213'),
(363, 7, NULL, 'EMC 222', 'Usability, HCI and User Interface Design', '2nd', 1, 2, '2nd Year', 'EMC 122'),
(364, 7, NULL, 'EMC 223', 'Principles Of 3D Animation', '2nd', 1, 2, '2nd Year', 'EMC 212'),
(365, 7, NULL, 'GEC 11', 'Creative Writing', '2nd', 1, 2, '2nd Year', 'None'),
(366, 7, NULL, 'GEC 14', 'Trigometry', '2nd', 0, 3, '2nd Year', 'GEC 13'),
(367, 7, NULL, 'GEC 16', 'General Physics', '2nd', 0, 3, '2nd Year', 'GEC 15'),
(368, 7, NULL, 'PE 4', 'Physical Education 4', '2nd', 0, 2, '2nd Year', 'PE 3'),
(369, 7, NULL, 'EMC GD 3', 'Applied Mathematics For Games', '1st', 1, 2, '3rd Year', 'GEC 14'),
(370, 7, NULL, 'EMC GD 4', 'Applied Game Physics', '1st', 1, 2, '3rd Year', 'GEC 16'),
(371, 7, NULL, 'EMC GD 5', 'Game Programming 3', '2nd', 1, 2, '3rd Year', 'EMC GD 2'),
(372, 7, NULL, 'EMC 311', 'Script Writing And Storyboard Design', '1st', 0, 3, '3rd Year', 'EMC 111, GEC 11'),
(373, 7, NULL, 'EMC 312', 'Design And Production Process', '1st', 0, 3, '3rd Year', 'EMC 211'),
(374, 7, NULL, 'EMC 313', 'Audio Design And Sound Engineering', '1st', 1, 2, '3rd Year', 'EMC 211'),
(375, 7, NULL, 'EMC ELECTIVE 1', 'Reading Visual Arts', '1st', 0, 3, '3rd Year', 'None'),
(376, 7, NULL, 'EMC GD 6', 'Artificial Intelligence In Games', '2nd', 1, 2, '3rd Year', 'EMC 224'),
(377, 7, NULL, 'EMC GD 7', 'Advanced Game Design', '2nd', 1, 2, '3rd Year', 'EMC GD 5'),
(378, 7, NULL, 'EMC GD 8', 'Game Networking', '2nd', 1, 2, '3rd Year', 'EMC 223'),
(379, 7, NULL, 'EMC 321', 'Capstone Project 1', '2nd', 0, 3, '3rd Year', 'EMC GD 313'),
(380, 7, NULL, 'EMC 322', 'Information Management', '2nd', 1, 2, '3rd Year', 'EMC 213'),
(381, 7, NULL, 'EMC 323', 'Application Development And Emerging Technologies', '2nd', 1, 2, '3rd Year', 'EMC 122'),
(382, 7, NULL, 'GEC 12', 'Technical Writing In The Discipline', '2nd', 0, 3, '3rd Year', 'None'),
(383, 7, NULL, 'GEC 7', 'Ethics', 'Summer/MidYear', 0, 3, '3rd Year', 'None'),
(384, 7, NULL, 'EMC ELECTIVE 2', 'Gender And Society', 'Summer/MidYear', 0, 3, '3rd Year', 'None'),
(385, 7, NULL, 'EMC 213', 'Data Science and Algorithm', 'Summer/MidYear', 0, 2, '3rd Year', 'None'),
(386, 7, NULL, 'EMC GD 9', 'Game Production', '1st', 1, 2, '4th Year', '4th Year Standing'),
(387, 7, NULL, 'EMC ELECIVE 3', 'The Entrepreneurial Mind', '1st', 0, 3, '4th Year', 'None'),
(388, 7, NULL, 'EMC 411', 'Capstone Project 2', '1st', 0, 3, '4th Year', 'EMC 321'),
(389, 7, NULL, 'EMC 421', 'Internship/Ojt/Practicum(486 Hours)', '2nd', 0, 9, '4th Year', '4th Year Standing'),
(390, 6, NULL, 'CS INST 1', 'Climate Change And Disaster Risk Management', '1st', 0, 2, '1st Year', 'None'),
(391, 6, NULL, 'GEC 3', 'Mathematics In The Modern World', '1st', 0, 3, '1st Year', 'None'),
(392, 6, NULL, 'GEC 4', 'Purposive Communication', '1st', 0, 3, '1st Year', 'None'),
(393, 6, NULL, 'GE ELEC CS 1', 'Health And Wellness Science', '1st', 0, 3, '1st Year', 'None'),
(394, 6, NULL, 'GE ELEC CS 2', 'Gender And Society', '1st', 0, 3, '1st Year', 'None'),
(395, 6, NULL, 'CS 111', 'Introduction To Computing', '1st', 1, 2, '1st Year', 'None'),
(396, 6, NULL, 'CS 112', 'Fundamentals Of Programming', '1st', 1, 2, '1st Year', 'None'),
(397, 6, NULL, 'PE 1', 'Physical Activity Towards Health And Fitness 1', '1st', 0, 2, '1st Year', 'None'),
(398, 6, NULL, 'NSTP 1', 'Cwts/Lts/Ms 1', '1st', 0, 3, '1st Year', 'None'),
(399, 6, NULL, 'GEC 1', 'Understanding The Self', '2nd', 0, 3, '1st Year', 'None'),
(400, 6, NULL, 'GEC 2', 'Readings In The Philippines History', '2nd', 0, 3, '1st Year', 'None'),
(401, 6, NULL, 'GEC 5', 'Art Appreciation', '2nd', 0, 3, '1st Year', 'None'),
(402, 6, NULL, 'GE ELEC CS 3', 'Foreign Language 1', '2nd', 0, 3, '1st Year', 'None'),
(403, 6, NULL, 'CS 121', 'Discrete Structures 1', '2nd', 0, 3, '1st Year', 'None'),
(404, 6, NULL, 'CS 122', 'Intermediate Programming', '2nd', 1, 2, '1st Year', 'GEC 3'),
(405, 6, NULL, 'PE 2', 'Physical Activity Towards Health And Fitness 2', '2nd', 0, 2, '1st Year', 'PE 1'),
(406, 6, NULL, 'NSTP 2', 'Cwts/Lts/Ms 2', '2nd', 0, 3, '1st Year', 'NSTP 1'),
(407, 6, NULL, 'GEC 6', 'Science, Technology And Society', '1st', 0, 3, '2nd Year', 'None'),
(408, 6, NULL, 'GEC 8', 'The Contemporary World', '1st', 0, 3, '2nd Year', 'None'),
(409, 6, NULL, 'CS INST 2', 'Creative And Critical Thinking', '1st', 1, 1, '2nd Year', 'None'),
(410, 6, NULL, 'CS 211', 'Discrete Structures 2', '1st', 0, 3, '2nd Year', 'CS 121'),
(411, 6, NULL, 'CS 212', 'Object-Oriented Programming', '1st', 1, 2, '2nd Year', 'CS 122'),
(412, 6, NULL, 'CS 213', 'Data Structures And Algorithms', '1st', 1, 2, '2nd Year', 'CS 122'),
(413, 6, NULL, 'CS 214', 'Calculus With Analytic Geometry', '1st', 0, 3, '2nd Year', '2nd Year Standing'),
(414, 6, NULL, 'CS ELEC 1', 'Cs Elective 1', '1st', 1, 2, '2nd Year', '2nd Year Standing'),
(415, 6, NULL, 'PE 3', 'Physical Activity Towards Health And Fitness III', '1st', 0, 2, '2nd Year', 'PE 1, PE 2'),
(416, 6, NULL, 'GEC 7', 'Ethics', '2nd', 0, 3, '2nd Year', 'None'),
(417, 6, NULL, 'GEC 9', 'The Life And Works Of Rizal', '2nd', 0, 3, '2nd Year', 'None'),
(418, 6, NULL, 'CS GE ELEC 1', 'The Entrepreneurial Mind', '2nd', 0, 3, '2nd Year', 'CS INST 2'),
(419, 6, NULL, 'CS GE ELEC 4', 'Technical Writing', '2nd', 0, 3, '2nd Year', 'None'),
(420, 6, NULL, 'CS 221', 'Algorithms And Complexity', '2nd', 0, 3, '2nd Year', 'CS 213, CS 211'),
(421, 6, NULL, 'CS 222', 'Information Management', '2nd', 1, 2, '2nd Year', 'CS 122'),
(422, 6, NULL, 'CS BA 1', 'Fundamentals Of Business Analytics', '2nd', 1, 2, '2nd Year', '2nd Year Standing'),
(423, 6, NULL, 'CS BA 2', 'Fundamentals Of Enterprise Data Management', '2nd', 1, 2, '2nd Year', '2nd Year Standing'),
(424, 6, NULL, 'PE 4', 'Physical Activity Towards Health And Fitness VI (Dance, Team Sports,Outdorr, And Adventure Activities)', '2nd', 0, 2, '2nd Year', 'PE 1, PE 2, PE 3'),
(425, 6, NULL, 'CS 311', 'Automata Theory And Formal Languages', '1st', 0, 3, '3rd Year', 'CS 221'),
(426, 6, NULL, 'CS 312', 'Architecture And Organization', '1st', 0, 3, '3rd Year', 'CS 213, CS 211'),
(427, 6, NULL, 'CS 313', 'Information Assurance and Security', '1st', 0, 2, '3rd Year', 'CS 222'),
(428, 6, NULL, 'CS 314', 'Software Engineering 1', '1st', 1, 2, '3rd Year', 'CS 222, CS 212'),
(429, 6, NULL, 'CS 315', 'Social And Professional Issues', '1st', 0, 3, '3rd Year', 'CO REQUISITE WITH CS 314'),
(430, 6, NULL, 'CS BA 3', 'Fundamentals Of Analytics Modeling', '1st', 0, 3, '3rd Year', '3rd Year Standing'),
(431, 6, NULL, 'CS BA 4', 'Analytics Techniques And Tools', '1st', 1, 2, '3rd Year', '3rd Year Standing'),
(432, 6, NULL, 'CS 321', 'Cs Thesis Writing 1', '2nd', 1, 2, '3rd Year', 'CS 313, CS GE ELEC 4'),
(433, 6, NULL, 'CS 322', 'Software Engineering 2', '2nd', 1, 2, '3rd Year', 'CS 314'),
(434, 6, NULL, 'CS 323', 'Application Development And Emerging Technologies', '2nd', 1, 2, '3rd Year', 'CS 222'),
(435, 6, NULL, 'CS 324', 'Programming Languages', '2nd', 1, 2, '3rd Year', 'CS 213'),
(436, 6, NULL, 'CS ELEC 2', 'Cs Elective 2', '2nd', 1, 2, '3rd Year', '3rd Year Standing'),
(437, 6, NULL, 'CS BA 5', 'Analytics Application', '2nd', 0, 3, '3rd Year', 'CS BA 3 and 4'),
(438, 6, NULL, 'CS BA 6', 'Data Engineering', '2nd', 1, 2, '3rd Year', 'CS BA 3 and 4'),
(439, 6, NULL, 'CS ELEC 3', 'Cs Elective 3', 'Summer/MidYear', 1, 2, '3rd Year', '4th Year Standing'),
(440, 6, NULL, 'CS GE ELEC 2', 'Multi-Cultural Education', 'Summer/MidYear', 0, 3, '3rd Year', 'None'),
(441, 6, NULL, 'CS GE ELEC 3', 'Leadership And Management In The Profession', 'Summer/MidYear', 0, 3, '3rd Year', 'None'),
(442, 6, NULL, 'CS 412', 'Human Computer Interaction', '1st', 1, 1, '4th Year', 'cs 122'),
(443, 6, NULL, 'CS 413', 'Networks And Communication', '1st', 1, 2, '4th Year', 'CS 213'),
(444, 6, NULL, 'CS 414', 'Operating Systems', '1st', 1, 2, '3rd Year', 'CS 213'),
(445, 6, NULL, 'CS 411', 'CS Thesis Writing 2', '1st', 1, 2, '4th Year', 'CS 321'),
(446, 6, NULL, 'CS 421', 'Internship/Ojt/Practicum(486 Hours)', '2nd', 0, 9, '4th Year', '4th Year Standing'),
(447, 5, NULL, 'CS INST 1', 'Climate Change And Disaster Risk Management', '1st', 0, 2, '1st Year', 'None'),
(448, 5, NULL, 'GEC 3', 'Mathematics In The Modern World', '1st', 0, 3, '1st Year', 'None'),
(449, 5, NULL, 'GEC 4', 'Purposive Communication', '1st', 0, 3, '1st Year', 'None'),
(450, 5, NULL, 'GE ELEC CS 1', 'Health and Wellness Science', '1st', 0, 3, '1st Year', 'None'),
(451, 5, NULL, 'GE ELEC CS 2', 'Gender And Society', '1st', 0, 3, '1st Year', 'None'),
(452, 5, NULL, 'CS 111', 'Introduction To Computing', '1st', 1, 2, '1st Year', 'None'),
(453, 5, NULL, 'CS 112', 'Fundamentals Of Programming', '1st', 1, 2, '1st Year', 'None'),
(454, 5, NULL, 'PE 1', 'Physical Activity Towards Health And Fitness 1', '1st', 0, 2, '1st Year', 'None'),
(455, 5, NULL, 'NSTP 1', 'Cwts/Lts/Ms 1', '1st', 0, 3, '1st Year', 'None'),
(456, 5, NULL, 'GEC 1', 'Understanding The Self', '2nd', 0, 3, '1st Year', 'None'),
(457, 5, NULL, 'GEC 2', 'Readings In The Philippines History', '2nd', 0, 3, '1st Year', 'None'),
(458, 5, NULL, 'GEC 5', 'Art Appreciation', '2nd', 0, 3, '1st Year', 'None'),
(459, 5, NULL, 'GE ELEC CS 3', 'Foreign Language 1', '2nd', 0, 3, '1st Year', 'None'),
(460, 5, NULL, 'CS 121', 'Discrete Mathematics', '2nd', 0, 3, '1st Year', 'None'),
(461, 5, NULL, 'CS 122', 'Intermediate Programming', '2nd', 1, 2, '1st Year', 'None'),
(462, 5, NULL, 'PE 2', 'Physical Activity Towards Health And Fitness 2', '2nd', 0, 2, '1st Year', 'None'),
(463, 5, NULL, 'NSTP 2', 'Cwts/Lts/Ms 2', '2nd', 0, 3, '1st Year', 'None'),
(464, 5, NULL, 'GEC 6', 'Science, Technology And Society', '1st', 0, 3, '2nd Year', 'None'),
(465, 5, NULL, 'GEC 8', 'The Contemporary World', '1st', 0, 3, '2nd Year', 'None'),
(466, 5, NULL, 'CS INST 2', 'Creative And Critical Thinking', '1st', 0, 3, '2nd Year', 'None'),
(467, 5, NULL, 'CS 211', 'Discrete Structures 2', '1st', 1, 2, '2nd Year', 'CS 121'),
(468, 5, NULL, 'CS 212', 'Object-Oriented Programming', '1st', 1, 2, '2nd Year', 'CS 122'),
(469, 5, NULL, 'CS 214', 'Calculus With Analytic Geometry', '1st', 0, 3, '2nd Year', '2nd Year Standing'),
(470, 5, NULL, 'CS ELEC 1', 'Cs Elective 1', '1st', 0, 3, '2nd Year', '2nd Year Standing'),
(471, 5, NULL, 'PE 3', 'Physical Activity Towards Health And Fitness III', '1st', 0, 2, '2nd Year', 'PE 1, PE 2'),
(472, 5, NULL, 'GEC 7', 'Ethics', '2nd', 0, 3, '2nd Year', 'None'),
(473, 5, NULL, 'GEC 9', 'The Life And Works Of Rizal', '2nd', 0, 3, '2nd Year', 'None'),
(474, 5, NULL, 'CS GE ELEC 1', 'The Entrepreneurial Mind', '2nd', 0, 3, '2nd Year', 'CS INST 2'),
(475, 5, NULL, 'CS GE ELEC 4', 'Technical Writing', '2nd', 0, 3, '2nd Year', 'None'),
(476, 5, NULL, 'CS 221', 'Algorithms And Complexity', '2nd', 0, 3, '2nd Year', 'CS 213, CS 211'),
(477, 5, NULL, 'CS 222', 'Information Management', '2nd', 1, 2, '2nd Year', 'CS 122'),
(478, 5, NULL, 'CS DM 1', 'Statistical Methods for Data Analysis and Inference', '2nd', 1, 2, '2nd Year', '2nd Year Standing'),
(479, 5, NULL, 'CS DM 2', 'Data Preparation and Analysis', '2nd', 1, 2, '2nd Year', '2nd Year Standing'),
(480, 5, NULL, 'PE 4', 'Physical Activity Towards Health And Fitness IV (Dance, Team Sports,Outdorr, And Adventure Activities)', '2nd', 2, 2, '2nd Year', 'None'),
(481, 5, NULL, 'CS ELEC 3', 'Cs Elective 3', 'Summer/MidYear', 1, 2, '3rd Year', '4th Year Standing'),
(482, 5, NULL, 'CS GE ELEC 2', 'Multicultural Education', 'Summer/MidYear', 0, 3, '3rd Year', 'None'),
(483, 5, NULL, 'CS GE ELEC 3', 'Leadership And Management In The Profession', 'Summer/MidYear', 0, 3, '3rd Year', 'None'),
(484, 5, NULL, 'CS 311', 'Automata Theory And Formal Languages', '1st', 0, 3, '3rd Year', 'CS 221'),
(485, 5, NULL, 'CS 312', 'Architecture And Organization', '1st', 0, 3, '3rd Year', 'CS 213, CS 121'),
(486, 5, NULL, 'CS 313', 'Information Assurance and Security', '1st', 0, 2, '3rd Year', 'CS 222'),
(487, 5, NULL, 'CS 314', 'Software Engineering 1', '1st', 1, 2, '3rd Year', 'CS 222, CS 212'),
(488, 5, NULL, 'CS 315', 'Social And Professional Issues', '1st', 0, 3, '3rd Year', 'CO REQUISITE WITH CS 314'),
(489, 5, NULL, 'CS DM 3', 'Data Mining Techniques and Tools', '1st', 1, 2, '3rd Year', '3rd Year Standing'),
(490, 5, NULL, 'CS DM 4', 'Data Mining Applications', '1st', 1, 2, '3rd Year', '3rd Year Standing'),
(491, 5, NULL, 'CS 321', 'Cs Thesis Writing 1', '2nd', 1, 2, '3rd Year', 'CS 313, CS GE ELEC 4'),
(492, 5, NULL, 'CS 322', 'Software Engineering 2', '2nd', 1, 2, '3rd Year', 'CS 314'),
(493, 5, NULL, 'CS 323', 'Applications Development And Emerging Technologies', '2nd', 1, 2, '3rd Year', 'CS 222'),
(494, 5, NULL, 'CS 324', 'Programming Languages', '2nd', 1, 2, '3rd Year', 'CS 213'),
(495, 5, NULL, 'CS ELEC 2', 'Cs Elective 2', '2nd', 1, 2, '3rd Year', '3rd Year Standing'),
(496, 5, NULL, 'CS DM 5', 'Algorithms for Data Mining', '2nd', 1, 2, '3rd Year', 'CS DM 3, CS DM 4'),
(497, 5, NULL, 'CS DM 6', 'Data Mining Methodology', '2nd', 1, 2, '3rd Year', 'CS DM 3, CS DM 4'),
(498, 5, NULL, 'CS 412', 'Human Computer Interaction', '1st', 0, 1, '4th Year', 'CS 122'),
(499, 5, NULL, 'CS 413', 'Networks And Communication', '1st', 1, 2, '4th Year', 'CS 213'),
(500, 5, NULL, 'CS 414', 'Operating Systems', '1st', 1, 2, '4th Year', 'CS 213'),
(501, 5, NULL, 'CS 411', 'CS Thesis Writing 2', '1st', 1, 2, '4th Year', 'CS 321'),
(502, 5, NULL, 'CS 412', 'Human Computer Interaction', '1st', 0, 1, '4th Year', 'CS 122'),
(503, 5, NULL, 'CS 421', 'Internship/Ojt/Practicum(486 Hours)', '2nd', 0, 9, '4th Year', '4th Year Standing'),
(504, 10, NULL, 'DIT 404', 'Advanced Data Mining and Warehousing', '2nd', 1, 2, '1st Year', 'None'),
(505, 10, NULL, 'DIT 401', 'Advanced Software Engineering', '1st', 1, 2, '1st Year', 'None'),
(506, 10, NULL, 'DIT 402', 'Advanced IT Protection and Security', '1st', 1, 2, '1st Year', 'none'),
(507, 10, NULL, 'DIT 403', 'Advanced Operating System and Networking', '1st', 1, 2, '1st Year', 'none'),
(508, 10, NULL, 'DIT 405', 'IT Project Management and Software Quality Assurance', '2nd', 1, 2, '1st Year', 'none'),
(509, 10, NULL, 'DIT 406', 'Industry Immersions', 'Summer/MidYear', 1, 2, '1st Year', 'None'),
(510, 10, NULL, 'DIT 501', 'Dissertation Writing 1 (Proposal Defense)', '1st', 1, 2, '2nd Year', 'none'),
(511, 10, NULL, 'DIT 502', 'Dissertation Writing 2 (Local/National Refereed Paper Presentation)', '2nd', 1, 2, '2nd Year', 'none'),
(512, 10, NULL, 'DIT 503', 'Dissertation Writing 3 (International Refereed Paper Presentation)', '1st', 1, 2, '3rd Year', 'none'),
(513, 10, NULL, 'DIT 504', 'Dissertation Writing 4 (Final Defense)', '2nd', 1, 2, '3rd Year', 'none'),
(514, 11, NULL, 'MIT 201', 'Advanced Operating System and Networking', '1st', 1, 2, '1st Year', 'None'),
(515, 11, NULL, 'MIT 202', 'Advanced Organization of Databases', '1st', 1, 2, '1st Year', 'None'),
(516, 11, NULL, 'MIT 203', 'Methods of Research in IT', '1st', 1, 2, '1st Year', 'None'),
(517, 11, NULL, 'MIT 211', 'Advanced Software Engineering/Enterprise Architecture development', '1st', 0, 0, '1st Year', 'None'),
(518, 11, NULL, 'MIT 204', 'Advanced System Design and Implementation', '2nd', 1, 2, '1st Year', 'Pre Requisite'),
(519, 11, NULL, 'MIT 212', 'Advanced Programming', '2nd', 0, 3, '1st Year', 'Pre Requisite'),
(520, 11, NULL, 'MIT 213', 'Advanced Multimedia Systems', '2nd', 1, 2, '1st Year', 'Pre Requisite'),
(521, 11, NULL, 'Subject 1', 'Specialization Track (Subject 1)', '2nd', 1, 3, '1st Year', 'None'),
(522, 11, NULL, 'MIT 205', 'Technology and Project Management', 'Summer/MidYear', 1, 2, '1st Year', 'Pre Requisite'),
(523, 11, NULL, 'MIT 214', 'Advanced Statistics', 'Summer/MidYear', 1, 2, '1st Year', 'Pre Requisite'),
(524, 11, NULL, 'Examination', 'Comprehensive Examination', 'Summer/MidYear', 0, 0, '1st Year', 'None'),
(525, 11, NULL, 'Thesis 1', 'Thesis 1 (Presentation in National or International Forum)', '1st', 1, 2, '2nd Year', 'Passed the Comprehensive Exam'),
(526, 11, NULL, 'Subject 2', 'Specialization Track (Subject 2)', '1st', 0, 6, '2nd Year', '2nd Year Regular'),
(527, 11, NULL, 'Thesis 2', 'Thesis 2 (Final Defense)', '2nd', 1, 2, '2nd Year', 'Pre Requisite'),
(528, 11, NULL, 'Net Ad 1', 'Network System Administration/ Network Administration and Security', '2nd', 0, 3, '2nd Year', ''),
(529, 11, NULL, 'Net Ad 2', 'Wireless Network Administration', '2nd', 0, 3, '2nd Year', 'None'),
(530, 11, NULL, 'Net Ad 3', 'Mobile Technology', '2nd', 0, 3, '2nd Year', 'None'),
(531, 11, NULL, 'Database Ad 1', 'Data Warehouse Technology and Implementation Strategies', '2nd', 0, 3, '2nd Year', 'None'),
(532, 11, NULL, 'Database Ad 2', 'Database Administration', '2nd', 0, 3, '2nd Year', 'None'),
(533, 11, NULL, 'Database Ad 3', 'Client/Server Application Design', '2nd', 0, 3, '2nd Year', 'None'),
(534, 11, NULL, 'Data Science 1', 'Data Mining and Data Warehousing', '2nd', 0, 3, '2nd Year', 'None'),
(535, 11, NULL, 'Data Science 2', 'Business Analytics', '2nd', 0, 3, '2nd Year', 'None'),
(536, 11, NULL, 'Data Science 3', 'Data Science with R', '2nd', 0, 3, '2nd Year', 'None'),
(537, 12, NULL, 'DSA 111', 'Foundation of Data Science and Analytics', '1st', 1, 2, '1st Year', 'None'),
(538, 12, NULL, 'DSA 112', 'Statistics for Data Science', '1st', 1, 2, '1st Year', 'None');
INSERT INTO `subject` (`id`, `curriculum_id`, `track_id`, `subject_code`, `subject_description`, `semester`, `lab`, `lec`, `year`, `pre_requisite`) VALUES
(539, 12, NULL, 'DSA 113', 'Data Mining Techniques', '1st', 1, 2, '1st Year', 'None'),
(540, 12, NULL, 'DSA 114', 'Enterprise Data Governance', '2nd', 1, 2, '1st Year', 'None'),
(541, 12, NULL, 'DSA 115', 'Technology Project Management', '2nd', 1, 2, '1st Year', 'None'),
(542, 12, NULL, 'DSA 116', 'Machine Learning', '2nd', 1, 2, '1st Year', 'None'),
(543, 12, NULL, 'DSA 501', 'Capstone Project', 'Summer/MidYear', 1, 2, '2nd Year', 'None');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `approval`
--
ALTER TABLE `approval`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `curriculum`
--
ALTER TABLE `curriculum`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `faculty`
--
ALTER TABLE `faculty`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `room`
--
ALTER TABLE `room`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `schedule`
--
ALTER TABLE `schedule`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `school_year`
--
ALTER TABLE `school_year`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `section`
--
ALTER TABLE `section`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `student`
--
ALTER TABLE `student`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `subject`
--
ALTER TABLE `subject`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `approval`
--
ALTER TABLE `approval`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `curriculum`
--
ALTER TABLE `curriculum`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `faculty`
--
ALTER TABLE `faculty`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT for table `room`
--
ALTER TABLE `room`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `schedule`
--
ALTER TABLE `schedule`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `school_year`
--
ALTER TABLE `school_year`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `section`
--
ALTER TABLE `section`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
--
-- AUTO_INCREMENT for table `student`
--
ALTER TABLE `student`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `subject`
--
ALTER TABLE `subject`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=544;
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 */;