populate.sql

use timetablemanager;

INSERT INTO admin (username, password, role) VALUES
('admin123', '123', 'admin'),
('admin1', 'admin1', 'admin'),
('admin2', 'admin2', 'admin'),
('Teacher1', 'Teacher1', 'teacher'),
('Teacher2', 'Teacher3', 'teacher'),
('HOD1', 'HOD1', 'HOD');

INSERT INTO Subject (subjectcode, subjectname, semester) VALUES
('UE21CS341A', 'Software Engineering',5),
('UE21CS351A', 'DBMS',5),
('UE21CS352A', 'Machine Intelligence',5),
('UE21CS342A', 'Data Analytics',5),
('UE21CS343A', 'Graph theory',5);

INSERT INTO TEACHER values
('INSTRUCTOR1', 'INSTRUCTOR1', 'CS', 'INSTRUCTOR1@gmail.com'),
('INSTRUCTOR2', 'INSTRUCTOR2', 'CS', 'INSTRUCTOR2@gmail.com'),
('INSTRUCTOR3', 'INSTRUCTOR3', 'CS', 'INSTRUCTOR3@gmail.com'),
('INSTRUCTOR4', 'INSTRUCTOR4', 'CS', 'INSTRUCTOR4@gmail.com'),
('INSTRUCTOR5', 'INSTRUCTOR5', 'CS', 'INSTRUCTOR5@gmail.com'),
('INSTRUCTOR6', 'INSTRUCTOR6', 'CS', 'INSTRUCTOR6@gmail.com'),
('INSTRUCTOR7', 'INSTRUCTOR7', 'CS', 'INSTRUCTOR7@gmail.com');

INSERT INTO Batch values
("5A"),
("5B"),
("5C"),
("5D"),
("5E"),
("5F");

INSERT INTO Teaches (teacherid, subjectcode, batchid) VALUES
('INSTRUCTOR1', 'UE21CS351A', '5A'),
('INSTRUCTOR1', 'UE21CS351A', '5B'),
('INSTRUCTOR2', 'UE21CS351A', '5C'),
('INSTRUCTOR3', 'UE21CS351A', '5D'),
('INSTRUCTOR4', 'UE21CS351A', '5E');

INSERT INTO Teaches (teacherid, subjectcode, batchid) VALUES
('INSTRUCTOR5', 'UE21CS342A', '5A'),
('INSTRUCTOR4', 'UE21CS342A', '5B'),
('INSTRUCTOR3', 'UE21CS342A', '5C'),
('INSTRUCTOR6', 'UE21CS342A', '5D'),
('INSTRUCTOR2', 'UE21CS342A', '5E');

INSERT INTO Teaches (teacherid, subjectcode, batchid) VALUES
('INSTRUCTOR2', 'UE21CS343A', '5A'),
('INSTRUCTOR1', 'UE21CS343A', '5B'),
('INSTRUCTOR5', 'UE21CS343A', '5C'),
('INSTRUCTOR3', 'UE21CS343A', '5D'),
('INSTRUCTOR2', 'UE21CS343A', '5E');

INSERT INTO Teaches (teacherid, subjectcode, batchid) VALUES
('INSTRUCTOR4', 'UE21CS352A', '5A'),
('INSTRUCTOR3', 'UE21CS352A', '5B'),
('INSTRUCTOR2', 'UE21CS352A', '5C'),
('INSTRUCTOR6', 'UE21CS352A', '5D'),
('INSTRUCTOR1', 'UE21CS352A', '5E');

INSERT INTO Teaches (teacherid, subjectcode, batchid) VALUES
('INSTRUCTOR2', 'UE21CS341A', '5A'),
('INSTRUCTOR1', 'UE21CS341A', '5B'),
('INSTRUCTOR3', 'UE21CS341A', '5C'),
('INSTRUCTOR5', 'UE21CS341A', '5D'),
('INSTRUCTOR4', 'UE21CS341A', '5E');

INSERT INTO Classroom (room_id, capacity) VALUES
('G01', 45),
('G02', 45),
('G03', 45),
('G04', 45),
('G05', 45);

INSERT INTO Timeslot (slot_id, room_id, batch_id, subjectcode, day, starttime, endtime) VALUES
(1, 'G01', '5A', 'UE21CS341A', 'Monday', '08:00:00', '09:30:00'),
(2, 'G01', '5A', 'UE21CS343A', 'Monday', '10:00:00', '11:30:00'),
(3, 'G01', '5A', 'UE21CS351A', 'Monday', '12:30:00', '14:00:00'),
(4, 'G01', '5A', 'UE21CS352A', 'Monday', '14:30:00', '16:00:00'),
(5, 'G01', '5A', 'UE21CS343A', 'Tuesday', '08:00:00', '09:30:00'),
(6, 'G01', '5A', 'UE21CS351A', 'Tuesday', '10:00:00', '11:30:00'),
(7, 'G01', '5A', 'UE21CS341A', 'Tuesday', '12:30:00', '14:00:00'),
(8, 'G01', '5A', 'UE21CS352A', 'Tuesday', '14:30:00', '16:00:00'),
(9, 'G01', '5A', 'UE21CS343A', 'Wednesday', '08:00:00', '09:30:00'),
(10, 'G01', '5A', 'UE21CS351A', 'Wednesday', '10:00:00', '11:30:00'),
(11, 'G01', '5A', 'UE21CS352A', 'Wednesday', '12:30:00', '14:00:00'),
(12, 'G01', '5A', 'UE21CS342A', 'Wednesday', '14:30:00', '16:00:00'),
(13, 'G01', '5A', 'UE21CS341A', 'Thursday', '08:00:00', '09:30:00'),
(14, 'G01', '5A', 'UE21CS351A', 'Thursday', '10:00:00', '11:30:00'),
(15, 'G01', '5A', 'UE21CS342A', 'Thursday', '12:30:00', '14:00:00'),
(16, 'G01', '5A', 'UE21CS352A', 'Thursday', '14:30:00', '16:00:00'),
(17, 'G01', '5A', 'UE21CS351A', 'Friday', '08:00:00', '09:30:00'),
(18, 'G01', '5A', 'UE21CS341A', 'Friday', '10:00:00', '11:30:00'),
(19, 'G01', '5A', 'UE21CS352A', 'Friday', '12:30:00', '14:00:00'),
(20, 'G01', '5A', 'UE21CS342A', 'Friday', '14:30:00', '16:00:00');

INSERT INTO Timeslot (slot_id, room_id, batch_id, subjectcode, day, starttime, endtime) VALUES
(1, 'G02', '5B', 'UE21CS342A', 'Monday', '08:00:00', '09:30:00'),
(2, 'G02', '5B', 'UE21CS341A', 'Monday', '10:00:00', '11:30:00'),
(3, 'G02', '5B', 'UE21CS352A', 'Monday', '12:30:00', '14:00:00'),
(4, 'G02', '5B', 'UE21CS351A', 'Monday', '14:30:00', '16:00:00'),
(5, 'G02', '5B', 'UE21CS341A', 'Tuesday', '08:00:00', '09:30:00'),
(6, 'G02', '5B', 'UE21CS352A', 'Tuesday', '10:00:00', '11:30:00'),
(7, 'G02', '5B', 'UE21CS342A', 'Tuesday', '12:30:00', '14:00:00'),
(8, 'G02', '5B', 'UE21CS351A', 'Tuesday', '14:30:00', '16:00:00'),
(9, 'G02', '5B', 'UE21CS341A', 'Wednesday', '08:00:00', '09:30:00'),
(10, 'G02', '5B', 'UE21CS352A', 'Wednesday', '10:00:00', '11:30:00'),
(11, 'G02', '5B', 'UE21CS351A', 'Wednesday', '12:30:00', '14:00:00'),
(12, 'G02', '5B', 'UE21CS343A', 'Wednesday', '14:30:00', '16:00:00'),
(13, 'G02', '5B', 'UE21CS342A', 'Thursday', '08:00:00', '09:30:00'),
(14, 'G02', '5B', 'UE21CS352A', 'Thursday', '10:00:00', '11:30:00'),
(15, 'G02', '5B', 'UE21CS343A', 'Thursday', '12:30:00', '14:00:00'),
(16, 'G02', '5B', 'UE21CS351A', 'Thursday', '14:30:00', '16:00:00'),
(17, 'G02', '5B', 'UE21CS352A', 'Friday', '08:00:00', '09:30:00'),
(18, 'G02', '5B', 'UE21CS342A', 'Friday', '10:00:00', '11:30:00'),
(19, 'G02', '5B', 'UE21CS351A', 'Friday', '12:30:00', '14:00:00'),
(20, 'G02', '5B', 'UE21CS343A', 'Friday', '14:30:00', '16:00:00');


INSERT INTO UpdatedTables (slot_id, room_id, batch_id, subjectcode, day, starttime, endtime) VALUES
(1, 'G01', '5A', 'UE21CS341A', 'Monday', '08:00:00', '09:30:00'),
(2, 'G01', '5A', 'UE21CS343A', 'Monday', '10:00:00', '11:30:00'),
(3, 'G01', '5A', 'UE21CS351A', 'Monday', '12:30:00', '14:00:00'),
(4, 'G01', '5A', 'UE21CS352A', 'Monday', '14:30:00', '16:00:00'),
(5, 'G01', '5A', 'UE21CS343A', 'Tuesday', '08:00:00', '09:30:00'),
(6, 'G01', '5A', 'UE21CS351A', 'Tuesday', '10:00:00', '11:30:00'),
(7, 'G01', '5A', 'UE21CS341A', 'Tuesday', '12:30:00', '14:00:00'),
(8, 'G01', '5A', 'UE21CS352A', 'Tuesday', '14:30:00', '16:00:00'),
(9, 'G01', '5A', 'UE21CS343A', 'Wednesday', '08:00:00', '09:30:00'),
(10, 'G01', '5A', 'UE21CS351A', 'Wednesday', '10:00:00', '11:30:00'),
(11, 'G01', '5A', 'UE21CS352A', 'Wednesday', '12:30:00', '14:00:00'),
(12, 'G01', '5A', 'UE21CS342A', 'Wednesday', '14:30:00', '16:00:00'),
(13, 'G01', '5A', 'UE21CS341A', 'Thursday', '08:00:00', '09:30:00'),
(14, 'G01', '5A', 'UE21CS351A', 'Thursday', '10:00:00', '11:30:00'),
(15, 'G01', '5A', 'UE21CS342A', 'Thursday', '12:30:00', '14:00:00'),
(16, 'G01', '5A', 'UE21CS352A', 'Thursday', '14:30:00', '16:00:00'),
(17, 'G01', '5A', 'UE21CS351A', 'Friday', '08:00:00', '09:30:00'),
(18, 'G01', '5A', 'UE21CS341A', 'Friday', '10:00:00', '11:30:00'),
(19, 'G01', '5A', 'UE21CS352A', 'Friday', '12:30:00', '14:00:00'),
(20, 'G01', '5A', 'UE21CS342A', 'Friday', '14:30:00', '16:00:00');

INSERT INTO UpdatedTables (slot_id, room_id, batch_id, subjectcode, day, starttime, endtime) VALUES
(1, 'G02', '5B', 'UE21CS342A', 'Monday', '08:00:00', '09:30:00'),
(2, 'G02', '5B', 'UE21CS341A', 'Monday', '10:00:00', '11:30:00'),
(3, 'G02', '5B', 'UE21CS352A', 'Monday', '12:30:00', '14:00:00'),
(4, 'G02', '5B', 'UE21CS351A', 'Monday', '14:30:00', '16:00:00'),
(5, 'G02', '5B', 'UE21CS341A', 'Tuesday', '08:00:00', '09:30:00'),
(6, 'G02', '5B', 'UE21CS352A', 'Tuesday', '10:00:00', '11:30:00'),
(7, 'G02', '5B', 'UE21CS342A', 'Tuesday', '12:30:00', '14:00:00'),
(8, 'G02', '5B', 'UE21CS351A', 'Tuesday', '14:30:00', '16:00:00'),
(9, 'G02', '5B', 'UE21CS341A', 'Wednesday', '08:00:00', '09:30:00'),
(10, 'G02', '5B', 'UE21CS352A', 'Wednesday', '10:00:00', '11:30:00'),
(11, 'G02', '5B', 'UE21CS351A', 'Wednesday', '12:30:00', '14:00:00'),
(12, 'G02', '5B', 'UE21CS343A', 'Wednesday', '14:30:00', '16:00:00'),
(13, 'G02', '5B', 'UE21CS342A', 'Thursday', '08:00:00', '09:30:00'),
(14, 'G02', '5B', 'UE21CS352A', 'Thursday', '10:00:00', '11:30:00'),
(15, 'G02', '5B', 'UE21CS343A', 'Thursday', '12:30:00', '14:00:00'),
(16, 'G02', '5B', 'UE21CS351A', 'Thursday', '14:30:00', '16:00:00'),
(17, 'G02', '5B', 'UE21CS352A', 'Friday', '08:00:00', '09:30:00'),
(18, 'G02', '5B', 'UE21CS342A', 'Friday', '10:00:00', '11:30:00'),
(19, 'G02', '5B', 'UE21CS351A', 'Friday', '12:30:00', '14:00:00'),
(20, 'G02', '5B', 'UE21CS343A', 'Friday', '14:30:00', '16:00:00');



INSERT INTO Student values
("PES1UG21CS001","AAASAI PRASAD",5,'A',"5A"),
("PES1UG21CS002","ASKHE BALAN",5,'A',"5A"),
("PES1UG21CS003","AVSAL SETTY",5,'A',"5A"),
("PES1UG21CS004","ANTIN",5,'A',"5A"),
("PES1UG21CS005","ADTYA H RAO",5,'A',"5A"),
("PES1UG21CS006","ADTA NARAYAN",5,'A',"5A"),
("PES1UG21CS007","AKS V",5,'A',"5A"),
("PES1UG21CS008","AAT KASHYAP",5,'A',"5A"),
("PES1UG21CS009","ARA HEMANT BADYAL",5,'A',"5A"),
("PES1UG21CS010","ARA SHETTY",5,'A',"5A"),
("PES1UG21CS011","ASIH SHARMA ",5,'A',"5A"),
("PES1UG21CS012","AVS GILBERT J",5,'A',"5A"),
("PES1UG21CS013","AYS MISHRA",5,'A',"5A"),
("PES1UG21CS014","AYS NAGAR",5,'A',"5A"),
("PES1UG21CS015","AYS SENAPATI",5,'A',"5A"),
("PES1UG21CS016","AHYNARASINHA JOSHI",5,'A',"5A"),
("PES1UG21CS017","AHYRANGA HAMPAPUR",5,'A',"5A"),
("PES1UG21CS018","AHGYA KOTHA",5,'A',"5A"),
("PES1UG21CS019","AHJET M BALOJI",5,'A',"5A"),
("PES1UG21CS020","AHNV R BHARADWAJ",5,'A',"5A"),
("PES1UG21CS021","AHNVA RAM N",5,'A',"5A"),
("PES1UG21CS022","AHRJ",5,'A',"5A"),
("PES1UG21CS023","AHRM PRASANNA",5,'A',"5A"),
("PES1UG21CS024","AHRM.H.A",5,'A',"5A"),
("PES1UG21CS025","AHSEK",5,'A',"5A"),
("PES1UG21CS026","AHSEK SHRINIVAS VADAVADAGI",5,'A',"5A"),
("PES1UG21CS027","AHL NAYAK",5,'A',"5A"),
("PES1UG21CS028","AHNYA KRISHNA",5,'A',"5A"),
("PES1UG21CS029","AHS DHEERAJ ",5,'A',"5A"),
("PES1UG21CS030","AIH S MURTHY",5,'A',"5A"),
("PES1UG21CS031","AIHA GANESH",5,'A',"5A"),
("PES1UG21CS032","AIHA MAHESH",5,'A',"5A"),
("PES1UG21CS033","AIHA S KOLAVI",5,'A',"5A"),
("PES1UG21CS034","AIHA SHARMA C A",5,'A',"5A"),
("PES1UG21CS035","AIHA TG",5,'A',"5A"),
("PES1UG21CS036","AIHA.B",5,'A',"5A"),
("PES1UG21CS037","AIIGOYAL",5,'A',"5A"),
("PES1UG21CS038","AIIMALLYA",5,'A',"5A"),
("PES1UG21CS039","AIIPRABHU A",5,'A',"5A"),
("PES1UG21CS040","AIY ANANT MANGALGI",5,'A',"5A"),
("PES1UG21CS041","AIY ARAKERE",5,'B',"5B"),
("PES1UG21CS042","AIY CHAUBEY",5,'B',"5B"),
("PES1UG21CS043","AIY D VENKATESH PRASANNA",5,'B',"5B"),
("PES1UG21CS044","AIY KAMSHETTY ",5,'B',"5B"),
("PES1UG21CS045","AIY RAO",5,'B',"5B"),
("PES1UG21CS046","AIY VIKRAM SINGH",5,'B',"5B"),
("PES1UG21CS047","ARJ BANERJEE",5,'B',"5B"),
("PES1UG21CS048","AVYAGRAWAL",5,'B',"5B"),
("PES1UG21CS049","AVK VARSHA NAIK",5,'B',"5B"),
("PES1UG21CS050","ANLELIZABETH",5,'B',"5B"),
("PES1UG21CS051","ASWRYA L PATIL",5,'B',"5B"),
("PES1UG21CS052","AE HAT",5,'B',"5B"),
("PES1UG21CS053","AAKHA PRABHANNA MULGUND",5,'B',"5B"),
("PES1UG21CS054","AAKHA SENDHIL",5,'B',"5B"),
("PES1UG21CS055","AAHKAMALESH",5,'B',"5B"),
("PES1UG21CS056","AAHSHIDDANAGOUDAR",5,'B',"5B"),
("PES1UG21CS057","AAHVIJAYAKUMAR ANGADI",5,'B',"5B"),
("PES1UG21CS058","AHLSH M K",5,'B',"5B"),
("PES1UG21CS059","ASA S",5,'B',"5B"),
("PES1UG21CS060","ASAA LAXMAN PAWAR",5,'B',"5B"),
("PES1UG21CS061","ASAHA M K",5,'B',"5B"),
("PES1UG21CS062","ASAHA P",5,'B',"5B"),
("PES1UG21CS063","ASA ANAND",5,'B',"5B"),
("PES1UG21CS064","ASA PRASAD HONNAVALLI",5,'B',"5B"),
("PES1UG21CS065","ABT REVANTH SREERAM",5,'B',"5B"),
("PES1UG21CS066","GNAU ",5,'B',"5B"),
("PES1UG21CS067","AGEHIKA CHOWDARY",5,'B',"5B"),
("PES1UG21CS068","ABSGAR YADAV ",5,'B',"5B"),
("PES1UG21CS069","Nsh Singh",5,'B',"5B"),
("PES1UG21CS070","AIY KORISHETTY",5,'B',"5B"),
("PES1UG21CS071","RCAPA",5,'B',"5B"),
("PES1UG21CS072","AAAI NAGA VENKATA CHARAN",5,'B',"5B"),
("PES1UG21CS073","ASO RICHARD ARANHA",5,'B',"5B"),
("PES1UG21CS074","AANFEROZ",5,'B',"5B"),
("PES1UG21CS075","AAASAI ANITEJ",5,'B',"5B"),
("PES1UG21CS076","AIHGUPTA",5,'B',"5B"),
("PES1UG21CS077","AOHBHARNE",5,'B',"5B"),
("PES1UG21CS078","ARTA G K",5,'B',"5B"),
("PES1UG21CS079","AUY MARALI",5,'B',"5B"),
("PES1UG21CS080","AAH SIDDHESHWAR",5,'B',"5B"),
("PES1UG21CS081","AAY J",5,'C',"5C"),
("PES1UG21CS082","AAY JHA",5,'C',"5C"),
("PES1UG21CS083","AAY MAHISHI",5,'C',"5C"),
("PES1UG21CS084","AAY PRASAD B",5,'C',"5C"),
("PES1UG21CS085","AES K B",5,'C',"5C"),
("PES1UG21CS086","AIEH MADHUGIRI",5,'C',"5C"),
("PES1UG21CS087","AIEHANA A M",5,'C',"5C"),
("PES1UG21CS088","AIA KUMAR",5,'C',"5C"),
("PES1UG21CS089","AIEH BHAIJI",5,'C',"5C"),
("PES1UG21CS090","AIUH G JOSHI",5,'C',"5C"),
("PES1UG21CS091","AIUH LAKHOTIA",5,'C',"5C"),
("PES1UG21CS092","AIUH REVANUR",5,'C',"5C"),
("PES1UG21CS093","AJNR PRASAD",5,'C',"5C"),
("PES1UG21CS094","AKRDDY SAI SANDEEP REDDY",5,'C',"5C"),
("PES1UG21CS095","AKTA. A",5,'C',"5C"),
("PES1UG21CS096","AKS H V",5,'C',"5C"),
("PES1UG21CS097","AOS DAMODAR",5,'C',"5C"),
("PES1UG21CS098","AOSKA VEMIREDDY",5,'C',"5C"),
("PES1UG21CS099","ASU DASYAM",5,'C',"5C"),
("PES1UG21CS100","ASU RAMDAS BALIGA",5,'C',"5C"),
("PES1UG21CS101","ASU RANJAN",5,'C',"5C"),
("PES1UG21CS102","AU RAKASH BACCHE",5,'C',"5C"),
("PES1UG21CS103","AUY N",5,'C',"5C"),
("PES1UG21CS104","AKTA A C",5,'C',"5C"),
("PES1UG21CS105","ASARAHBAR",5,'C',"5C"),
("PES1UG21CS106","AUAA KAMATH",5,'C',"5C"),
("PES1UG21CS107","AUA BASAVARAJ BHUSARE",5,'C',"5C"),
("PES1UG21CS108","AUA N KOPPAL",5,'C',"5C"),
("PES1UG21CS109","AUH M V",5,'C',"5C"),
("PES1UG21CS110","AUHA GHEI",5,'C',"5C"),
("PES1UG21CS111","AVSA NAYAK",5,'C',"5C"),
("PES1UG21CS112","AORA RAJ",5,'C',"5C"),
("PES1UG21CS113","AAHNA MAHATI",5,'C',"5C"),
("PES1UG21CS114","ACIHMAN VB",5,'C',"5C"),
("PES1UG21CS115","ANBKARMAKAR",5,'C',"5C"),
("PES1UG21CS116","ANVSRINIVAS ATREY",5,'C',"5C"),
("PES1UG21CS117","APTAGARWAL",5,'C',"5C"),
("PES1UG21CS118","ASY KHURANA",5,'C',"5C"),
("PES1UG21CS119","AU MAR KURALI",5,'C',"5C"),
("PES1UG21CS120","AVNARUN NOOLI",5,'C',"5C"),
("PES1UG21CS121","AY INAYAK R",5,'D',"5D"),
("PES1UG21CS122","AYMN S JAIN",5,'D',"5D"),
("PES1UG21CS123","AYNGUPTA",5,'D',"5D"),
("PES1UG21CS124","AYNSHARMA",5,'D',"5D"),
("PES1UG21CS125","AYNH KHICHAR ",5,'D',"5D"),
("PES1UG21CS126","AHYNAIK",5,'D',"5D"),
("PES1UG21CS127","AHI FURTADO",5,'D',"5D"),
("PES1UG21CS128","AHI BHARADWAJ",5,'D',"5D"),
("PES1UG21CS129","AHI BHAT",5,'D',"5D"),
("PES1UG21CS130","AHI SHARMA",5,'D',"5D"),
("PES1UG21CS131","AHI RAGUPATHY",5,'D',"5D"),
("PES1UG21CS132","AHII VENKATARAMAN HEGDE",5,'D',"5D"),
("PES1UG21CS133","AYNKUMAR",5,'D',"5D"),
("PES1UG21CS134","Rciha V S",5,'D',"5D"),
("PES1UG21CS135","ARTA S",5,'D',"5D"),
("PES1UG21CS136","AUHEE M SULIBHAVI",5,'D',"5D"),
("PES1UG21CS137","AEISAHITH REDDY",5,'D',"5D"),
("PES1UG21CS138","AUHSHANDILYA",5,'D',"5D"),
("PES1UG21CS139","CAD NAIK",5,'D',"5D"),
("PES1UG21CS140","DRHN KRISHNA HEGDE",5,'D',"5D"),
("PES1UG21CS141","AHLRAIMON",5,'D',"5D"),
("PES1UG21CS142","AL RIVATSAV",5,'D',"5D"),
("PES1UG21CS143","AAIH SHENOY",5,'D',"5D"),
("PES1UG21CS144","AUHSINHA",5,'D',"5D"),
("PES1UG21CS145","BMNSH MOGER",5,'D',"5D"),
("PES1UG21CS146","BSPANAV SRIKAR",5,'D',"5D"),
("PES1UG21CS147","BLKISHNA DICHITHA",5,'D',"5D"),
("PES1UG21CS148","BSVRAJ NARAYANAPPA HARAVI",5,'D',"5D"),
("PES1UG21CS149","BVGDDA JAGAN SAI",5,'D',"5D"),
("PES1UG21CS150","BNYSHRIYA E M",5,'D',"5D"),
("PES1UG21CS151","BAA",5,'D',"5D"),
("PES1UG21CS152","BAAH RAJA PK",5,'D',"5D"),
("PES1UG21CS153","BAAA BHIMASHANKAR HUGAR",5,'D',"5D"),
("PES1UG21CS154","BOM BHAT",5,'D',"5D"),
("PES1UG21CS155","BOMKA B K",5,'D',"5D"),
("PES1UG21CS156","BUA VIJAY KUMAR",5,'D',"5D"),
("PES1UG21CS157","BMIETTY BALA LAKSHMI DEEPTHI ",5,'D',"5D"),
("PES1UG21CS158","BNH SREENIVASA REDDY ",5,'D',"5D"),
("PES1UG21CS159","BUD L",5,'D',"5D"),
("PES1UG21CS160","CVNMRATA",5,'D',"5D"),
("PES1UG21CS161","CATA PAIDIKONDALA",5,'E',"5E"),
("PES1UG21CS162","CAD NIKHIL",5,'E',"5E"),
("PES1UG21CS163","CADN K H",5,'E',"5E"),
("PES1UG21CS164","CADNA",5,'E',"5E"),
("PES1UG21CS165","CADNA S M",5,'E',"5E"),
("PES1UG21CS166","CADACHUD SARATH",5,'E',"5E"),
("PES1UG21CS167","CAIHA K REDDY",5,'E',"5E"),
("PES1UG21CS168","CAUHA RAJEESH",5,'E',"5E"),
("PES1UG21CS169","CEA G MUNDASAD",5,'E',"5E"),
("PES1UG21CS170","CEA S",5,'E',"5E"),
("PES1UG21CS171","CEAA MITAL",5,'E',"5E"),
("PES1UG21CS172","CEHN R",5,'E',"5E"),
("PES1UG21CS173","CIA H",5,'E',"5E"),
("PES1UG21CS174","DRVMOHAN BHAT",5,'E',"5E"),
("PES1UG21CS175","GUV KALA",5,'E',"5E"),
("PES1UG21CS176","CIA HEGDE",5,'E',"5E"),
("PES1UG21CS177","CIATH TS",5,'E',"5E"),
("PES1UG21CS178","CITSH KUMAR KANIPAKAM",5,'E',"5E"),
("PES1UG21CS179","COGLE NEHA RAJKUMAR",5,'E',"5E"),
("PES1UG21CS180","CUCU RITHWIK SAI SURYA ",5,'E',"5E"),
("PES1UG21CS181","C BAY",5,'E',"5E"),
("PES1UG21CS182","DLRMESHWAR",5,'E',"5E"),
("PES1UG21CS183","DNS AHMED",5,'E',"5E"),
("PES1UG21CS184","DRHAGARWAL",5,'E',"5E"),
("PES1UG21CS185","DRHN BABU T R ",5,'E',"5E"),
("PES1UG21CS186","DRHN V",5,'E',"5E"),
("PES1UG21CS187","DESA KRISHNAPPA",5,'E',"5E"),
("PES1UG21CS188","DEA PARMAR",5,'E',"5E"),
("PES1UG21CS189","DVK MENON",5,'E',"5E"),
("PES1UG21CS190","DAUH KUMAR B",5,'E',"5E"),
("PES1UG21CS191","DAA SHETTY",5,'E',"5E"),
("PES1UG21CS192","DERJ MRUTYUNJAY HAVALE",5,'E',"5E"),
("PES1UG21CS193","DRT RAJESH KRISHNAN",5,'E',"5E"),
("PES1UG21CS194","DRVBALWANT SURTI",5,'E',"5E"),
("PES1UG21CS195","DRVPODUVAL",5,'E',"5E"),
("PES1UG21CS196","DRVPRASHANT NILKUND",5,'E',"5E"),
("PES1UG21CS197","DRVS MOMAYA",5,'E',"5E"),
("PES1UG21CS198","DRV S NAYAK",5,'E',"5E"),
("PES1UG21CS199","DGIAY SUNIL",5,'E',"5E"),
("PES1UG21CS200","DLPH",5,'E',"5E");