System Design · C3.ai · Medium
Design the relational database behind a library system. The system must support: several library branches, physical copies of items held at those branches, e-books whose availability is restricted by licensing limits, library members together with their record of past borrowing, placing holds on items, due dates and fines charged for overdue returns, and searching the catalog. Your answer has three required parts: Schema: Present the tables, including their primary and…