COMP1533 (2018/19) Resit Assignment: Database Query Solutions

This document provides a comprehensive solution to a COMP1533 database assignment, focusing on SQL queries and package implementations. The assignment includes several queries (a through e) addressing database operations such as creating new members, managing book rentals, determining expected return dates, and implementing business hour restrictions. Each query is presented with its corresponding code, output, and supporting screenshots. The solutions demonstrate the use of packages, procedures, functions, cursors, and exception handling within an Oracle database environment. The assignment also covers topics like granting execute permissions, and creating and using procedures and functions to interact with database tables. The code includes detailed comments and is designed to illustrate the concepts and practical applications of database tools. The student's solution covers various aspects of database design and manipulation, providing valuable insights into database programming and problem-solving.