| Name |
| emial_id |
| phone_no |
| late_fine_outstanding |
| book_isbn |
| library_catalog_no |
| book_title |
| book_author |
| book_price |
| quality_of_book |
| no_of_copies |
| issue_date |
| return_date |
UNNORMALISED
NORMALISED
|
STUDENT |
| roll_no PK |
| name |
| emial_id |
| phone_no |
| late_fine_outstanding |
|
ISSUE_DETAILS |
| issue_id PK |
| roll_no FK |
| library_catalog_no FK |
| issue_date |
| return_date |
|
BOOK |
| book_isbn PK |
| library_catalog_no FK |
| book_author |
| book_title |
| book_title |
| BOOK_LIST |
| library_catalog_no PK |
| quality_of_book |
| no_of_copies |
