Library Management System ER Diagram
ER diagram for a library management system: members, books, authors, copies, loans and fines. A popular final-year and DBMS project.
How it flows
- books → publishers
- books → categories
- book_authors → books
- book_authors → authors
- book_copies → books
- loans → members
- loans → book_copies
- loans → librarians
- fines → loans
Components
members · books · authors · publishers · categories · book_authors · book_copies · librarians · loans · fines