Library Management System Course Project

“Library management System” project is going to be developed in Java using MySQL which focuses on to manage library, book information such as selecting and updating books, maintain the record of the students and book rentals, books that are available in library and the location of the book, and deadline of the books.

Business Rules

· There should be no maximum number of books that can be borrowed

· Books must be returned within 4 weeks period

· Borrowers can borrow a maximum of 5 videos

· Videos must be returned within two weeks

· Borrowers can borrow a maximum of four CDs

· Borrowed CDs must be returned within 2 weeks period

· Borrowers are unable to borrow books, CDs or videos if there is time overdue on the borrower’s account

· Borrowers should be invoiced for items that have not been returned (Respack, R. (2019))

When person borrows item following information has to be recorded:

· Member ID#

· Item ID#

· Date borrowed

· Return due date

· Item should be flagged as borrowed

When Item returned:

· Item should be flagged as returned

Borrower’s account Ruling:

· Name (first and last name)

· Address

· Phone

· Email

· Age

· Each borrower has a unique ID# (Member ID)

Borrowing item rules:

· Item ID#

· Title

· Author

· Subject category

· Media type (book, videos, CD etc...) (Respack, R. (2019))

ER Diagram

Media type

Item ID#

Publisher ID

Title