What you build
A web application for a college library. Librarians add books and members, issue and return books, and the system calculates late fines automatically.
Modules
- Login for librarian and students
- Book catalogue with search by title, author and category
- Issue, return and renewal
- Automatic fine calculation
- Reports: books issued today, overdue books, most-borrowed titles
What you will understand
- How a web page sends data to PHP and PHP talks to MySQL
- Designing tables and relationships (books, members, issues)
- Preventing SQL injection with prepared statements
- Sessions and login
How it is tested
- Test cases for issuing an unavailable book, returning late and searching
- Screenshots of each test with expected and actual results
What goes in the report
- Problem statement and objectives
- ER diagram, DFD and table design
- Screenshots, test cases and conclusion
Viva questions to prepare
- Why did you choose these tables?
- How is the fine calculated?
- What happens if two librarians issue the same copy at once?