요청 내용
“Create a public library circulation ERD with Patron, Book, Author, BookAuthor, Loan, and Reservation tables, the shown keys and attributes, books linked to authors, and patrons borrowing and reserving books.”
그렇다면Add overdue fines.Add branch locations.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Separated Loan and Reservation entities to track current and future borrows.
02
Used many-to-one relationships from Loan to Patron and Book.
03
Author linked via many-to-many through BookAuthor junction table.
Reusable for any lending-library system needing core patron, book, and loan tracking.