Library catalogue
Books, authors, loans and members. Demonstrates many-to-many through a join entity.
Rendering…
Make it your own.
[Book]
*id
title
isbn
[Author]
*id
name
[BookAuthor]
*book_id
*author_id
[Member]
*id
name
email
[Loan]
*id
+book_id
+member_id
checked_out
due_back
Book 1--* BookAuthor {label: "has"}
Author 1--* BookAuthor {label: "wrote"}
Member 1--* Loan {label: "borrowed"}
Book 1--* Loan {label: "lent as"}