| | Un-normalised form |
| 1 | Roll No. |
| 2 | Name |
| 3 | E-mail Address |
| 4 | Phone No |
| 5 | Late fine outstanding |
| 6 | Book title |
| 7 | Book author |
| 8 | Book ISBN |
| 9 | Book price |
| 10 | Library catalogue no |
| 11 | Quality of copy |
| 12 | Date issued |
| 13 | Date to be returned |
| Student |
| Roll No PK |
| Name |
| E-mail id |
| Phone_no |
| Late fine outstanding |
| Book |
| Book ISBN PK |
| Library Catlogue no FK |
| Book title |
| Book author |
| Book Price |
| Book List |
| Library_catalog_no PK |
| No of qualities |
| Quality of the book |
| Issue details |
| Issue id PK |
| Roll no Fk |
| Library catalogue no FK |
| Issue date |
| Return date |
1 comment:
how can multiple copies of the book have the same quality ?
Post a Comment