Database Systems Lab
ITM · Final · Summer 25
Section A
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
Daffodil International University
Department of ITM
Faculty of Science and Information Technology (FSIT)
Lab Final Examination, Semester: Summer 2025
Course Code: SE 224, Course Title: Database Systems Lab
Course Teacher: NJ (A)
Time: 1:30 Hours
SET A
Marks: 100
Consider the following schema:
Library Booking System
Member Table
MemberID | MemberName | MembershipType | Email | JoinDate | City
1 | Alice Smith | Student | alice@mail.com | 2025-01-10 | Dhaka
2 | Bob Khan | Staff | bob@mail.com | 2025-02-05 | Chittagong
3 | Carol Tan | Student | carol@mail.com | 2025-03-12 | Dhaka
4 | David Lee | Staff | david@mail.com | 2025-04-01 | Khulna
Booking Table
BookingID | MemberID | BookingDate | RoomNumber | DurationHours | Purpose | Status
101 | 1 | 2025-08-01 | 101 | 2 | Study | Confirmed
102 | 2 | 2025-08-03 | 102 | 3 | Meeting | Pending
103 | 1 | 2025-08-05 | 103 | 1 | Study | Confirmed
104 | 3 | 2025-08-06 | 101 | 2 | Study | Cancelled
105 | 4 | 2025-08-07 | 104 | 4 | Meeting | Confirmed
Questions:
1. Retrieve all members from Dhaka.
2. List all bookings sorted by BookingDate in descending order.
3. Find all members whose names start with the letter 'A'.
4. Display all bookings along with the corresponding member names.
5. Find the total booking hours for all bookings.
6. Count the number of bookings per member.
7. Find members who have more than 1 booking.
8. List members who have bookings longer than 3 hours.
9. Find total booking hours per city.
10. Update the status of bookings with DurationHours less than 2 to 'Reviewed'.
11. Delete all bookings that are cancelled.
12. Find members who have never had a confirmed booking.