Database Assignment: PL/SQL Queries and MS Access Implementation

This assignment presents a student's solution to a database assignment involving PL/SQL queries within a Microsoft Access environment. The assignment requires the student to execute and analyze a series of SQL queries designed to extract and manipulate data from a pre-existing database, likely related to chemical composition analysis. The queries cover various aspects of data retrieval and manipulation, including selecting specific fields, joining tables, filtering data based on criteria, grouping results, and ordering output. The solution includes the SQL code for each query, along with the corresponding results, demonstrating the student's ability to write and interpret SQL statements to address specific data retrieval and analysis tasks. The queries involve tables like Gov_Agency, Lab_Technician, LabAppointment, Lab_Tests, and others, showcasing the student's understanding of database relationships and how to use them to extract meaningful information. The assignment also hints at the creation of forms and reports, indicating a broader understanding of database application development. The student's work provides a practical demonstration of SQL skills and database problem-solving within the context of a chemical analysis scenario.