Project: Library Management Database Design using SQL

In this project, I created and designed a complete database system for a Library Management System. The work included: Building core tables: Books, Members, Borrowing Records, and Fines, with constraints such as primary and foreign keys to ensure data integrity and consistency. Inserting sample data to simulate real-world cases (e.g., adding popular books, members, and borrowing transactions). Implementing a practical use case where a member returns a book after the due date; the system updates the return date, checks for delays, calculates the fine automatically, and records it in the Fines table. This project demonstrates my skills in: Database design and modeling. Writing DDL and DML SQL queries. Managing table relationships and constraints. Simulating real-world scenarios for efficient library management