Scribd
Upload
426 views4 pages

Unnormalized Database of Library

The document discusses normalizing an unnormalized database for a library system by removing redundant data and multi-valued attributes to eliminate anomalies, including creating separate tables for vendor phone numbers and book-vendor relationships to achieve first, second, and third normal form.

Uploaded by

wealth88
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
426 views4 pages

Unnormalized Database of Library

The document discusses normalizing an unnormalized database for a library system by removing redundant data and multi-valued attributes to eliminate anomalies, including creating separate tables for vendor phone numbers and book-vendor relationships to achieve first, second, and third normal form.

Uploaded by

wealth88
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Unnormalized database of library:

Student

Id student Name Number of books Section Id book

Library staff

id lib Name Department

Books and journals

Id book Name Author Publication

Faculty

id member Id book Name Department

Vendor of books

Id vendor Id book Company name Publication Telephone no.

Issue books

Id student Date of issue Date of return Fine


Normalization:

Normalization is the process of efficiently organizing data in the database. There are two aims
of the normalization process: eliminating redundant data and ensuring that the database design
does not suffer from any update, delete, and insert anomalies.

First normal form

In this form all the multi valued attributes are removed.

Student

Id student Name Number of books Section Id book

In this table none of attributes are multi valued. All the attributes have only single values.

Library staff

id lib Name Department

In this table also all the attributes are single valued.

Books and journals

Id book Name Author Publication

Here also all the attributes will be single valued.

Faculty

id member Id book Name Department

All the attributes have only single values here. No commas will be involved in any of the
attributes.

Vendor of books
Id vendor Id book Company name Publication Telephone no.

In this table telephone numbers can be multi valued as one vendor can have more than one
phone number. Hence separate table has to constructed so as to remove the redundant data
tables from the database.
Id vendor Id books Company Publication
Id vendor Telephone no. name

Second normal form:

The data tables are already in second form as all the non key attributes are fully functional on
the primary keys.

Third normal form

This database is in third normal form as there is no transitive dependency. All the non key
attributes are only dependent on the key attributes.

EIS PROJECT

(LIBRARY SYSTEM)
Name: Harsha Babry

Enrl no.: 09BS0000851

Section: F

You might also like