Normalization of Library Information

Normalization of Library Information

Problem:

Roll Number, Name, email Address, phone number, late fine outstanding, book title, book author, book ISBN ( globally unique), book price, library catalog number ( for the copy), quality of the copy ( "perfect" / "damaged" ) date issued, date to be returned. Please arrange this information into an appropriate number of ENTITIES in THIRD NORMAL FORM

Solution:

The following solution is in the 3^rd normal form

STUDENT

Roll Number- PK

Name

Phone Number

E-mail ID

Late Fine Outstanding

BOOK LIST

Library Catalog Number – PK

Issue List-FK

Quality of the Copy

No. of Copies Available

BOOK

Book ISBN – PK

Issue List-FK

Book List-FK

Book Author

Book Price

Book Title

ISSUE LIST

Issue No - PK

Library Catalog No-FK

Roll No -FK

Date Issued

Date to be Returned

PK – Primary Key

FK – Foreign Key