- 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 |
- Login Screen
- Add new Book
- Search Book
- List all Books
- Issue Book-1
- Issue Book-2
- List Issued Books
- List Books to be returned on current Date
Reference Link: [How to create a cardLayout with netbeans GUI Builder](https://stackoverflow.com/questions/21898425/how-to-use-cardlayout-with-netbeans-gui-builder)