ER Diagram Sandbox

CSC-326 · Semester V · System Analysis and Design

ERD — Library System

Members borrow books: a classic many-to-many resolved by LOAN.

MEMBERmember_id PKnameaddressphoneBOOKisbn PKtitleauthorcopiesLOANloan_id PKdate_outdue_date1MborrowscontainsMissues

Click an entity

A member borrows many books; a book is borrowed by many members. LOAN stores each individual checkout with its dates, carrying the foreign keys member_id and isbn — the bridge table for the many-to-many relationship.