DATA MODELING – NORMALISATION for LIBRARY
Data Normalization is a process in which data attributes within a data model are organized to increase the cohesion of entity types. In other words, the goal of data normalization is to reduce and even eliminate data redundancy, an important consideration for application developers because it is incredibly difficult to stores objects in a relational database that maintains the same information in several places.In case of library there are various data attributes which need to be organised in a proper order which will make its function easy and understandable. An Initial Data Schema for Library
| Student Roll No. |
| E- mail |
| Student Name |
| Phone no. |
| Late Fine Outstanding |
| Book Title |
| Book Author |
| Book ISBN |
| Book Price |
| Library Catalogue No. |
| Quality of Copy |
| Date of Issue |
| Date of Return |
| Student Roll No. (PK) |
| Name |
| E- mail |
| Phone No. |
| Late Fine Outstanding |
| Student Roll No. (FK) |
| Book ISBN No. (PK) |
| Library Catalogue No. (FK) |
| Book Title |
| Book Author |
| Book Price |
| Library Catalogue No. (PK) |
| Date of Issue |
| Date of Return |
| Book Quality |
the book is not issued, the copy of the book is issued !!
prithwis
February 17, 2008