The project to be produced is on Library Management System. 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. Authentication system provides login to multiple staffs Staff maintains the book catalog with its ISBN, Book title, price (in INR), category (novel, general, story), edition, author Number and details for multiple books. 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. A reader can reserve N books but one book can be reserved by only one reader. Readers can return/reserve books that stamps with issue date and return date books but a book is published by only one publisher. If not returned within the prescribed time period, it may have a due date too.3 Staff also generate reports that has readers id, registration no of report, book no and return/issue info

Entity Relationship Design