NORMALIZATION
February 11, 2008
Entities: – Library, Book, StudentAttributes: - Roll Number, Name, email Address, phone number, late fine outstanding, book title, book author, book ISBN, book price, library catalog number ( for the copy), quality of the copy, date issued, date to be returned.
| LIBRARY |
| Library Catalogue No.(PK) |
| Student Roll No.(FK) |
| ISBN No.(FK) |
| Quality Of Copy |
| Date OF Issue |
| Date Of Return |
| BOOK |
| ISBN No. (PK) |
| Book Title |
| Book Author |
| Book Price |
| STUDENT |
| Student Roll No.(PK) |
| Name |
| E-Mail ID |
| Phone No. |
| Last Fine Outstanding |
if there is no issue of a copy we lose all information about the copy