Archive for February 11th, 2008
Normalisation
ATTRIBUTES
Roll no.,Student name,Phone number,Email address,Last outstanding fine,Book ISBN,Book title,Book author,Book price,Date issued,Quality of copy,Date to be returned,Library catalogue number
THIRD NORMALISED FORM
| STUDENT |
| Roll No.(PK) |
| Library catalogue no.(FK) |
| Name |
| Address |
| Email ID |
| Phone number |
| Late fine outstanding |
| BOOK |
| Book title(PK) |
| Book ISBN |
| Book author |
| Book price |
| ISSUE |
| Date issued(PK) |
| Roll No.(FK) |
| Quality of copy |
| Date to be returned |
| BOOK LIST |
| Library catalogue no.(PK) |
| Book title(FK) |
| Date issued(FK) |
1 comment February 11, 2008
