SQLite SQL Query Solutions - Theoretical Computer Science Homework

The assignment solution involves executing various SQL queries on an SQLite database, focusing on operations such as SELECT, INSERT, UPDATE, and DELETE within relational databases. Part A covers 8 different select queries exploring conditions like NULL checks, balance ranges, distinct customer names using joins, maximum balance retrieval, and customer records with or without invoices. Part B includes commands for inserting a new record, altering the Customer table to add a credit history column, updating a specific customer's credit status, deleting an employee record based on first and last name, and adding an email address column to the Employee table. This assignment is designed to enhance understanding of database management through practical SQL applications.