| Un-Normalized Form |
| Roll No. |
| Name |
| Address |
| E-Mail ID |
| Ph. No |
| Late Outstanding Fine |
| Book Title |
| Book Author |
| Book ISBN No. |
| Bok Price |
| Library Cat No. |
| Quality of The Copy |
| Date of Issue |
| Date of Return |
Normalized Form
| Roll No. | PK |
| Name | |
| Email ID | |
| Address | |
| Phone No. | |
| Late Fine Outstanding |
| Book ISBN | PK |
| Library Catalogue No. | FK |
| Book Title | |
| Book Author | |
| Book Price |
| Library Catalogue No. | PK |
| Roll No. | FK |
| Quality of The Copy | |
| Issue Date | |
| Return Date |
February 17, 2008 at 8:40 am
this is perhaps the closest …
only trouble is that information about the quality of the copy is lost when it is not issued