PostgreSQL Procedures: Implementing SQL Queries and Functions

This assignment solution focuses on PostgreSQL procedures and the use of procedural languages like PL/pgSQL to enhance SQL capabilities. It covers the creation of functions, including the definition of parameters (IN, OUT, and IN OUT types), and their application in querying databases. The assignment includes three specific questions: Q1, which calculates room capacity based on course enrollments; Q2, which retrieves teaching records for a given staff ID; and Q3, which identifies students based on course enrollment criteria and scores within a specified organizational unit. The solution demonstrates the implementation of these functions using PL/pgSQL, views, and SQL functions, providing detailed code and results for each question. The document also provides an overview of essential PostgreSQL commands, including creating tables, querying data, and using DML (Data Manipulation Language) statements.