Skip to content

Database Management System Lab

CIS · Final · Spring 25

Batch 18

This browser can’t show the PDF here

Open it, and your phone’s PDF viewer takes it, or download it.

Read the questions as text

Read off the PDF by AI, so it may have mistakes. The PDF is the original.

Lab Final Examination: Spring-2025 Course Code: CIS 222L (Batch: 18_A) Course Title: Database Management System Lab Date: 15/04/2025 Time: 1 Hour Total Marks: 40 Database: University_Enrollment_System Table: Enrollment Student_ID | Student_Name | Course_ID 232-16-019 | Alif | CIS 222 232-16-019 | Alif | CIS122 232-16-020 | Tanim | CIS 222 232-16-020 | Tanim | CIS 131 232-16-022 | Ratul | CIS 313 232-16-024 | Riad | IoT325 Table: Departments Department | Department_Head | Head_Age CIS | Md. Sarwar Hossain Mollah | 42 CSE | Dr. Sheak Rashed Haider Noori | 45 SWE | Dr. Imran Mahmud | 45 Table: Courses Course_ID | Course_Name | Teacher | Department CIS 222 | DBMS | Mr. Mehedi | CIS CIS122 | DS | Mr. Himel | CIS CIS 131 | CAO | Mr. Israfil | CSE CIS 313 | AI | Mr. Mizan | CSE IoT325 | EDC | Mr. Nafees | SWE Task 1 - Basic Structure (15 Marks) Q1. Create the table and insert data as per the mentioned above under the "University_Enrollment_System" database. Task 2 - SQL Query (5x5=25 Marks) Q2. List the number of students enrolled in each course Q3. Find the teachers who teach courses with IDs containing '22' Q4. Find the teacher(s) with the highest age Q5. Find the number of courses each department offers Q6. Find the Course with the Most Enrollments Lab Final Examination: Spring-2025 Course Code: CIS 222L (Batch: 18_B) Course Title: Database Management System Lab Date: 15/04/2025 Time: 1 Hour Total Marks: 40 Database: Hospital_Management_System Table: Doctor DoctorID | DoctorName | DoctorSpecialization D101 | Dr. Smith | General Medicine D102 | Dr. Allen | Neurology D103 | Dr. White | Cardiology Table: Patient PatientID | PatientName P001 | John Doe P002 | Jane Doe P003 | Mary Lee Table: Visit PatientID | DoctorID | VisitDate | Symptom | Medication P001 | D101 | 1/10/2024 | Fever | Paracetamol P001 | D101 | 1/10/2024 | Cough | Cough Syrup P002 | D102 | 2/15/2024 | Headache | Aspirin P002 | D102 | 2/15/2024 | Nausea | Antacid P001 | D103 | 3/18/2024 | Chest Pain | Painkillers P003 | D102 | 4/5/2024 | Dizziness | Antivert Task 1 - Basic Structure (15 Marks) Q1. Create the table and insert data as per the mentioned above under the "Hospital_Management_System" database. Task 2 - SQL Query (5x5=25 Marks) Q2. List the number of medications prescribed per patient Q3. Update a medication from 'Cough Syrup' to 'Napa' Q4. Find the most recent visit date Q5. Find patients who visited 'Dr. Allen' Q6. Find patients who have had more than 1 visit