Database Management System Lab
CIS · Final · Spring 25
Batch 18
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