RSA-22C4400-F19-HW4: Database Objects, Microloans and SQL Procedures

This assignment provides a comprehensive solution to a database systems homework, addressing key concepts and practical applications. The solution begins by detailing database objects such as stored procedures, triggers, indexes, and views, explaining their functionalities and providing syntax examples. The assignment then delves into transaction isolation levels, elucidating the nuances of read uncommitted, read committed, repeatable read, and serializable levels, alongside an explanation of the lost update problem. A significant portion of the assignment focuses on deriving a database design for a microloans problem, meticulously mapping entities and relationships from an Entity-Relationship (ER) model. Finally, the solution includes SQL stored procedures designed to retrieve loan requests and loans owned by borrowers, showcasing practical implementation of database concepts.