Designing a Library Management System — LLD - Database Schema Design

On the surface, it sounds easy — "books, members, borrow, return." But once you start digging in, you'll find it touches almost every core schema-design concept: many-to-many relationships, soft busin