Library Management System

Designed and implemented a Library Management System in Python with a normalized SQLite schema — books, members, transactions — enforcing referential integrity via foreign keys.

Built core business logic including book issuance and returns, automatic due-date tracking, and overdue fine calculation, along with keyword-based search across title, author, and genre.

• Normalized schema with enforced foreign-key integrity
• Automatic due-date tracking and overdue fine calculation
• Keyword search across title, author, and genre
• SQL-driven reporting — overdue loans, most-issued books, dashboard stats — via JOINs and aggregation