UnNormalized Form
|
Roll No. |
|
Name |
|
Email_Id |
|
Phone Number |
|
Address |
| Book Title |
| Book Author |
|
Book ISBN |
|
Publisher Name |
|
Book Price |
|
Number of Copies |
|
Late Fine Outstanding |
|
Category Name |
|
Library Book Catalogue No. |
|
Quality of the Copy |
|
Issue Date |
|
Return Date |
Normalized Form (3NF)
STUDENT
|
Roll No. (PK) |
| Name |
| Email_Id |
| Phone Number |
| Address |
|
Late Fine Outstanding |
CATEGORY
|
Category No. (PK) |
|
Library Book Catalogue No. (FK) |
|
Category Name |
BOOK DETAILS
|
Book ISBN (PK) |
|
Library Book Catalogue No. (FK) |
|
Category No. (FK) |
|
Book Title |
|
No. of Copies |
PARTICULAR BOOK DETAILS
|
Library Book Catalogue No. (PK) |
|
Quality of Book |
|
Issue Id (FK) |
ISSUE DETAILS
|
Issue Id (PK) |
|
Roll No. (FK) |
|
Library Book Catalogue No. (FK) |
| Issue Date |
| Return Date |
February 12, 2008 at 4:46 am
Hi, this is a comment.
To delete a comment, just log in, and view the posts’ comments, there you will have the option to edit or delete them.
February 17, 2008 at 4:28 am
category is irrelevent .. otherwise correct .. good