Database Systems

Undergraduate course TA, Michigan State University, 2023

All the credit is directed towards course Instructor Professor James Mariani

This document provides students additional help apart from the materials provided by the professor and the reference book, Database System Concepts 7th Edition Abraham Silberschatz , Henry Korth, S. Sudarshan. The goal of the course is to teach important concepts of databases and create a simple database in Python.

LOCKS

Locks are one of the crucial components of the databases. Class objects are considered to be in memory databases. We use class objects to store lock configurations. The lock implementation revolves arround the singleton design pattern as only one lock should be possible across all the database classes. More on the code and implementation of the locks can be found here.