| Roll Number |
| Name |
| Email Address |
| Phone Number |
| Late Fine Outstanding |
| Book Title |
| Book Author |
| Publisher Name |
| Book ISBN |
| Book Price |
| Number of copies |
| Category Name |
| Library Catalog Number |
| Quality of the Copy |
| Issue Date |
| Return Date |
| BOOK |
| Book ISBN (PK) |
| Library Catalog Number (FK) |
| Category ID (FK) |
| Book Title |
| Book Author |
| Publisher Name |
| Book Price |
| STUDENT |
| Roll Number (PK) |
| Issue ID (FK) |
| Name |
| Email Address |
| Phone Number |
| Late Fine Outstanding |
| BOOK LIST |
| Library Catalog Number (PK) |
| Quality of Book |
| Number of copies |
| CATEGORY |
| Category ID (PK) |
| Book ID (FK) |
| Category Name |
| ISSUE DETAILS |
| Issue ID(PK) |
| Book ISBN (FK) |
| Issue Date |
| Return Date |
