insertions.sql

-- USERS (Students)
INSERT INTO Users (FullName, Email, PasswordHash, Role, IsApproved) VALUES
('Ali Raza', '23I-1001@nu.edu.pk', 'password123', 'Student', 1),
('Zain Ali', '23I-1002@nu.edu.pk', 'password123', 'Student', 1),
('Qasim Naveed', '23I-1003@nu.edu.pk', 'password123', 'Student', 1),
('Haider Khan', '23I-1004@nu.edu.pk', 'password123', 'Student', 1),
('Noureen Iftikhar', '23I-1005@nu.edu.pk', 'password123', 'Student', 1),
('Balaj Khan', '23I-1006@nu.edu.pk', 'password123', 'Student', 1),
('ali mudasir', '23I-1007@nu.edu.pk', 'password123', 'Student', 1),
('Zeeshan Nasir', '23I-1008@nu.edu.pk', 'password123', 'Student', 1),
('Ali Rao', '23I-1009@nu.edu.pk', 'password123', 'Student', 1),
('Sanam Ali', '23I-1010@nu.edu.pk', 'password123', 'Student', 1);

INSERT INTO Users (FullName, Email, PasswordHash, Role, IsApproved) VALUES
('Sana Rauf', '23I-1011@nu.edu.pk', 'password123', 'Student', 1),
('Hamza Tariq', '23I-1012@nu.edu.pk', 'password123', 'Student', 1),
('Rimsha Khalid', '23I-1013@nu.edu.pk', 'password123', 'Student', 1),
('Saad Farooq', '23I-1014@nu.edu.pk', 'password123', 'Student', 1),
('Mehak Abbas', '23I-1015@nu.edu.pk', 'password123', 'Student', 1),
('Faisal Ameen', '23I-1016@nu.edu.pk', 'password123', 'Student', 1),
('Iqra Javed', '23I-1017@nu.edu.pk', 'password123', 'Student', 1),
('Hashim Zubair', '23I-1018@nu.edu.pk', 'password123', 'Student', 1),
('Laiba Saeed', '23I-1019@nu.edu.pk', 'password123', 'Student', 1),
('Taha Bilal', '23I-1020@nu.edu.pk', 'password123', 'Student', 1);

INSERT INTO Users (FullName, Email, PasswordHash, Role, IsApproved) VALUES
('Hiba Naveed', '23I-1021@nu.edu.pk', 'password123', 'Student', 1),
('Talha Rehman', '23I-1022@nu.edu.pk', 'password123', 'Student', 1),
('Muneeb Shah', '23I-1023@nu.edu.pk', 'password123', 'Student', 1),
('Rabia Khan', '23I-1024@nu.edu.pk', 'password123', 'Student', 1),
('Zara Akmal', '23I-1025@nu.edu.pk', 'password123', 'Student', 1),
('Usman Khalid', '23I-1026@nu.edu.pk', 'password123', 'Student', 1),
('Dua Shahid', '23I-1027@nu.edu.pk', 'password123', 'Student', 1),
('Asad Murtaza', '23I-1028@nu.edu.pk', 'password123', 'Student', 1),
('Minahil Noor', '23I-1029@nu.edu.pk', 'password123', 'Student', 1),
('Hassan Raza', '23I-1030@nu.edu.pk', 'password123', 'Student', 1);

INSERT INTO Users (FullName, Email, PasswordHash, Role, IsApproved) VALUES
('Sami Ullah', '23I-1031@nu.edu.pk', 'password123', 'Student', 1),
('Anaya Khalid', '23I-1032@nu.edu.pk', 'password123', 'Student', 1),
('Noman Zahid', '23I-1033@nu.edu.pk', 'password123', 'Student', 1),
('Ayesha Haroon', '23I-1034@nu.edu.pk', 'password123', 'Student', 1),
('Kashif Anwar', '23I-1035@nu.edu.pk', 'password123', 'Student', 1),
('Mahnoor Babar', '23I-1036@nu.edu.pk', 'password123', 'Student', 1),
('Zubair Shahzad', '23I-1037@nu.edu.pk', 'password123', 'Student', 1),
('Mehwish Riaz', '23I-1038@nu.edu.pk', 'password123', 'Student', 1),
('Arsalan Naveed', '23I-1039@nu.edu.pk', 'password123', 'Student', 1),
('Shiza Ahmed', '23I-1040@nu.edu.pk', 'password123', 'Student', 1);

INSERT INTO Users (FullName, Email, PasswordHash, Role, IsApproved) VALUES
('Aqsa Nadeem', '23I-1041@nu.edu.pk', 'password123', 'Student', 1),
('Rehan Malik', '23I-1042@nu.edu.pk', 'password123', 'Student', 1),
('Mariam Asif', '23I-1043@nu.edu.pk', 'password123', 'Student', 1),
('Jawad Ahsan', '23I-1044@nu.edu.pk', 'password123', 'Student', 1),
('Nashit Ali', '23I-1045@nu.edu.pk', 'password123', 'Student', 1),
('Tooba Irfan', '23I-1046@nu.edu.pk', 'password123', 'Student', 1),
('Zainab Haider', '23I-1047@nu.edu.pk', 'password123', 'Student', 1),
('Murtaza Shah', '23I-1048@nu.edu.pk', 'password123', 'Student', 1),
('Fariha Rehman', '23I-1049@nu.edu.pk', 'password123', 'Student', 1),
('Usama Siddique', '23I-1050@nu.edu.pk', 'password123', 'Student', 1);

INSERT INTO Users (FullName, Email, PasswordHash, Role, IsApproved) VALUES
('Hira Manzoor', '23I-1051@nu.edu.pk', 'password123', 'Student', 1),
('Faizan Arshad', '23I-1052@nu.edu.pk', 'password123', 'Student', 1),
('Arisha Fatima', '23I-1053@nu.edu.pk', 'password123', 'Student', 1),
('Sameer Khan', '23I-1054@nu.edu.pk', 'password123', 'Student', 1),
('Neha Qureshi', '23I-1055@nu.edu.pk', 'password123', 'Student', 1),
('Zayan Sheikh', '23I-1056@nu.edu.pk', 'password123', 'Student', 1),
('Abeer Hashmi', '23I-1057@nu.edu.pk', 'password123', 'Student', 1),
('Fahad Ali', '23I-1058@nu.edu.pk', 'password123', 'Student', 1),
('Iqra Noman', '23I-1059@nu.edu.pk', 'password123', 'Student', 1),
('Asma Rahim', '23I-1060@nu.edu.pk', 'password123', 'Student', 1);

INSERT INTO Users (FullName, Email, PasswordHash, Role, IsApproved) VALUES
('Muneeba Haris', '23I-1061@nu.edu.pk', 'password123', 'Student', 1),
('Zarar Ahmed', '23I-1062@nu.edu.pk', 'password123', 'Student', 1),
('Aqsa Shahbaz', '23I-1063@nu.edu.pk', 'password123', 'Student', 1),
('Shahzaib Rafiq', '23I-1064@nu.edu.pk', 'password123', 'Student', 1),
('Hania Saif', '23I-1065@nu.edu.pk', 'password123', 'Student', 1),
('Talal Noman', '23I-1066@nu.edu.pk', 'password123', 'Student', 1),
('Sundas Younis', '23I-1067@nu.edu.pk', 'password123', 'Student', 1),
('Rafay Qasim', '23I-1068@nu.edu.pk', 'password123', 'Student', 1),
('Anum Baig', '23I-1069@nu.edu.pk', 'password123', 'Student', 1),
('Yahya Zubair', '23I-1070@nu.edu.pk', 'password123', 'Student', 1);

INSERT INTO Users (FullName, Email, PasswordHash, Role, IsApproved) VALUES
('Shaheer Altaf', '23I-1071@nu.edu.pk', 'password123', 'Student', 1),
('Alina Nisar', '23I-1072@nu.edu.pk', 'password123', 'Student', 1),
('Mobeen Khalid', '23I-1073@nu.edu.pk', 'password123', 'Student', 1),
('Zoya Rehman', '23I-1074@nu.edu.pk', 'password123', 'Student', 1),
('Taimoor Iqbal', '23I-1075@nu.edu.pk', 'password123', 'Student', 1),
('Javeria Rizwan', '23I-1076@nu.edu.pk', 'password123', 'Student', 1),
('Shahrukh Nadeem', '23I-1077@nu.edu.pk', 'password123', 'Student', 1),
('Hafsa Tariq', '23I-1078@nu.edu.pk', 'password123', 'Student', 1),
('Yusra Naveed', '23I-1079@nu.edu.pk', 'password123', 'Student', 1),
('Hammad Riaz', '23I-1080@nu.edu.pk', 'password123', 'Student', 1);

-- STUDENTS
INSERT INTO Students (StudentID, UserID, FAST_ID, DegreeProgram, CurrentSemester, GPA) VALUES
(1, 1, '23I-1001', 'CS', 5, 3.21),
(2, 2, '23I-1002', 'SE', 4, 3.10),
(3, 3, '23I-1003', 'DS', 3, 2.85),
(4, 4, '23I-1004', 'AI', 6, 3.55),
(5, 5, '23I-1005', 'CS', 7, 3.09),
(6, 6, '23I-1006', 'SE', 2, 2.95),
(7, 7, '23I-1007', 'DS', 1, 3.65),
(8, 8, '23I-1008', 'AI', 8, 3.45),
(9, 9, '23I-1009', 'CS', 5, 3.75),
(10, 10, '23I-1010', 'SE', 6, 3.00);

INSERT INTO Students (StudentID, UserID, FAST_ID, DegreeProgram, CurrentSemester, GPA) VALUES
(11, 11, '23I-1011', 'DS', 2, 3.18),
(12, 12, '23I-1012', 'CS', 4, 3.34),
(13, 13, '23I-1013', 'SE', 6, 2.91),
(14, 14, '23I-1014', 'AI', 3, 3.44),
(15, 15, '23I-1015', 'CS', 5, 2.98),
(16, 16, '23I-1016', 'SE', 1, 3.61),
(17, 17, '23I-1017', 'DS', 7, 3.25),
(18, 18, '23I-1018', 'AI', 6, 3.08),
(19, 19, '23I-1019', 'SE', 2, 3.42),
(20, 20, '23I-1020', 'CS', 8, 3.11);

INSERT INTO Students (StudentID, UserID, FAST_ID, DegreeProgram, CurrentSemester, GPA) VALUES
(21, 21, '23I-1021', 'AI', 4, 3.36),
(22, 22, '23I-1022', 'CS', 5, 3.05),
(23, 23, '23I-1023', 'SE', 6, 2.89),
(24, 24, '23I-1024', 'DS', 3, 3.48),
(25, 25, '23I-1025', 'AI', 7, 3.22),
(26, 26, '23I-1026', 'SE', 2, 2.95),
(27, 27, '23I-1027', 'CS', 4, 3.67),
(28, 28, '23I-1028', 'DS', 1, 3.14),
(29, 29, '23I-1029', 'AI', 6, 3.32),
(30, 30, '23I-1030', 'SE', 5, 3.20);

INSERT INTO Students (StudentID, UserID, FAST_ID, DegreeProgram, CurrentSemester, GPA) VALUES
(31, 31, '23I-1031', 'DS', 4, 3.25),
(32, 32, '23I-1032', 'AI', 5, 3.40),
(33, 33, '23I-1033', 'CS', 6, 2.92),
(34, 34, '23I-1034', 'SE', 3, 3.50),
(35, 35, '23I-1035', 'DS', 7, 3.15),
(36, 36, '23I-1036', 'AI', 2, 2.97),
(37, 37, '23I-1037', 'CS', 8, 3.72),
(38, 38, '23I-1038', 'SE', 1, 3.33),
(39, 39, '23I-1039', 'AI', 5, 3.10),
(40, 40, '23I-1040', 'DS', 6, 3.21);

INSERT INTO Students (StudentID, UserID, FAST_ID, DegreeProgram, CurrentSemester, GPA) VALUES
(41, 41, '23I-1041', 'CS', 3, 3.18),
(42, 42, '23I-1042', 'SE', 4, 3.05),
(43, 43, '23I-1043', 'AI', 6, 3.42),
(44, 44, '23I-1044', 'DS', 5, 3.09),
(45, 45, '23I-1045', 'CS', 2, 3.66),
(46, 46, '23I-1046', 'SE', 7, 2.88),
(47, 47, '23I-1047', 'AI', 4, 3.33),
(48, 48, '23I-1048', 'DS', 1, 3.00),
(49, 49, '23I-1049', 'SE', 6, 3.47),
(50, 50, '23I-1050', 'CS', 5, 3.27);

INSERT INTO Students (StudentID, UserID, FAST_ID, DegreeProgram, CurrentSemester, GPA) VALUES
(51, 51, '23I-1051', 'DS', 3, 3.15),
(52, 52, '23I-1052', 'AI', 5, 3.34),
(53, 53, '23I-1053', 'SE', 2, 3.00),
(54, 54, '23I-1054', 'CS', 4, 3.41),
(55, 55, '23I-1055', 'AI', 6, 3.29),
(56, 56, '23I-1056', 'DS', 7, 2.91),
(57, 57, '23I-1057', 'CS', 8, 3.22),
(58, 58, '23I-1058', 'SE', 1, 3.51),
(59, 59, '23I-1059', 'AI', 6, 3.17),
(60, 60, '23I-1060', 'DS', 5, 3.11);

INSERT INTO Students (StudentID, UserID, FAST_ID, DegreeProgram, CurrentSemester, GPA) VALUES
(61, 61, '23I-1061', 'SE', 5, 3.20),
(62, 62, '23I-1062', 'AI', 4, 3.44),
(63, 63, '23I-1063', 'CS', 6, 2.95),
(64, 64, '23I-1064', 'DS', 3, 3.28),
(65, 65, '23I-1065', 'AI', 7, 3.09),
(66, 66, '23I-1066', 'SE', 1, 3.53),
(67, 67, '23I-1067', 'DS', 2, 3.35),
(68, 68, '23I-1068', 'CS', 5, 3.12),
(69, 69, '23I-1069', 'SE', 8, 3.60),
(70, 70, '23I-1070', 'AI', 6, 2.90);

INSERT INTO Students (StudentID, UserID, FAST_ID, DegreeProgram, CurrentSemester, GPA) VALUES
(71, 71, '23I-1071', 'CS', 2, 3.48),
(72, 72, '23I-1072', 'DS', 4, 3.00),
(73, 73, '23I-1073', 'SE', 6, 3.26),
(74, 74, '23I-1074', 'AI', 5, 2.99),
(75, 75, '23I-1075', 'CS', 3, 3.19),
(76, 76, '23I-1076', 'SE', 1, 3.70),
(77, 77, '23I-1077', 'AI', 7, 3.09),
(78, 78, '23I-1078', 'DS', 8, 3.30),
(79, 79, '23I-1079', 'CS', 6, 3.13),
(80, 80, '23I-1080', 'SE', 2, 3.37);

--Comapanies
INSERT INTO Companies (CompanyName, Sector, Website, Address) VALUES
('TechSpark Solutions', 'Software Development', 'www.techspark.com', 'Plot 12, Tech Park, Islamabad'),
('CodeCrafters Inc.', 'IT Services', 'www.codecrafters.com', 'Gulberg Greens, Islamabad'),
('NetBridge Systems', 'Networking & Security', 'www.netbridge.com', 'Blue Area, Islamabad'),
('FutureSoft Pvt Ltd.', 'AI & ML Solutions', 'www.futuresoft.ai', 'H-11, Islamabad'),
('QuickHire Pakistan', 'Recruitment & HR', 'www.quickhire.pk', 'Sector G-8, Islamabad'),
('ByteForge Technologies', 'Embedded Systems', 'www.byteforge.com', 'I-9 Industrial Area, Islamabad'),
('GreenStack Ltd.', 'Cloud Services', 'www.greenstack.com', 'Sector F-10, Islamabad'),
('EcomNova', 'E-commerce', 'www.ecomnova.pk', 'Giga Mall, DHA, Islamabad'),
('SoftVision Labs', 'IT Consultancy', 'www.softvisionlabs.com', 'F-6 Markaz, Islamabad'),
('Meditech Solutions', 'Healthcare IT', 'www.meditech.pk', 'Bahria Town, Rawalpindi'),
('AgroAI', 'Agritech & AI', 'www.agroai.com', 'Peshawar Road, Rawalpindi'),
('InnoWare Pvt Ltd.', 'Enterprise Software', 'www.innoware.com', 'Blue Area, Islamabad'),
('SkyNet Solutions', 'Cloud & DevOps', 'www.skynet.io', 'E-11 Markaz, Islamabad'),
('SmartBuild Tech', 'Construction Tech', 'www.smartbuild.com', 'Fazaia Colony, Islamabad'),
('PakLogix', 'Logistics & Transport', 'www.paklogix.pk', 'Chaklala Scheme III, Rawalpindi'),
('BrainX Corp.', 'AI Research', 'www.brainx.com', 'H-8, FAST Incubator, Islamabad'),
('WebNest Studios', 'Web Development', 'www.webnest.pk', 'Satellite Town, Rawalpindi'),
('CredenceSoft', 'Fintech', 'www.credencesoft.com', 'I-8 Markaz, Islamabad'),
('Digitech Arena', 'Digital Marketing', 'www.digitecharena.com', 'PWD, Islamabad'),
('NeoCyber Inc.', 'Cybersecurity', 'www.neocyber.com', 'G-13, Islamabad'),
('Nexware Pakistan', 'Software House', 'www.nexware.pk', 'Sector I-10, Islamabad');

--job fairs events
INSERT INTO JobFairEvents (Title, Description, Date, StartTime, EndTime, Venue) VALUES
('FAST Career Expo 2025', 'Annual career fair with top recruiters from tech and business sectors.', '2025-05-10', '10:00', '16:00', 'Main Auditorium, FAST Islamabad'),
('Tech Talent Hunt', 'Targeted fair for software and IT startups to hire interns and graduates.', '2025-05-15', '11:00', '15:00', 'Seminar Hall A, FAST Islamabad'),
('Women in Tech Job Fair', 'A special event to promote diversity and empower women in tech.', '2025-05-20', '09:30', '14:00', 'Hall B, CS Department'),
('AI & Data Science Connect', 'For companies hiring in AI, Data Science, and Analytics.', '2025-05-25', '10:00', '14:30', 'Event Hall, Academic Block'),
('Internship Drive 2025', 'Focused on internship placements for 2nd and 3rd year students.', '2025-06-01', '10:00', '13:30', 'FAST Lawn Pavilion');

--job postings
INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(1, 'Software Engineer Intern', 'Join our team to develop scalable software.', 'Internship', '20k-30k PKR', 'Java, SQL, Git', 'Lahore'),
(2, 'Data Analyst', 'Analyze datasets to derive business insights.', 'Full-time', '60k-80k PKR', 'Python, Excel, Power BI', 'Karachi'),
(3, 'Frontend Developer', 'Work on UI components for our web app.', 'Full-time', '70k-90k PKR', 'HTML, CSS, React', 'Islamabad'),
(4, 'Machine Learning Intern', 'Assist in building ML models.', 'Internship', '25k-35k PKR', 'Python, Scikit-learn, Pandas', 'Lahore'),
(5, 'DevOps Engineer', 'Automate deployments and manage CI/CD pipelines.', 'Full-time', '80k-100k PKR', 'Docker, Jenkins, AWS', 'Remote'),
(6, 'Mobile App Developer', 'Develop cross-platform mobile apps.', 'Full-time', '60k-85k PKR', 'Flutter, Dart, Firebase', 'Lahore'),
(7, 'Backend Developer Intern', 'Assist in API development and DB design.', 'Internship', '22k-32k PKR', 'Node.js, MongoDB, Express', 'Karachi'),
(8, 'AI Research Assistant', 'Support AI team in experimentation and documentation.', 'Internship', '25k-30k PKR', 'TensorFlow, Python, Jupyter', 'Islamabad'),
(9, 'QA Engineer', 'Conduct software testing and ensure quality.', 'Full-time', '50k-70k PKR', 'Selenium, TestNG, Jira', 'Lahore'),
(10, 'Cybersecurity Analyst', 'Monitor and analyze security threats.', 'Full-time', '90k-110k PKR', 'Wireshark, Nmap, Python', 'Karachi');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(2, 'Cloud Engineer', 'Manage and optimize our cloud infrastructure.', 'Full-time', '85k-110k PKR', 'AWS, Azure, Kubernetes', 'Islamabad'),
(5, 'Data Science Intern', 'Support the team with data preprocessing and visualization.', 'Internship', '20k-30k PKR', 'Python, Pandas, Matplotlib', 'Lahore'),
(4, 'UI/UX Designer', 'Design intuitive interfaces for web and mobile.', 'Full-time', '60k-90k PKR', 'Figma, Adobe XD, User Testing', 'Karachi'),
(1, 'Blockchain Developer', 'Work on decentralized applications.', 'Full-time', '100k-120k PKR', 'Solidity, Ethereum, Web3.js', 'Remote'),
(3, 'Technical Writer Intern', 'Write documentation and user guides.', 'Internship', '18k-25k PKR', 'Markdown, Git, English Proficiency', 'Islamabad'),
(6, 'Full Stack Developer', 'Build and maintain end-to-end web apps.', 'Full-time', '80k-100k PKR', 'React, Node.js, PostgreSQL', 'Lahore'),
(7, 'Game Developer Intern', 'Assist in developing interactive games.', 'Internship', '22k-28k PKR', 'Unity, C#, Blender', 'Karachi'),
(8, 'IT Support Specialist', 'Provide technical assistance to staff.', 'Full-time', '40k-60k PKR', 'Troubleshooting, Networking, Windows OS', 'Lahore'),
(10, 'AI Product Manager', 'Lead AI product development and strategy.', 'Full-time', '120k-150k PKR', 'Agile, Product Roadmaps, ML Concepts', 'Remote'),
(9, 'Cybersecurity Intern', 'Support risk assessments and audits.', 'Internship', '25k-30k PKR', 'Kali Linux, OWASP, Python', 'Islamabad');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Systems Analyst', 'Analyze and improve IT systems and workflows.', 'Full-time', '70k-90k PKR', 'UML, SQL, SDLC', 'Karachi'),
(6, 'AI Intern', 'Work with NLP and computer vision projects.', 'Internship', '22k-30k PKR', 'Python, OpenCV, NLTK', 'Lahore'),
(2, 'Network Engineer', 'Configure and maintain network infrastructure.', 'Full-time', '75k-100k PKR', 'Cisco, TCP/IP, Firewalls', 'Islamabad'),
(1, 'Web Developer Intern', 'Assist in building websites and landing pages.', 'Internship', '20k-28k PKR', 'HTML, CSS, JavaScript', 'Remote'),
(5, 'Product Designer', 'Design product flows and user experiences.', 'Full-time', '85k-105k PKR', 'Wireframing, Prototyping, UX Research', 'Lahore'),
(4, 'Software Tester Intern', 'Conduct manual and automated testing.', 'Internship', '18k-25k PKR', 'Postman, Selenium, Test Cases', 'Karachi'),
(8, 'Database Administrator', 'Manage and tune databases for performance.', 'Full-time', '90k-115k PKR', 'SQL Server, MySQL, Backup Strategies', 'Islamabad'),
(7, 'Cloud Intern', 'Assist with deployment and monitoring on cloud.', 'Internship', '20k-30k PKR', 'AWS, Terraform, GitHub Actions', 'Lahore'),
(10, 'Security Engineer', 'Design and implement security architecture.', 'Full-time', '100k-130k PKR', 'SIEM, IDS/IPS, Threat Modeling', 'Karachi'),
(9, 'DevRel Intern', 'Support developer engagement and content.', 'Internship', '22k-29k PKR', 'Public Speaking, Blogging, APIs', 'Remote');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(1, 'IT Project Manager', 'Coordinate and manage software development projects.', 'Full-time', '100k-130k PKR', 'Scrum, Jira, Communication Skills', 'Lahore'),
(3, 'Robotics Intern', 'Assist in developing automation systems.', 'Internship', '24k-30k PKR', 'Arduino, Python, ROS', 'Islamabad'),
(6, 'Content Strategist', 'Plan and oversee digital content initiatives.', 'Full-time', '70k-90k PKR', 'SEO, Content Writing, Analytics', 'Karachi'),
(5, 'Computer Vision Engineer', 'Develop image processing solutions.', 'Full-time', '95k-120k PKR', 'OpenCV, Deep Learning, Python', 'Lahore'),
(4, 'Business Intelligence Intern', 'Support BI dashboard development.', 'Internship', '20k-27k PKR', 'Power BI, SQL, Data Analysis', 'Islamabad'),
(7, 'Penetration Tester', 'Test and evaluate system vulnerabilities.', 'Full-time', '90k-115k PKR', 'Burp Suite, Kali Linux, Reporting', 'Remote'),
(2, 'Mobile App Intern', 'Help develop features for mobile apps.', 'Internship', '20k-26k PKR', 'Android Studio, Java/Kotlin', 'Lahore'),
(8, 'E-commerce Developer', 'Build and manage e-commerce platforms.', 'Full-time', '70k-100k PKR', 'Shopify, WooCommerce, PHP', 'Karachi'),
(10, 'Digital Marketing Intern', 'Assist in running online campaigns.', 'Internship', '18k-24k PKR', 'Facebook Ads, Google Analytics, Canva', 'Remote'),
(9, 'Backend Engineer', 'Develop secure and scalable server-side logic.', 'Full-time', '85k-110k PKR', 'Node.js, PostgreSQL, Docker', 'Lahore');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Game Designer', 'Design gameplay mechanics and user experiences.', 'Full-time', '75k-95k PKR', 'Unity, C#, Game Balancing', 'Karachi'),
(6, 'AR/VR Intern', 'Support the team in developing AR/VR prototypes.', 'Internship', '22k-30k PKR', 'Unity, Oculus SDK, C#', 'Islamabad'),
(1, 'Full Stack Intern', 'Assist in developing and testing full stack apps.', 'Internship', '20k-28k PKR', 'React, Node.js, SQL', 'Lahore'),
(4, 'Technical Support Engineer', 'Resolve technical issues for clients.', 'Full-time', '55k-70k PKR', 'Helpdesk, Troubleshooting, Communication', 'Karachi'),
(2, 'NLP Engineer', 'Build and optimize natural language solutions.', 'Full-time', '95k-125k PKR', 'NLTK, SpaCy, Transformers', 'Lahore'),
(7, 'Graphic Designer Intern', 'Assist in designing visuals for campaigns.', 'Internship', '18k-24k PKR', 'Photoshop, Illustrator, Canva', 'Remote'),
(8, 'SEO Specialist', 'Improve website search rankings.', 'Full-time', '60k-80k PKR', 'SEO Tools, Link Building, Keyword Research', 'Islamabad'),
(5, 'Intern QA Tester', 'Assist with test case execution and reporting.', 'Internship', '20k-26k PKR', 'Manual Testing, Bug Reporting, Test Plans', 'Lahore'),
(9, 'IoT Developer', 'Develop and integrate IoT devices and APIs.', 'Full-time', '90k-110k PKR', 'Raspberry Pi, MQTT, C++', 'Karachi'),
(10, 'CRM Analyst', 'Analyze customer interactions to optimize engagement.', 'Full-time', '70k-95k PKR', 'CRM Tools, Data Analysis, Excel', 'Remote');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(2, 'Digital Product Intern', 'Support the product team in research and prototyping.', 'Internship', '20k-27k PKR', 'Wireframes, Research, Documentation', 'Lahore'),
(1, 'Data Engineer', 'Build and manage scalable data pipelines.', 'Full-time', '100k-130k PKR', 'ETL, Spark, SQL', 'Islamabad'),
(5, 'Python Developer Intern', 'Assist in backend development tasks.', 'Internship', '22k-30k PKR', 'Python, Flask, PostgreSQL', 'Karachi'),
(6, 'Business Analyst', 'Analyze requirements and deliver insights to teams.', 'Full-time', '70k-90k PKR', 'BRD, SQL, Communication', 'Lahore'),
(3, 'Cloud Support Intern', 'Help in troubleshooting cloud-related issues.', 'Internship', '18k-25k PKR', 'AWS, Support Tickets, Logs', 'Remote'),
(4, 'Marketing Analyst', 'Evaluate marketing performance and campaigns.', 'Full-time', '60k-85k PKR', 'Google Analytics, Excel, Reporting', 'Karachi'),
(7, 'Frontend Intern', 'Assist in UI implementation and testing.', 'Internship', '20k-28k PKR', 'HTML, CSS, Vue.js', 'Lahore'),
(10, 'Site Reliability Engineer', 'Ensure system uptime and reliability.', 'Full-time', '110k-140k PKR', 'Monitoring, Load Balancing, Linux', 'Islamabad'),
(9, 'AI Chatbot Developer', 'Design and deploy intelligent chatbots.', 'Full-time', '90k-120k PKR', 'Rasa, Dialogflow, Python', 'Remote'),
(8, 'Social Media Intern', 'Assist in managing brand social channels.', 'Internship', '18k-24k PKR', 'Facebook, Instagram, Scheduling Tools', 'Karachi');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Junior Software Engineer', 'Develop and maintain code under senior supervision.', 'Full-time', '65k-85k PKR', 'OOP, Git, SQL', 'Lahore'),
(6, 'Cloud Automation Intern', 'Assist in automating cloud workflows.', 'Internship', '20k-30k PKR', 'Python, Bash, AWS CLI', 'Remote'),
(2, 'SaaS Product Manager', 'Lead development of new SaaS features.', 'Full-time', '110k-140k PKR', 'Agile, Jira, SaaS Metrics', 'Islamabad'),
(1, 'Backend Intern', 'Support microservice development and maintenance.', 'Internship', '22k-30k PKR', 'Node.js, Express, MongoDB', 'Lahore'),
(5, 'UI/UX Intern', 'Assist in UI design and feedback implementation.', 'Internship', '20k-26k PKR', 'Figma, Design Systems, User Testing', 'Karachi'),
(4, 'Business Dev Associate', 'Drive growth through client acquisition.', 'Full-time', '60k-85k PKR', 'Sales, Communication, CRM Tools', 'Lahore'),
(8, 'IT Admin Intern', 'Support IT operations and hardware setup.', 'Internship', '18k-24k PKR', 'Networking, Windows, Troubleshooting', 'Islamabad'),
(10, 'Analytics Engineer', 'Bridge analytics and engineering workflows.', 'Full-time', '95k-125k PKR', 'dbt, SQL, Data Warehousing', 'Remote'),
(7, 'Mobile UI Intern', 'Assist in UI design for mobile apps.', 'Internship', '19k-25k PKR', 'Adobe XD, Figma, UX Principles', 'Karachi'),
(9, 'Security Operations Analyst', 'Monitor and respond to security incidents.', 'Full-time', '100k-130k PKR', 'SIEM, Threat Analysis, Splunk', 'Lahore');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(6, 'Data Engineer Intern', 'Assist in building data pipelines for analytics.', 'Internship', '22k-28k PKR', 'Python, SQL, Data Pipelines', 'Lahore'),
(1, 'AI Researcher', 'Conduct AI research and develop new models.', 'Full-time', '120k-150k PKR', 'Machine Learning, Research Papers, Python', 'Karachi'),
(5, 'Web Developer Intern', 'Help in frontend and backend web development tasks.', 'Internship', '18k-24k PKR', 'HTML, CSS, React', 'Islamabad'),
(4, 'Product Marketing Intern', 'Assist with product marketing campaigns and content creation.', 'Internship', '20k-28k PKR', 'Content Writing, Digital Marketing, Canva', 'Karachi'),
(2, 'Software Developer', 'Work on developing scalable applications and services.', 'Full-time', '80k-100k PKR', 'Java, Spring Boot, SQL', 'Remote'),
(3, 'Scrum Master Intern', 'Support the agile development process and ceremonies.', 'Internship', '20k-26k PKR', 'Agile, Scrum, Jira', 'Lahore'),
(6, 'Business Analyst Intern', 'Assist in analyzing business requirements and documenting solutions.', 'Internship', '18k-25k PKR', 'Data Analysis, Excel, SQL', 'Karachi'),
(7, 'Cloud Developer Intern', 'Assist in cloud app development and deployment.', 'Internship', '21k-30k PKR', 'AWS, Docker, Python', 'Islamabad'),
(9, 'Frontend Engineer', 'Build and optimize the frontend of web applications.', 'Full-time', '75k-95k PKR', 'React, HTML, CSS', 'Lahore'),
(10, 'Data Analyst Intern', 'Support data analysis and reporting tasks.', 'Internship', '18k-22k PKR', 'Excel, SQL, Tableau', 'Karachi');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(2, 'Cloud Solutions Architect', 'Design cloud solutions and architecture for clients.', 'Full-time', '120k-150k PKR', 'AWS, Azure, Cloud Architecture', 'Lahore'),
(1, 'Data Scientist', 'Analyze large datasets and create predictive models.', 'Full-time', '110k-140k PKR', 'Python, R, Machine Learning', 'Karachi'),
(5, 'Backend Developer Intern', 'Support in building server-side applications.', 'Internship', '20k-30k PKR', 'Node.js, Express, MongoDB', 'Islamabad'),
(6, 'Blockchain Intern', 'Assist in developing blockchain-based applications.', 'Internship', '22k-30k PKR', 'Ethereum, Solidity, Web3.js', 'Remote'),
(4, 'Product Designer', 'Design intuitive user interfaces and experiences.', 'Full-time', '75k-100k PKR', 'Sketch, Figma, User Research', 'Lahore'),
(8, 'Machine Learning Engineer', 'Work on developing ML models and systems.', 'Full-time', '90k-120k PKR', 'TensorFlow, Python, Deep Learning', 'Karachi'),
(3, 'Technical Support Intern', 'Assist with technical support tasks and troubleshooting.', 'Internship', '18k-24k PKR', 'Troubleshooting, Network Setup', 'Lahore'),
(2, 'IT Consultant', 'Provide consultancy for IT infrastructure and projects.', 'Full-time', '100k-130k PKR', 'Networking, Cloud Solutions, Consultancy', 'Islamabad'),
(7, 'Full Stack Developer', 'Work on both front-end and back-end development.', 'Full-time', '80k-110k PKR', 'React, Node.js, MongoDB', 'Karachi'),
(9, 'Product Manager Intern', 'Support the product team with product lifecycle management.', 'Internship', '20k-28k PKR', 'Product Roadmaps, Agile, Jira', 'Remote');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Data Analyst Intern', 'Assist in analyzing business data and generating reports.', 'Internship', '18k-25k PKR', 'Excel, SQL, Power BI', 'Islamabad'),
(6, 'Software Engineer Intern', 'Assist in the development of software applications.', 'Internship', '22k-30k PKR', 'C++, Python, Git', 'Karachi'),
(1, 'Game Developer', 'Develop immersive gaming experiences for our platform.', 'Full-time', '90k-115k PKR', 'Unity, C#, Game Design', 'Lahore'),
(5, 'Network Security Analyst', 'Monitor and defend network infrastructure against threats.', 'Full-time', '95k-125k PKR', 'Firewalls, IDS, VPN', 'Remote'),
(4, 'QA Automation Engineer', 'Automate testing for software releases.', 'Full-time', '80k-100k PKR', 'Selenium, Java, CI/CD', 'Karachi'),
(2, 'Product Owner', 'Manage product backlog and prioritize feature releases.', 'Full-time', '100k-130k PKR', 'Agile, Scrum, Product Backlog', 'Lahore'),
(8, 'Frontend Developer', 'Develop responsive UI for web applications.', 'Full-time', '75k-95k PKR', 'Vue.js, CSS, HTML', 'Islamabad'),
(10, 'DevOps Intern', 'Assist with continuous integration and deployment processes.', 'Internship', '20k-28k PKR', 'Docker, Jenkins, CI/CD', 'Remote'),
(7, 'Python Developer', 'Write Python code for backend development and automation.', 'Full-time', '80k-100k PKR', 'Python, Flask, SQL', 'Karachi'),
(9, 'Data Science Intern', 'Assist with data cleaning and feature engineering.', 'Internship', '18k-25k PKR', 'Python, Pandas, Numpy', 'Lahore');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(2, 'Database Administrator', 'Manage and optimize large-scale databases.', 'Full-time', '85k-110k PKR', 'SQL, NoSQL, Database Design', 'Karachi'),
(3, 'Systems Architect', 'Design scalable systems for our cloud platform.', 'Full-time', '120k-150k PKR', 'AWS, Kubernetes, Microservices', 'Islamabad'),
(6, 'UI/UX Designer Intern', 'Assist with designing user-friendly interfaces.', 'Internship', '20k-26k PKR', 'Figma, Adobe XD, Sketch', 'Lahore'),
(4, 'Business Development Intern', 'Assist with business expansion and partnerships.', 'Internship', '18k-24k PKR', 'Communication, Networking, CRM', 'Karachi'),
(5, 'DevOps Engineer', 'Ensure reliable and scalable infrastructure automation.', 'Full-time', '100k-130k PKR', 'AWS, Terraform, Ansible', 'Islamabad'),
(1, 'Marketing Intern', 'Support in marketing strategies and campaign execution.', 'Internship', '15k-20k PKR', 'SEO, Social Media, Google Ads', 'Lahore'),
(8, 'Full Stack Developer', 'Develop and maintain full-stack applications.', 'Full-time', '90k-120k PKR', 'React, Node.js, MongoDB', 'Karachi'),
(7, 'Cloud Architect Intern', 'Assist with cloud infrastructure planning and implementation.', 'Internship', '22k-30k PKR', 'AWS, GCP, Docker', 'Lahore'),
(9, 'Network Engineer', 'Design and maintain network infrastructures.', 'Full-time', '75k-95k PKR', 'Cisco, Networking Protocols, Firewall', 'Remote'),
(10, 'Salesforce Developer', 'Develop and maintain custom Salesforce applications.', 'Full-time', '95k-115k PKR', 'Salesforce, Apex, Visualforce', 'Islamabad');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Cloud Engineer', 'Design and implement scalable cloud infrastructure.', 'Full-time', '100k-120k PKR', 'AWS, Azure, CloudFormation', 'Lahore'),
(2, 'Frontend Developer Intern', 'Assist in the development of user interfaces for web applications.', 'Internship', '18k-24k PKR', 'JavaScript, React, CSS', 'Karachi'),
(5, 'Business Analyst Intern', 'Support with business process modeling and analysis.', 'Internship', '20k-26k PKR', 'Excel, Power BI, SQL', 'Islamabad'),
(6, 'Backend Developer', 'Develop server-side applications and services.', 'Full-time', '95k-115k PKR', 'Java, Spring Boot, SQL', 'Karachi'),
(1, 'Content Writer Intern', 'Create blog posts, technical articles, and social media content.', 'Internship', '15k-22k PKR', 'Writing, SEO, WordPress', 'Lahore'),
(8, 'Cybersecurity Analyst', 'Protect company data by monitoring security systems.', 'Full-time', '100k-130k PKR', 'SIEM, Penetration Testing, Encryption', 'Islamabad'),
(7, 'Mobile App Developer Intern', 'Assist with the development of mobile applications for iOS and Android.', 'Internship', '22k-28k PKR', 'Swift, Kotlin, Firebase', 'Karachi'),
(9, 'Web Developer', 'Build responsive websites using modern technologies.', 'Full-time', '80k-100k PKR', 'HTML, CSS, JavaScript', 'Lahore'),
(10, 'Machine Learning Intern', 'Assist with training and fine-tuning ML models for various applications.', 'Internship', '20k-28k PKR', 'TensorFlow, Keras, Python', 'Remote'),
(2, 'Data Engineer Intern', 'Assist in building data pipelines and processing large datasets.', 'Internship', '22k-30k PKR', 'SQL, Python, ETL', 'Karachi');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Network Engineer Intern', 'Assist in maintaining and troubleshooting network systems.', 'Internship', '18k-24k PKR', 'Networking, LAN/WAN, Troubleshooting', 'Islamabad'),
(1, 'AI Developer', 'Develop AI models and integrate them into applications.', 'Full-time', '110k-140k PKR', 'Python, TensorFlow, AI Models', 'Karachi'),
(5, 'Project Manager Intern', 'Assist in project planning, execution, and monitoring.', 'Internship', '20k-28k PKR', 'Project Management, Jira, Excel', 'Lahore'),
(6, 'Android Developer', 'Develop and maintain Android applications.', 'Full-time', '80k-100k PKR', 'Java, Kotlin, Android Studio', 'Karachi'),
(4, 'Cloud Solutions Architect Intern', 'Assist in designing and implementing cloud solutions for clients.', 'Internship', '22k-30k PKR', 'AWS, GCP, Cloud Infrastructure', 'Remote'),
(2, 'Full Stack Developer', 'Develop both frontend and backend for web applications.', 'Full-time', '95k-120k PKR', 'JavaScript, Node.js, MongoDB', 'Islamabad'),
(8, 'Content Marketing Intern', 'Support the content marketing team with strategy and execution.', 'Internship', '18k-25k PKR', 'SEO, Blogging, Social Media', 'Lahore'),
(7, 'Data Analyst', 'Analyze business data and generate insights for decision making.', 'Full-time', '75k-95k PKR', 'Excel, SQL, Tableau', 'Karachi'),
(9, 'Game Developer Intern', 'Assist in the development of video games and interactive content.', 'Internship', '20k-26k PKR', 'Unity, C#, Game Design', 'Islamabad'),
(10, 'DevOps Engineer Intern', 'Assist in implementing CI/CD pipelines and automation.', 'Internship', '22k-30k PKR', 'Docker, Jenkins, AWS', 'Remote');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Product Designer', 'Design user-centric products and experiences for our platform.', 'Full-time', '85k-110k PKR', 'Figma, Adobe XD, User Research', 'Karachi'),
(6, 'Frontend Developer', 'Develop engaging and user-friendly web interfaces.', 'Full-time', '80k-100k PKR', 'JavaScript, React, HTML/CSS', 'Lahore'),
(5, 'Machine Learning Intern', 'Support in training machine learning models for various applications.', 'Internship', '20k-28k PKR', 'Python, TensorFlow, Data Analysis', 'Karachi'),
(7, 'Technical Writer', 'Create documentation and technical content for software products.', 'Full-time', '70k-90k PKR', 'Writing, Documentation, API', 'Remote'),
(4, 'HR Intern', 'Assist in recruitment and employee management tasks.', 'Internship', '18k-25k PKR', 'Recruitment, HR Software, Communication', 'Islamabad'),
(8, 'Software Engineer Intern', 'Assist in the development and testing of software products.', 'Internship', '20k-26k PKR', 'Java, C++, Git', 'Lahore'),
(2, 'Blockchain Developer', 'Develop decentralized applications and smart contracts.', 'Full-time', '110k-130k PKR', 'Solidity, Ethereum, Blockchain', 'Karachi'),
(10, 'UX Researcher', 'Conduct user research to inform product design decisions.', 'Full-time', '80k-100k PKR', 'User Research, Interviews, Prototyping', 'Remote'),
(1, 'Customer Support Specialist', 'Provide excellent customer service and resolve inquiries.', 'Full-time', '45k-60k PKR', 'Communication, CRM Tools, Problem Solving', 'Islamabad'),
(9, 'Marketing Manager Intern', 'Support marketing team with campaigns and strategies.', 'Internship', '18k-24k PKR', 'SEO, Social Media, Content Marketing', 'Karachi');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(6, 'Cloud Engineer Intern', 'Assist in building and maintaining cloud infrastructures.', 'Internship', '22k-30k PKR', 'AWS, GCP, Docker', 'Lahore'),
(2, 'Backend Developer Intern', 'Assist in developing server-side applications and services.', 'Internship', '20k-28k PKR', 'Node.js, Express, MongoDB', 'Karachi'),
(1, 'Product Manager', 'Lead product teams to deliver quality software solutions.', 'Full-time', '110k-140k PKR', 'Agile, Scrum, Product Roadmap', 'Lahore'),
(8, 'Business Analyst', 'Analyze business data and provide actionable insights.', 'Full-time', '85k-105k PKR', 'SQL, Power BI, Excel', 'Islamabad'),
(3, 'Web Developer Intern', 'Assist with developing and maintaining websites.', 'Internship', '18k-24k PKR', 'HTML, CSS, JavaScript', 'Karachi'),
(4, 'Network Engineer', 'Maintain and secure networking infrastructure for clients.', 'Full-time', '95k-120k PKR', 'Cisco, Networking, Security', 'Remote'),
(5, 'Artificial Intelligence Intern', 'Work on AI-driven projects and systems.', 'Internship', '20k-28k PKR', 'Python, Machine Learning, TensorFlow', 'Lahore'),
(7, 'Cloud Architect', 'Design cloud infrastructure for scalable applications.', 'Full-time', '110k-130k PKR', 'AWS, CloudFormation, Kubernetes', 'Karachi'),
(9, 'Frontend Engineer Intern', 'Assist in building the front-end of web applications.', 'Internship', '18k-26k PKR', 'React, HTML, CSS', 'Lahore'),
(10, 'Quality Assurance Intern', 'Assist with software testing and quality assurance tasks.', 'Internship', '18k-25k PKR', 'Manual Testing, Automation, Selenium', 'Karachi');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Data Engineer Intern', 'Support in building data pipelines and processing large datasets.', 'Internship', '22k-30k PKR', 'Python, SQL, Hadoop', 'Islamabad'),
(5, 'Software Developer', 'Develop and maintain scalable software solutions.', 'Full-time', '95k-115k PKR', 'C++, Java, SQL', 'Karachi'),
(2, 'Systems Administrator', 'Maintain and troubleshoot IT systems and networks.', 'Full-time', '85k-100k PKR', 'Linux, Windows, Networking', 'Lahore'),
(8, 'Marketing Intern', 'Assist with online marketing campaigns and social media strategies.', 'Internship', '18k-24k PKR', 'SEO, Google Ads, Content Creation', 'Karachi'),
(1, 'Data Analyst Intern', 'Assist with data analysis and generating reports using Excel and Power BI.', 'Internship', '18k-24k PKR', 'Excel, Power BI, Data Analysis', 'Islamabad'),
(4, 'Blockchain Developer Intern', 'Assist with developing blockchain-based applications and smart contracts.', 'Internship', '20k-30k PKR', 'Solidity, Ethereum, JavaScript', 'Lahore'),
(7, 'Full Stack Developer Intern', 'Assist with building full-stack web applications.', 'Internship', '22k-30k PKR', 'React, Node.js, MongoDB', 'Karachi'),
(6, 'Cybersecurity Engineer', 'Monitor and protect company networks and systems from cyber threats.', 'Full-time', '110k-130k PKR', 'Penetration Testing, Security Tools, Firewalls', 'Remote'),
(9, 'Data Science Intern', 'Work on data preprocessing, cleaning, and feature engineering.', 'Internship', '18k-25k PKR', 'Python, Pandas, Numpy', 'Lahore'),
(10, 'Frontend Developer Intern', 'Assist with creating responsive web pages and user interfaces.', 'Internship', '18k-24k PKR', 'HTML, CSS, JavaScript', 'Karachi');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'AI Research Intern', 'Assist with research on AI models and algorithms.', 'Internship', '20k-28k PKR', 'Python, TensorFlow, Research', 'Karachi'),
(5, 'IT Support Specialist', 'Provide technical support for internal IT systems and users.', 'Full-time', '70k-90k PKR', 'Windows, Networking, Troubleshooting', 'Lahore'),
(2, 'Game Developer', 'Design and develop interactive and engaging video games.', 'Full-time', '110k-130k PKR', 'Unity, C#, Game Design', 'Islamabad'),
(4, 'SEO Specialist', 'Optimize website content for search engines and improve organic traffic.', 'Full-time', '75k-95k PKR', 'SEO, SEM, Google Analytics', 'Karachi'),
(6, 'Project Manager', 'Lead and manage projects from inception to completion.', 'Full-time', '95k-115k PKR', 'Agile, Jira, Scrum', 'Lahore'),
(8, 'Junior Web Developer', 'Assist in developing dynamic web applications and websites.', 'Full-time', '60k-80k PKR', 'JavaScript, HTML, CSS', 'Karachi'),
(7, 'Data Engineer', 'Design and maintain scalable data pipelines for processing large datasets.', 'Full-time', '100k-120k PKR', 'SQL, Python, Hadoop', 'Islamabad'),
(9, 'Salesforce Administrator', 'Configure and maintain Salesforce CRM platform for clients.', 'Full-time', '90k-110k PKR', 'Salesforce, CRM, Data Management', 'Remote'),
(10, 'Graphic Designer', 'Design visually appealing graphics for digital media and print.', 'Full-time', '65k-85k PKR', 'Photoshop, Illustrator, Branding', 'Lahore'),
(1, 'Mobile App Developer', 'Develop mobile applications for Android and iOS platforms.', 'Full-time', '85k-105k PKR', 'React Native, Java, Kotlin', 'Karachi');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Product Manager Intern', 'Assist with managing product development cycles and roadmaps.', 'Internship', '18k-25k PKR', 'Agile, Jira, Product Roadmap', 'Karachi'),
(5, 'Cloud Solutions Engineer', 'Design and implement cloud solutions for various clients.', 'Full-time', '105k-130k PKR', 'AWS, Azure, Cloud Infrastructure', 'Lahore'),
(2, 'DevOps Intern', 'Assist with automating deployment pipelines and infrastructure management.', 'Internship', '20k-28k PKR', 'Docker, Kubernetes, CI/CD', 'Islamabad'),
(4, 'Game Designer', 'Design and develop game mechanics, levels, and interactive features.', 'Full-time', '90k-120k PKR', 'Unity, Game Design, 3D Modeling', 'Karachi'),
(6, 'Operations Manager', 'Oversee daily operations and optimize business processes.', 'Full-time', '100k-130k PKR', 'Leadership, Process Management, Operations', 'Remote'),
(8, 'Data Analyst Intern', 'Assist in analyzing data sets and providing insights to support decision-making.', 'Internship', '18k-24k PKR', 'Excel, SQL, Data Visualization', 'Lahore'),
(7, 'Digital Marketing Intern', 'Assist with running digital marketing campaigns and content creation.', 'Internship', '18k-22k PKR', 'SEO, Google Ads, Social Media', 'Karachi'),
(9, 'Python Developer', 'Develop Python applications and backend services.', 'Full-time', '80k-100k PKR', 'Python, Django, SQL', 'Lahore'),
(10, 'Security Analyst', 'Monitor and analyze security threats and implement solutions to protect systems.', 'Full-time', '90k-110k PKR', 'Firewalls, Security Monitoring, Penetration Testing', 'Karachi'),
(1, 'Mobile Developer Intern', 'Assist with developing mobile apps for Android and iOS platforms.', 'Internship', '18k-24k PKR', 'Java, Kotlin, Swift', 'Islamabad');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'AI Engineer', 'Design and implement AI models and solutions for diverse applications.', 'Full-time', '110k-130k PKR', 'Python, TensorFlow, Machine Learning', 'Karachi'),
(5, 'Marketing Specialist', 'Create and manage marketing campaigns to promote the company’s products.', 'Full-time', '75k-95k PKR', 'SEO, Content Marketing, Email Marketing', 'Lahore'),
(2, 'Backend Developer', 'Develop server-side logic and optimize database architecture for applications.', 'Full-time', '90k-115k PKR', 'Node.js, MongoDB, SQL', 'Islamabad'),
(4, 'Systems Analyst', 'Analyze and design systems to improve business processes and productivity.', 'Full-time', '80k-100k PKR', 'Systems Design, SQL, Process Optimization', 'Karachi'),
(6, 'UX/UI Designer', 'Create intuitive and visually appealing designs for web and mobile applications.', 'Full-time', '95k-115k PKR', 'Adobe XD, Figma, User Research', 'Remote'),
(8, 'Data Scientist', 'Use data analysis and machine learning to uncover insights and drive decisions.', 'Full-time', '110k-130k PKR', 'Python, R, Machine Learning', 'Lahore'),
(7, 'IT Support Technician', 'Provide technical support and troubleshooting for company systems.', 'Full-time', '65k-80k PKR', 'Windows, Networking, Troubleshooting', 'Karachi'),
(9, 'DevOps Engineer Intern', 'Assist with continuous integration, deployment pipelines, and infrastructure management.', 'Internship', '20k-28k PKR', 'Docker, Jenkins, AWS', 'Islamabad'),
(10, 'Software Testing Engineer', 'Test and validate software products to ensure quality and performance.', 'Full-time', '85k-105k PKR', 'Selenium, Test Automation, QA', 'Karachi'),
(1, 'Business Development Executive', 'Generate leads, close sales, and build business relationships.', 'Full-time', '75k-95k PKR', 'Sales, Communication, CRM', 'Lahore');

INSERT INTO JobPostings (CompanyID, Title, Description, JobType, SalaryRange, RequiredSkills, Location) VALUES
(3, 'Junior Data Scientist', 'Assist in building predictive models and performing data analysis.', 'Internship', '22k-30k PKR', 'Python, R, Machine Learning', 'Karachi'),
(5, 'Cloud Architect', 'Design and implement scalable cloud architectures for enterprise clients.', 'Full-time', '120k-140k PKR', 'AWS, Azure, GCP', 'Lahore'),
(2, 'Digital Marketing Manager', 'Oversee the execution of digital marketing strategies and campaigns.', 'Full-time', '95k-115k PKR', 'SEO, Google Ads, Content Marketing', 'Islamabad'),
(4, 'Front-end Developer', 'Develop visually appealing and responsive web interfaces.', 'Full-time', '80k-100k PKR', 'HTML, CSS, JavaScript', 'Karachi'),
(6, 'Business Analyst Intern', 'Assist in gathering and analyzing business requirements and data.', 'Internship', '20k-28k PKR', 'Excel, Power BI, SQL', 'Lahore'),
(8, 'Software Engineer Intern', 'Work with the development team to build and test software applications.', 'Internship', '22k-30k PKR', 'Java, C++, Git', 'Karachi'),
(7, 'Blockchain Developer', 'Develop decentralized applications and smart contracts for blockchain solutions.', 'Full-time', '100k-130k PKR', 'Solidity, Ethereum, Blockchain', 'Islamabad'),
(9, 'Mobile Application Developer', 'Develop and maintain mobile applications for iOS and Android.', 'Full-time', '90k-110k PKR', 'Swift, Kotlin, React Native', 'Lahore'),
(10, 'Quality Assurance Engineer', 'Test and validate software products to ensure quality and performance standards.', 'Full-time', '80k-100k PKR', 'Manual Testing, Automation, Selenium', 'Karachi'),
(1, 'Content Writer', 'Write blog posts, articles, and technical documentation for the company blog.', 'Full-time', '55k-75k PKR', 'SEO, WordPress, Writing', 'Islamabad');

--Applications
INSERT INTO Applications (StudentID, JobID, ApplicationDate) VALUES
(1, 5, '2025-04-10'),
(2, 10, '2025-04-12'),
(3, 7, '2025-04-13'),
(4, 6, '2025-04-14'),
(5, 12, '2025-04-10'),
(6, 8, '2025-04-11'),
(7, 4, '2025-04-15'),
(8, 13, '2025-04-14'),
(9, 2, '2025-04-16'),
(10, 1, '2025-04-17');

INSERT INTO Applications (StudentID, JobID, ApplicationDate) VALUES
(11, 14, '2025-04-10'),
(12, 19, '2025-04-12'),
(13, 15, '2025-04-14'),
(14, 20, '2025-04-13'),
(15, 3, '2025-04-11'),
(16, 9, '2025-04-15'),
(17, 18, '2025-04-16'),
(18, 2, '2025-04-14'),
(19, 5, '2025-04-17'),
(20, 8, '2025-04-10');

INSERT INTO Applications (StudentID, JobID, ApplicationDate) VALUES
(21, 25, '2025-04-12'),
(22, 30, '2025-04-13'),
(23, 28, '2025-04-14'),
(24, 22, '2025-04-15'),
(25, 19, '2025-04-11'),
(26, 26, '2025-04-16'),
(27, 23, '2025-04-17'),
(28, 21, '2025-04-10'),
(29, 29, '2025-04-12'),
(30, 27, '2025-04-13');

INSERT INTO Applications (StudentID, JobID, ApplicationDate) VALUES
(31, 33, '2025-04-10'),
(32, 36, '2025-04-11'),
(33, 32, '2025-04-12'),
(34, 38, '2025-04-13'),
(35, 35, '2025-04-14'),
(36, 31, '2025-04-15'),
(37, 37, '2025-04-16'),
(38, 34, '2025-04-17'),
(39, 40, '2025-04-10'),
(40, 39, '2025-04-11');

INSERT INTO Applications (StudentID, JobID, ApplicationDate) VALUES
(41, 42, '2025-04-12'),
(42, 46, '2025-04-13'),
(43, 45, '2025-04-14'),
(44, 44, '2025-04-15'),
(45, 43, '2025-04-16'),
(46, 41, '2025-04-17'),
(47, 47, '2025-04-10'),
(48, 49, '2025-04-11'),
(49, 48, '2025-04-12'),
(50, 50, '2025-04-13');

INSERT INTO Applications (StudentID, JobID, ApplicationDate) VALUES
(1, 55, '2025-04-12'),
(2, 53, '2025-04-13'),
(3, 56, '2025-04-14'),
(4, 59, '2025-04-15'),
(5, 51, '2025-04-16'),
(6, 54, '2025-04-17'),
(7, 52, '2025-04-10'),
(8, 58, '2025-04-11'),
(9, 60, '2025-04-12'),
(10, 57, '2025-04-13'),

(11, 62, '2025-04-10'),
(12, 64, '2025-04-11'),
(13, 61, '2025-04-12'),
(14, 66, '2025-04-13'),
(15, 63, '2025-04-14'),
(16, 65, '2025-04-15'),
(17, 67, '2025-04-16'),
(18, 68, '2025-04-17'),
(19, 70, '2025-04-10'),
(20, 69, '2025-04-11'),

(21, 72, '2025-04-12'),
(22, 75, '2025-04-13'),
(23, 71, '2025-04-14'),
(24, 73, '2025-04-15'),
(25, 74, '2025-04-16'),
(26, 76, '2025-04-17'),
(27, 77, '2025-04-10'),
(28, 78, '2025-04-11'),
(29, 80, '2025-04-12'),
(30, 79, '2025-04-13'),

(31, 81, '2025-04-10'),
(32, 84, '2025-04-11'),
(33, 82, '2025-04-12'),
(34, 83, '2025-04-13'),
(35, 85, '2025-04-14'),
(36, 88, '2025-04-15'),
(37, 87, '2025-04-16'),
(38, 86, '2025-04-17'),
(39, 89, '2025-04-10'),
(40, 90, '2025-04-11'),

(41, 93, '2025-04-12'),
(42, 91, '2025-04-13'),
(43, 92, '2025-04-14'),
(44, 94, '2025-04-15'),
(45, 95, '2025-04-16'),
(46, 96, '2025-04-17'),
(47, 98, '2025-04-10'),
(48, 97, '2025-04-11'),
(49, 99, '2025-04-12'),
(50, 100, '2025-04-13');

INSERT INTO Applications (StudentID, JobID, ApplicationDate) VALUES
(51, 102, '2025-04-14'),
(52, 107, '2025-04-15'),
(53, 103, '2025-04-16'),
(54, 106, '2025-04-17'),
(55, 101, '2025-04-10'),
(56, 105, '2025-04-11'),
(57, 104, '2025-04-12'),
(58, 108, '2025-04-13'),
(59, 109, '2025-04-14'),
(60, 110, '2025-04-15'),

(61, 112, '2025-04-16'),
(62, 113, '2025-04-17'),
(63, 111, '2025-04-10'),
(64, 115, '2025-04-11'),
(65, 114, '2025-04-12'),
(66, 116, '2025-04-13'),
(67, 117, '2025-04-14'),
(68, 119, '2025-04-15'),
(69, 118, '2025-04-16'),
(70, 120, '2025-04-17'),

(71, 123, '2025-04-10'),
(72, 121, '2025-04-11'),
(73, 124, '2025-04-12'),
(74, 122, '2025-04-13'),
(75, 125, '2025-04-14'),
(76, 127, '2025-04-15'),
(77, 126, '2025-04-16'),
(78, 129, '2025-04-17'),
(79, 128, '2025-04-10'),
(80, 130, '2025-04-11'),

(1, 132, '2025-04-12'),
(2, 133, '2025-04-13'),
(3, 131, '2025-04-14'),
(4, 136, '2025-04-15'),
(5, 135, '2025-04-16'),
(6, 134, '2025-04-17'),
(7, 137, '2025-04-10'),
(8, 139, '2025-04-11'),
(9, 138, '2025-04-12'),
(10, 140, '2025-04-13'),

(11, 142, '2025-04-14'),
(12, 141, '2025-04-15'),
(13, 143, '2025-04-16'),
(14, 144, '2025-04-17'),
(15, 145, '2025-04-10'),
(16, 147, '2025-04-11'),
(17, 146, '2025-04-12'),
(18, 149, '2025-04-13'),
(19, 148, '2025-04-14'),
(20, 150, '2025-04-15');

INSERT INTO Applications (StudentID, JobID, ApplicationDate) VALUES
(21, 152, '2025-04-16'),
(22, 153, '2025-04-17'),
(23, 151, '2025-04-10'),
(24, 156, '2025-04-11'),
(25, 154, '2025-04-12'),
(26, 155, '2025-04-13'),
(27, 158, '2025-04-14'),
(28, 157, '2025-04-15'),
(29, 159, '2025-04-16'),
(30, 160, '2025-04-17'),

(31, 163, '2025-04-10'),
(32, 161, '2025-04-11'),
(33, 162, '2025-04-12'),
(34, 166, '2025-04-13'),
(35, 165, '2025-04-14'),
(36, 164, '2025-04-15'),
(37, 167, '2025-04-16'),
(38, 169, '2025-04-17'),
(39, 168, '2025-04-10'),
(40, 170, '2025-04-11'),

(41, 171, '2025-04-12'),
(42, 172, '2025-04-13'),
(43, 173, '2025-04-14'),
(44, 174, '2025-04-15'),
(45, 175, '2025-04-16'),
(46, 177, '2025-04-17'),
(47, 176, '2025-04-10'),
(48, 178, '2025-04-11'),
(49, 180, '2025-04-12'),
(50, 179, '2025-04-13'),

(51, 183, '2025-04-14'),
(52, 182, '2025-04-15'),
(53, 181, '2025-04-16'),
(54, 185, '2025-04-17'),
(55, 184, '2025-04-10'),
(56, 186, '2025-04-11'),
(57, 188, '2025-04-12'),
(58, 187, '2025-04-13'),
(59, 189, '2025-04-14'),
(60, 190, '2025-04-15'),

(61, 191, '2025-04-16'),
(62, 192, '2025-04-17'),
(63, 193, '2025-04-10'),
(64, 194, '2025-04-11'),
(65, 195, '2025-04-12'),
(66, 196, '2025-04-13'),
(67, 197, '2025-04-14'),
(68, 198, '2025-04-15'),
(69, 199, '2025-04-16'),
(70, 200, '2025-04-17');

--user (recruiters)
INSERT INTO Users (FullName, Email, PasswordHash, Role, IsApproved) VALUES
('Ahsan Malik', 'ahsan.malik@company1.com', 'hashed_pass_201', 'Recruiter', 1),
('Sara Khan', 'sara.khan@company2.com', 'hashed_pass_202', 'Recruiter', 1),
('Bilal Ahmed', 'bilal.ahmed@company3.com', 'hashed_pass_203', 'Recruiter', 1),
('Mehwish Raza', 'mehwish.raza@company4.com', 'hashed_pass_204', 'Recruiter', 1),
('Hamza Tariq', 'hamza.tariq@company5.com', 'hashed_pass_205', 'Recruiter', 1),
('Zara Shah', 'zara.shah@company6.com', 'hashed_pass_206', 'Recruiter', 1),
( 'Taimoor Ali', 'taimoor.ali@company7.com', 'hashed_pass_207', 'Recruiter', 1),
( 'Hina Yousuf', 'hina.yousuf@company8.com', 'hashed_pass_208', 'Recruiter', 1),
('Farhan Javed', 'farhan.javed@company9.com', 'hashed_pass_209', 'Recruiter', 1),
('Mariam Khalid', 'mariam.khalid@company10.com', 'hashed_pass_210', 'Recruiter', 1),
('Ali Raza', 'ali.raza@company11.com', 'hashed_pass_211', 'Recruiter', 1),
('Nimra Sheikh', 'nimra.sheikh@company12.com', 'hashed_pass_212', 'Recruiter', 1),
('Saad Zubair', 'saad.zubair@company13.com', 'hashed_pass_213', 'Recruiter', 1),
('Areeba Noor', 'areeba.noor@company14.com', 'hashed_pass_214', 'Recruiter', 1),
('Osama Siddiq', 'osama.siddiq@company15.com', 'hashed_pass_215', 'Recruiter', 1),
( 'Amna Rizvi', 'amna.rizvi@company16.com', 'hashed_pass_216', 'Recruiter', 1),
('Hassan Iqbal', 'hassan.iqbal@company17.com', 'hashed_pass_217', 'Recruiter', 1),
( 'Kiran Bashir', 'kiran.bashir@company18.com', 'hashed_pass_218', 'Recruiter', 1),
( 'Adnan Butt', 'adnan.butt@company19.com', 'hashed_pass_219', 'Recruiter', 1),
('Laiba Nadeem', 'laiba.nadeem@company20.com', 'hashed_pass_220', 'Recruiter', 1);

--Recruictrs
INSERT INTO Recruiters (RecruiterID, UserID, CompanyID, Designation, ContactNo) VALUES
(1, 81, 1, 'HR Manager', '0300-1111111'),
(2, 82, 2, 'Talent Acquisition Lead', '0301-2222222'),
(3, 83, 3, 'Recruitment Officer', '0302-3333333'),
(4, 84, 4, 'Senior HR Executive', '0303-4444444'),
(5, 85, 5, 'Tech Recruiter', '0304-5555555'),
(6, 86, 6, 'Campus Hiring Manager', '0305-6666666'),
(7, 87, 7, 'HR Business Partner', '0306-7777777'),
(8, 88, 8, 'Lead Recruiter', '0307-8888888'),
(9, 89, 9, 'HR Associate', '0308-9999999'),
(10, 90, 10, 'Sourcing Specialist', '0309-0000000'),
(11, 91, 11, 'Recruiting Coordinator', '0310-1111222'),
(12, 92, 12, 'Technical Recruiter', '0311-2222333'),
(13, 93, 13, 'Staffing Consultant', '0312-3333444'),
(14, 94, 14, 'HR Intern', '0313-4444555'),
(15, 95, 15, 'People Operations Manager', '0314-5555666'),
(16, 96, 16, 'Employee Relations Officer', '0315-6666777'),
(17, 97, 17, 'Head of HR', '0316-7777888'),
(18, 98, 18, 'Hiring Manager', '0317-8888999'),
(19, 99, 19, 'HR Coordinator', '0318-9999000'),
(20, 100, 20, 'Onboarding Specialist', '0319-0000111');

--interviews
INSERT INTO Interviews (ApplicationID, RecruiterID, InterviewTime, InterviewLocation, Result) VALUES
(1, 1, '2025-04-20 10:00:00', 'Room 101, Company 1', 'Pending'),
(2, 2, '2025-04-20 11:00:00', 'Room 102, Company 2', 'Pending'),
(3, 3, '2025-04-21 10:30:00', 'Room 103, Company 3', 'Pending'),
(4, 4, '2025-04-21 12:00:00', 'Room 104, Company 4', 'Pending'),
(5, 5, '2025-04-22 09:00:00', 'Room 105, Company 5', 'Pending'),
(6, 6, '2025-04-22 14:00:00', 'Room 106, Company 6', 'Pending'),
(7, 7, '2025-04-23 10:15:00', 'Room 107, Company 7', 'Pending'),
(8, 8, '2025-04-23 13:30:00', 'Room 108, Company 8', 'Pending'),
(9, 9, '2025-04-24 09:45:00', 'Room 109, Company 9', 'Pending'),
(10, 10, '2025-04-24 11:00:00', 'Room 110, Company 10', 'Pending'),

(11, 11, '2025-04-25 10:00:00', 'Room 111, Company 11', 'Pending'),
(12, 12, '2025-04-25 14:00:00', 'Room 112, Company 12', 'Pending'),
(13, 13, '2025-04-26 10:30:00', 'Room 113, Company 13', 'Pending'),
(14, 14, '2025-04-26 12:15:00', 'Room 114, Company 14', 'Pending'),
(15, 15, '2025-04-27 09:00:00', 'Room 115, Company 15', 'Pending'),
(16, 16, '2025-04-27 11:30:00', 'Room 116, Company 16', 'Pending'),
(17, 17, '2025-04-28 10:45:00', 'Room 117, Company 17', 'Pending'),
(18, 18, '2025-04-28 13:00:00', 'Room 118, Company 18', 'Pending'),
(19, 19, '2025-04-29 09:15:00', 'Room 119, Company 19', 'Pending'),
(20, 20, '2025-04-29 11:00:00', 'Room 120, Company 20', 'Pending'),

(21, 1, '2025-05-01 10:00:00', 'Room 101, Company 1', 'Pending'),
(22, 2, '2025-05-01 12:00:00', 'Room 102, Company 2', 'Pending'),
(23, 3, '2025-05-02 10:30:00', 'Room 103, Company 3', 'Pending'),
(24, 4, '2025-05-02 14:00:00', 'Room 104, Company 4', 'Pending'),
(25, 5, '2025-05-03 09:30:00', 'Room 105, Company 5', 'Pending'),
(26, 6, '2025-05-03 12:30:00', 'Room 106, Company 6', 'Pending'),
(27, 7, '2025-05-04 10:00:00', 'Room 107, Company 7', 'Pending'),
(28, 8, '2025-05-04 11:30:00', 'Room 108, Company 8', 'Pending'),
(29, 9, '2025-05-05 09:15:00', 'Room 109, Company 9', 'Pending'),
(30, 10, '2025-05-05 10:30:00', 'Room 110, Company 10', 'Pending'),

(31, 11, '2025-05-06 14:00:00', 'Room 111, Company 11', 'Pending'),
(32, 12, '2025-05-06 15:00:00', 'Room 112, Company 12', 'Pending'),
(33, 13, '2025-05-07 10:00:00', 'Room 113, Company 13', 'Pending'),
(34, 14, '2025-05-07 12:00:00', 'Room 114, Company 14', 'Pending'),
(35, 15, '2025-05-08 13:30:00', 'Room 115, Company 15', 'Pending'),
(36, 16, '2025-05-08 14:30:00', 'Room 116, Company 16', 'Pending'),
(37, 17, '2025-05-09 10:45:00', 'Room 117, Company 17', 'Pending'),
(38, 18, '2025-05-09 11:45:00', 'Room 118, Company 18', 'Pending'),
(39, 19, '2025-05-10 09:15:00', 'Room 119, Company 19', 'Pending'),
(40, 20, '2025-05-10 10:00:00', 'Room 120, Company 20', 'Pending'),

(41, 1, '2025-05-11 10:30:00', 'Room 101, Company 1', 'Pending'),
(42, 2, '2025-05-11 12:30:00', 'Room 102, Company 2', 'Pending'),
(43, 3, '2025-05-12 14:00:00', 'Room 103, Company 3', 'Pending'),
(44, 4, '2025-05-12 16:00:00', 'Room 104, Company 4', 'Pending'),
(45, 5, '2025-05-13 09:00:00', 'Room 105, Company 5', 'Pending'),
(46, 6, '2025-05-13 11:30:00', 'Room 106, Company 6', 'Pending'),
(47, 7, '2025-05-14 14:30:00', 'Room 107, Company 7', 'Pending'),
(48, 8, '2025-05-14 15:30:00', 'Room 108, Company 8', 'Pending'),
(49, 9, '2025-05-15 10:00:00', 'Room 109, Company 9', 'Pending'),
(50, 10, '2025-05-15 12:00:00', 'Room 110, Company 10', 'Pending');

INSERT INTO Interviews (ApplicationID, RecruiterID, InterviewTime, InterviewLocation, Result) VALUES
(51, 11, '2025-05-16 09:30:00', 'Room 111, Company 11', 'Pending'),
(52, 12, '2025-05-16 11:00:00', 'Room 112, Company 12', 'Pending'),
(53, 13, '2025-05-17 10:00:00', 'Room 113, Company 13', 'Pending'),
(54, 14, '2025-05-17 12:00:00', 'Room 114, Company 14', 'Pending'),
(55, 15, '2025-05-18 13:00:00', 'Room 115, Company 15', 'Pending'),
(56, 16, '2025-05-18 14:30:00', 'Room 116, Company 16', 'Pending'),
(57, 17, '2025-05-19 10:00:00', 'Room 117, Company 17', 'Pending'),
(58, 18, '2025-05-19 12:30:00', 'Room 118, Company 18', 'Pending'),
(59, 19, '2025-05-20 09:45:00', 'Room 119, Company 19', 'Pending'),
(60, 20, '2025-05-20 11:00:00', 'Room 120, Company 20', 'Pending'),

(61, 1, '2025-05-21 10:30:00', 'Room 101, Company 1', 'Pending'),
(62, 2, '2025-05-21 12:30:00', 'Room 102, Company 2', 'Pending'),
(63, 3, '2025-05-22 14:00:00', 'Room 103, Company 3', 'Pending'),
(64, 4, '2025-05-22 16:00:00', 'Room 104, Company 4', 'Pending'),
(65, 5, '2025-05-23 09:00:00', 'Room 105, Company 5', 'Pending'),
(66, 6, '2025-05-23 11:30:00', 'Room 106, Company 6', 'Pending'),
(67, 7, '2025-05-24 14:30:00', 'Room 107, Company 7', 'Pending'),
(68, 8, '2025-05-24 15:30:00', 'Room 108, Company 8', 'Pending'),
(69, 9, '2025-05-25 10:00:00', 'Room 109, Company 9', 'Pending'),
(70, 10, '2025-05-25 12:00:00', 'Room 110, Company 10', 'Pending'),

(71, 11, '2025-05-26 09:30:00', 'Room 111, Company 11', 'Pending'),
(72, 12, '2025-05-26 11:00:00', 'Room 112, Company 12', 'Pending'),
(73, 13, '2025-05-27 10:00:00', 'Room 113, Company 13', 'Pending'),
(74, 14, '2025-05-27 12:00:00', 'Room 114, Company 14', 'Pending'),
(75, 15, '2025-05-28 13:00:00', 'Room 115, Company 15', 'Pending'),
(76, 16, '2025-05-28 14:30:00', 'Room 116, Company 16', 'Pending'),
(77, 17, '2025-05-29 10:00:00', 'Room 117, Company 17', 'Pending'),
(78, 18, '2025-05-29 12:30:00', 'Room 118, Company 18', 'Pending'),
(79, 19, '2025-05-30 09:45:00', 'Room 119, Company 19', 'Pending'),
(80, 20, '2025-05-30 11:00:00', 'Room 120, Company 20', 'Pending'),

(81, 1, '2025-06-01 10:30:00', 'Room 101, Company 1', 'Pending'),
(82, 2, '2025-06-01 12:30:00', 'Room 102, Company 2', 'Pending'),
(83, 3, '2025-06-02 14:00:00', 'Room 103, Company 3', 'Pending'),
(84, 4, '2025-06-02 16:00:00', 'Room 104, Company 4', 'Pending'),
(85, 5, '2025-06-03 09:00:00', 'Room 105, Company 5', 'Pending'),
(86, 6, '2025-06-03 11:30:00', 'Room 106, Company 6', 'Pending'),
(87, 7, '2025-06-04 14:30:00', 'Room 107, Company 7', 'Pending'),
(88, 8, '2025-06-04 15:30:00', 'Room 108, Company 8', 'Pending'),
(89, 9, '2025-06-05 10:00:00', 'Room 109, Company 9', 'Pending'),
(90, 10, '2025-06-05 12:00:00', 'Room 110, Company 10', 'Pending'),

(91, 11, '2025-06-06 09:30:00', 'Room 111, Company 11', 'Pending'),
(92, 12, '2025-06-06 11:00:00', 'Room 112, Company 12', 'Pending'),
(93, 13, '2025-06-07 10:00:00', 'Room 113, Company 13', 'Pending'),
(94, 14, '2025-06-07 12:00:00', 'Room 114, Company 14', 'Pending'),
(95, 15, '2025-06-08 13:00:00', 'Room 115, Company 15', 'Pending'),
(96, 16, '2025-06-08 14:30:00', 'Room 116, Company 16', 'Pending'),
(97, 17, '2025-06-09 10:00:00', 'Room 117, Company 17', 'Pending'),
(98, 18, '2025-06-09 12:30:00', 'Room 118, Company 18', 'Pending'),
(99, 19, '2025-06-10 09:45:00', 'Room 119, Company 19', 'Pending'),
(100, 20, '2025-06-10 11:00:00', 'Room 120, Company 20', 'Pending');

INSERT INTO Interviews (ApplicationID, RecruiterID, InterviewTime, InterviewLocation, Result) VALUES
(101, 1, '2025-06-11 10:30:00', 'Room 101, Company 1', 'Pending'),
(102, 2, '2025-06-11 12:30:00', 'Room 102, Company 2', 'Pending'),
(103, 3, '2025-06-12 14:00:00', 'Room 103, Company 3', 'Pending'),
(104, 4, '2025-06-12 16:00:00', 'Room 104, Company 4', 'Pending'),
(105, 5, '2025-06-13 09:00:00', 'Room 105, Company 5', 'Pending'),
(106, 6, '2025-06-13 11:30:00', 'Room 106, Company 6', 'Pending'),
(107, 7, '2025-06-14 14:30:00', 'Room 107, Company 7', 'Pending'),
(108, 8, '2025-06-14 15:30:00', 'Room 108, Company 8', 'Pending'),
(109, 9, '2025-06-15 10:00:00', 'Room 109, Company 9', 'Pending'),
(110, 10, '2025-06-15 12:00:00', 'Room 110, Company 10', 'Pending'),

(111, 11, '2025-06-16 09:30:00', 'Room 111, Company 11', 'Pending'),
(112, 12, '2025-06-16 11:00:00', 'Room 112, Company 12', 'Pending'),
(113, 13, '2025-06-17 10:00:00', 'Room 113, Company 13', 'Pending'),
(114, 14, '2025-06-17 12:00:00', 'Room 114, Company 14', 'Pending'),
(115, 15, '2025-06-18 13:00:00', 'Room 115, Company 15', 'Pending'),
(116, 16, '2025-06-18 14:30:00', 'Room 116, Company 16', 'Pending'),
(117, 17, '2025-06-19 10:00:00', 'Room 117, Company 17', 'Pending'),
(118, 18, '2025-06-19 12:30:00', 'Room 118, Company 18', 'Pending'),
(119, 19, '2025-06-20 09:45:00', 'Room 119, Company 19', 'Pending'),
(120, 20, '2025-06-20 11:00:00', 'Room 120, Company 20', 'Pending'),

(121, 1, '2025-06-21 10:30:00', 'Room 101, Company 1', 'Pending'),
(122, 2, '2025-06-21 12:30:00', 'Room 102, Company 2', 'Pending'),
(123, 3, '2025-06-22 14:00:00', 'Room 103, Company 3', 'Pending'),
(124, 4, '2025-06-22 16:00:00', 'Room 104, Company 4', 'Pending'),
(125, 5, '2025-06-23 09:00:00', 'Room 105, Company 5', 'Pending'),
(126, 6, '2025-06-23 11:30:00', 'Room 106, Company 6', 'Pending'),
(127, 7, '2025-06-24 14:30:00', 'Room 107, Company 7', 'Pending'),
(128, 8, '2025-06-24 15:30:00', 'Room 108, Company 8', 'Pending'),
(129, 9, '2025-06-25 10:00:00', 'Room 109, Company 9', 'Pending'),
(130, 10, '2025-06-25 12:00:00', 'Room 110, Company 10', 'Pending'),

(131, 11, '2025-06-26 09:30:00', 'Room 111, Company 11', 'Pending'),
(132, 12, '2025-06-26 11:00:00', 'Room 112, Company 12', 'Pending'),
(133, 13, '2025-06-27 10:00:00', 'Room 113, Company 13', 'Pending'),
(134, 14, '2025-06-27 12:00:00', 'Room 114, Company 14', 'Pending'),
(135, 15, '2025-06-28 13:00:00', 'Room 115, Company 15', 'Pending'),
(136, 16, '2025-06-28 14:30:00', 'Room 116, Company 16', 'Pending'),
(137, 17, '2025-06-29 10:00:00', 'Room 117, Company 17', 'Pending'),
(138, 18, '2025-06-29 12:30:00', 'Room 118, Company 18', 'Pending'),
(139, 19, '2025-06-30 09:45:00', 'Room 119, Company 19', 'Pending'),
(140, 20, '2025-06-30 11:00:00', 'Room 120, Company 20', 'Pending'),

(141, 1, '2025-07-01 10:30:00', 'Room 101, Company 1', 'Pending'),
(142, 2, '2025-07-01 12:30:00', 'Room 102, Company 2', 'Pending'),
(143, 3, '2025-07-02 14:00:00', 'Room 103, Company 3', 'Pending'),
(144, 4, '2025-07-02 16:00:00', 'Room 104, Company 4', 'Pending'),
(145, 5, '2025-07-03 09:00:00', 'Room 105, Company 5', 'Pending'),
(146, 6, '2025-07-03 11:30:00', 'Room 106, Company 6', 'Pending'),
(147, 7, '2025-07-04 14:30:00', 'Room 107, Company 7', 'Pending'),
(148, 8, '2025-07-04 15:30:00', 'Room 108, Company 8', 'Pending'),
(149, 9, '2025-07-05 10:00:00', 'Room 109, Company 9', 'Pending'),
(150, 10, '2025-07-05 12:00:00', 'Room 110, Company 10', 'Pending');

INSERT INTO Interviews (ApplicationID, RecruiterID, InterviewTime, InterviewLocation, Result) VALUES
(151, 11, '2025-07-06 09:30:00', 'Room 111, Company 11', 'Pending'),
(152, 12, '2025-07-06 11:00:00', 'Room 112, Company 12', 'Pending'),
(153, 13, '2025-07-07 10:00:00', 'Room 113, Company 13', 'Pending'),
(154, 14, '2025-07-07 12:00:00', 'Room 114, Company 14', 'Pending'),
(155, 15, '2025-07-08 13:00:00', 'Room 115, Company 15', 'Pending'),
(156, 16, '2025-07-08 14:30:00', 'Room 116, Company 16', 'Pending'),
(157, 17, '2025-07-09 10:00:00', 'Room 117, Company 17', 'Pending'),
(158, 18, '2025-07-09 12:30:00', 'Room 118, Company 18', 'Pending'),
(159, 19, '2025-07-10 09:45:00', 'Room 119, Company 19', 'Pending'),
(160, 20, '2025-07-10 11:00:00', 'Room 120, Company 20', 'Pending'),

(161, 1, '2025-07-11 10:30:00', 'Room 101, Company 1', 'Pending'),
(162, 2, '2025-07-11 12:30:00', 'Room 102, Company 2', 'Pending'),
(163, 3, '2025-07-12 14:00:00', 'Room 103, Company 3', 'Pending'),
(164, 4, '2025-07-12 16:00:00', 'Room 104, Company 4', 'Pending'),
(165, 5, '2025-07-13 09:00:00', 'Room 105, Company 5', 'Pending'),
(166, 6, '2025-07-13 11:30:00', 'Room 106, Company 6', 'Pending'),
(167, 7, '2025-07-14 14:30:00', 'Room 107, Company 7', 'Pending'),
(168, 8, '2025-07-14 15:30:00', 'Room 108, Company 8', 'Pending'),
(169, 9, '2025-07-15 10:00:00', 'Room 109, Company 9', 'Pending'),
(170, 10, '2025-07-15 12:00:00', 'Room 110, Company 10', 'Pending'),

(171, 11, '2025-07-16 09:30:00', 'Room 111, Company 11', 'Pending'),
(172, 12, '2025-07-16 11:00:00', 'Room 112, Company 12', 'Pending'),
(173, 13, '2025-07-17 10:00:00', 'Room 113, Company 13', 'Pending'),
(174, 14, '2025-07-17 12:00:00', 'Room 114, Company 14', 'Pending'),
(175, 15, '2025-07-18 13:00:00', 'Room 115, Company 15', 'Pending'),
(176, 16, '2025-07-18 14:30:00', 'Room 116, Company 16', 'Pending'),
(177, 17, '2025-07-19 10:00:00', 'Room 117, Company 17', 'Pending'),
(178, 18, '2025-07-19 12:30:00', 'Room 118, Company 18', 'Pending'),
(179, 19, '2025-07-20 09:45:00', 'Room 119, Company 19', 'Pending'),
(180, 20, '2025-07-20 11:00:00', 'Room 120, Company 20', 'Pending'),

(181, 1, '2025-07-21 10:30:00', 'Room 101, Company 1', 'Pending'),
(182, 2, '2025-07-21 12:30:00', 'Room 102, Company 2', 'Pending'),
(183, 3, '2025-07-22 14:00:00', 'Room 103, Company 3', 'Pending'),
(184, 4, '2025-07-22 16:00:00', 'Room 104, Company 4', 'Pending'),
(185, 5, '2025-07-23 09:00:00', 'Room 105, Company 5', 'Pending'),
(186, 6, '2025-07-23 11:30:00', 'Room 106, Company 6', 'Pending'),
(187, 7, '2025-07-24 14:30:00', 'Room 107, Company 7', 'Pending'),
(188, 8, '2025-07-24 15:30:00', 'Room 108, Company 8', 'Pending'),
(189, 9, '2025-07-25 10:00:00', 'Room 109, Company 9', 'Pending'),
(190, 10, '2025-07-25 12:00:00', 'Room 110, Company 10', 'Pending'),

(191, 11, '2025-07-26 09:30:00', 'Room 111, Company 11', 'Pending'),
(192, 12, '2025-07-26 11:00:00', 'Room 112, Company 12', 'Pending'),
(193, 13, '2025-07-27 10:00:00', 'Room 113, Company 13', 'Pending'),
(194, 14, '2025-07-27 12:00:00', 'Room 114, Company 14', 'Pending'),
(195, 15, '2025-07-28 13:00:00', 'Room 115, Company 15', 'Pending'),
(196, 16, '2025-07-28 14:30:00', 'Room 116, Company 16', 'Pending'),
(197, 17, '2025-07-29 10:00:00', 'Room 117, Company 17', 'Pending'),
(198, 18, '2025-07-29 12:30:00', 'Room 118, Company 18', 'Pending'),
(199, 19, '2025-07-30 09:45:00', 'Room 119, Company 19', 'Pending'),
(200, 20, '2025-07-30 11:00:00', 'Room 120, Company 20', 'Pending');

INSERT INTO Interviews (ApplicationID, RecruiterID, InterviewTime, InterviewLocation, Result) VALUES
(201, 1, '2025-06-16 10:30:00', 'Room 201, Company 1', 'Selected'),
(202, 2, '2025-06-16 12:30:00', 'Room 202, Company 2', 'Selected'),
(203, 3, '2025-06-17 14:00:00', 'Room 203, Company 3', 'Selected'),
(204, 4, '2025-06-17 16:00:00', 'Room 204, Company 4', 'Selected'),
(205, 5, '2025-06-18 09:00:00', 'Room 205, Company 5', 'Selected'),
(206, 6, '2025-06-18 11:30:00', 'Room 206, Company 6', 'Selected'),
(207, 7, '2025-06-19 14:30:00', 'Room 207, Company 7', 'Selected'),
(208, 8, '2025-06-19 15:30:00', 'Room 208, Company 8', 'Selected'),
(209, 9, '2025-06-20 10:00:00', 'Room 209, Company 9', 'Selected'),
(210, 10, '2025-06-20 12:00:00', 'Room 210, Company 10', 'Selected');



INSERT INTO Skills(SkillName) VALUES
('Python'),
('SQL'),
('Communication'),
('Problem Solving'),
('Teamwork');

INSERT INTO Certificates(CertificateName) VALUES
('AWS Certified Solutions Architect'),
('Microsoft Azure Fundamentals'),
('Google Data Analytics Certificate'),
('Coursera Python for Everybody'),
('Oracle Certified Java Programmer');

INSERT INTO StudentSkills(StudentID, SkillID) VALUES
(12, 3),
(27, 1),
(45, 5),
(33, 2),
(68, 4);

INSERT INTO StudentCertificates(StudentID, CertificateID, DateObtained) VALUES
(10, 2, '2023-06-15'),
(25, 1, '2022-12-20'),
(47, 4, '2023-09-10'),
(33, 3, '2024-01-05'),
(79, 5, '2023-11-30');

INSERT INTO Reviews(InterviewID, StudentID, Rating, Feedback) VALUES
(45, 12, 5, 'Great experience, the recruiter was very professional.'),
(89, 27, 4, 'Good interview, but a bit rushed.'),
(133, 34, 3, 'Average interaction, some technical questions were unclear.'),
(77, 58, 5, 'Very positive, felt confident and well-prepared.'),
(190, 21, 2, 'Not a great experience, lacked structure and clarity.');


INSERT INTO Booths(EventID, CompanyID, CoordinatorID, VisitorCount, Location) VALUES
(1, 5, 82, 120, 'Hall A - Booth 1'),
(2, 12, 85, 90, 'Hall B - Booth 3'),
(3, 8, 88, 150, 'Hall C - Booth 2'),
(4, 3, 93, 110, 'Hall A - Booth 4'),
(5, 16, 95, 200, 'Hall B - Booth 1'),
(1, 9, 97, 130, 'Hall C - Booth 5'),
(2, 20, 81, 80, 'Hall A - Booth 2'),
(3, 1, 99, 95, 'Hall B - Booth 6'),
(4, 11, 86, 105, 'Hall C - Booth 3'),
(5, 6, 100, 170, 'Hall A - Booth 7');

INSERT INTO BoothCoordinators(CoordinatorID,UserID, AssignedBoothID, ShiftTime) VALUES
(1,82, 1, '09:00 AM - 11:00 AM'),
(2,85, 2, '11:00 AM - 01:00 PM'),
(3,88, 3, '01:00 PM - 03:00 PM'),
(4,93, 4, '03:00 PM - 05:00 PM'),
(5,95, 5, '05:00 PM - 07:00 PM');

INSERT INTO StudentBoothCheckIn (StudentID, BoothID, CheckInTime) VALUES
(12, 1, '2025-04-20 09:15:00'),
(27, 4, '2025-04-20 10:00:00'),
(53, 7, '2025-04-20 11:30:00'),
(35, 2, '2025-04-20 12:45:00'),
(66, 10, '2025-04-20 13:20:00');




select * from JobFairEvents;
select * from Companies;
select * from Users;
select * from Students;
select * from JobPostings;
select* from Applications;
select* from Recruiters;
select* from Interviews;
select* from Skills;
select * from Certificates;
select* from StudentSkills;
select * from StudentCertificates;
select* from Reviews;
select * from Booths;
select * from BoothCoordinators;
select* from StudentBoothCheckIn;

select* from Reports;