BIT358: Advance Database Assessment 3 – Database Application Solution

This document contains the complete solution for the BIT358 Advance Database Assessment 3, focusing on database application development. The solution includes PL/SQL anonymous blocks, procedures, and functions designed to interact with the MMCREATE database. These components perform tasks such as retrieving movie and member details, checking member existence and suspension status, and updating movie stock flags. The document also presents SQL queries to extract specific data, such as movie categories, suspended members, and movie rentals. The solution provides the necessary code and testing blocks to fulfill all requirements of the assignment, offering a comprehensive guide for students to understand and complete the assessment successfully. The provided code is designed to work with an Oracle database, and includes examples of how to test the code and handle exceptions. This is a valuable resource for students seeking to understand database concepts and PL/SQL programming.