Normalisation

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>


Un-Normalised form

name, email_id, phone_no, address, membership date, fine_outstanding, book_isbn, library_catalog_no, book_title, book_author, book_price, subject, no_of_copies, issue_date,
return_date


Normalised form

STUDENT
roll_no
name
email_id
address
membership date
fine_outstanding


LIBRARY_LIST
library_catalog_no
subject
no_of_copies


BOOK_DETAILS
book_isbn
library_catalog_no
book_title
book_author
book_price


ISSUE_DETAILS
issue_id
roll_no
library_catalog_no
issue_date
return_date