ER diagram of Library Management System
ER Diagram is known as Entity-Relationship Diagram, it is used to analyze to the structure of the Database. It shows relationships between entities and their attributes. An ER Model provides a means of communication. The Library Management System database keeps track of readers with the following considerations – The system keeps track of the staff with a single point authentication system comprising login Id and password. Staff maintains the book catalog with its ISBN, Book title, price(in INR), category(novel, general, story), edition, author Number and details. A publisher has publisher Id, Year when the book was published, and name of the book. Readers are registered with their user_id, email, name (first name, last name), Phone no (multiple entries allowed), communication address. The staff keeps track of readers. Readers can return/reserve books that stamps with issue date and return date. If not returned within the prescribed time period, it may have a due date too. Staff also g...