Unnormalised Form
Name
Roll Number
Email Address
Phone No.
Address
Membership date
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
The table name is given in the form <TABLE>
The primary key is given in the form <PRIMARY KEY>
The foreign key is given in the form <FOREIGN KEY>
THE THIRD NORMAL FORM
Student
Roll NO (PK)
Name
Address
Email Address
Membership date
Phone No
Late fine outstanding
Book List
Library Catalog No. (PK)
Quality of Book
Subject
No. of Copies
BOOK
Book ISBN (PK)
Library Catalog NO.(FK)
Book Title
Book Author
Book Price
Issue Details
Issue Id(PK)
Roll NO.(FK)
Library Catalog No(FK)
Issue Date
Return Date
