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
1 comment:
seen. issue has been discussed in class
Post a Comment