1
You can create below tables for library management system
- Book
- Author
- Reader
- User
- UserPermission
- IssueBook
You can add below functionalities in your project.
- Add/Update/Delete book
- Search book
- Issue book
- Return book
- Extend period for issuing book
- Waitlist of book
- Add/update/delete Reader
- Add/update/delete/User
- User Permission
- Activate/Deactivate user
- Unlock user
- Change password
-1
Follow below links that may help you:
http://www.freestudentprojects.com/studentprojectreport/library-management-system-database-design/
https://www.slideshare.net/fiu025/library-management-system-in-sql
http://www.academia.edu/13780884/Database_system_for_library_management_system