- Login
- Add a book
- Search a Book based on Book Title
- Search Books based on Category
- Search Books based on Author
- List All Books along with author information
- Issue Book to Student
- List Books issued to Student based on USN number
- List books which are to be returned for current date
| Book Table | ------------------ |
|---|---|
| Book ISBN | Primary key |
| Book Title | Varchar |
| Category | Varchar |
| No of Books | int |
| Author Table | ---------------------- |
|---|---|
| Author Name | Varchar |
| Author Mail Id | Varchar |
| Book ISBN | Foreign KEY, References Book |
| Student Table | -------------------- |
|---|---|
| USN | Varchar, Primary Key |
| Name | Varchar |
| Book ISSUE Table | -------------------------------- |
|---|---|
| Issue ID | Auto Increment, Primary Key |
| USN | Foreign Key, References Student |
| Issued Date | Date |
| Return Date | Date |
| Book ISBN | Foreign Key, References Book |
| ADMIN Table | -------------------- |
|---|---|
| Admin Id | Varchar, Primary key |
| Password |
