Normalisation
February 11, 2008
avadhut
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) |
Entry Filed under: Uncategorized
1 Comment Add your own
Leave a Comment
Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Trackback this post | Subscribe to comments via RSS Feed
1.
prithwis | February 17, 2008 at 4:26 am
not correct