Normalisation
ENTITIES: Library, Book, Student
ATTRIBUTES: Name, Roll Number, email Address, phone number, late fine outstanding, book ISBN, book title, book author, book price, library catalog number ( for the copy), quality of the copy, date issued, date to be returned.
| Unnormalised Form |
| Roll Number |
| Name |
| Email Address |
| Phone Number |
| Book ISBN ( Globally Unique) |
| Book Title |
| Book Author |
| Book Price |
| Late Fine Outstanding |
| Library Catalog Number ( For The Copy) |
| Quality Of The Copy ( “Perfect” / “Damaged” ) |
| Date Issued |
| Date To Be Returned |
3rd Normal Form
| STUDENT |
| Roll Number(PK) |
| Name |
| Email Address |
| Phone Number |
| Late Fine Outstanding |
| BOOK |
| Book ISBN No. (PK) |
| Library Catalog Number (FK) |
| Book Title |
| Book Author |
| Book Price |
| ACCOUNTS DETAILS |
| Accounts ID (PK) |
| Roll Number(FK) |
| Date Issued |
| Date To Be Returned |
| Late Fine Outstanding |
| BOOK QUALITY |
| Library Catalog Number (PK) |
| Quality Of The Copy ( “Perfect” / “Damaged” ) |
Have a look at my sweet HOME !!!!!!!!!!
February 17, 2008 at 4:08 am
error >> how do i know which book is issued ? catalog number should be associated with issue / return details