Entities- Student, Book, Date of Issue, Issued Item.
Attributes- Student Enrolment Number, Name, email Address, phone number, late fine outstanding, book title, book author, book ISBN ( globally unique), book price, library catalogue number ( for the copy), quality of the copy ( “perfect” / “damaged” ) date issued, date to be returned.
UNNORMALISED FORM
| Student Enrolment No. |
| Name |
| E-mail ID |
| Phone No. |
| Late Fine Outstanding |
| Book Title |
| Book Author |
| Book ISBN |
| Book Price |
| Library Catalogue No. |
| Quality Of The Copy |
| Date of Issue |
| Date of Return |
3rd NORMALIZED FORM
STUDENT
| Student Enrolment No. PK |
| Name |
| Email ID |
| Phone No. |
| Late Fine Outstanding |
DATE OF ISSUE
| Issue Date PK |
| Student Enrolment No. FK |
| Date of Return |
BOOK
| Book ISBN No. PK |
| Book Price |
| Book Author |
| Book Title |
ISSUED ITEM
| Library Catalogue No PK |
| Book ISBN No. FK |
| Issue Date FK |
| Quality of the Copy |
February 17, 2008 at 8:57 am
good attempt .. what if the same student issues TWO books on the same date