|
Given Data |
|
Roll No. |
|
Name. |
|
E-mail Address. |
|
Phone No. |
|
Late Fine outstanding |
|
Book Title |
|
Book Author |
|
Book ISBN (Globally Unique) |
|
Book Price |
|
Library Catalogue No. |
|
Quality of the copy (Perfect/Damaged) |
|
Library Details Table |
|
Library Catalogue No. |
|
Roll No. |
|
Quality of the book. |
|
Book Details Table |
|
Book ISBN. |
|
Library Catalogue No. |
|
Book Title. |
|
Book Author. |
|
Book Price. |
|
Student Table |
|
Roll No. |
|
Name. |
|
E-mail address |
|
Phone No. |
|
Late Fine outstanding |
Red Font denotes Primary key.
Green Font denotes Foreign key
issue details ? issue date ? return date ?
Comment by prithwis — February 17, 2008 @ 4:46 am