Skip to content

Database Systems Lab

ITM · Final · Summer 25

Section A

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.

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.