Monday, February 11, 2008

Following is the information used by the Praxis library represented in an un-normalised form:

Name
Roll Number
Email Address
Phone No.
Late Fine Outstanding
Book ISBN No.
Library Catalog No.
Book Title
Book Author
Book Price
Quality of Book
No. of Copies
Issue Date
Return Date

Third Normal Form:

STUDENT
Roll No. – PK
Name
Email Address
Phone No.
Late Fine Outstanding

BOOK
Book ISBN No. – PK

Library Catalog No. – FK

Book Title
Book Author
Book Price

BOOK LIST
Library Catalog No. – PK

Quality of Book
No. of Copies

ISSUE DETAILS
Issue Detail – PK

Roll No. – FK
Library Catalog No. – FK
Issue Date

Return Date