This one assignment is ready my good friend...
Normalization and its Example
Normalization is a way of organizing the data efficiently in a database. A normalized
data is considered to be primary requirement of good database design. It manages tables
in a way that minimizes redundancy and data dependency. It involves breaking down the
large tables into smaller ones. Normalization is needed for accurate representation of
data, relationships and constraints. It involves conducting series of tests on relations to
find out whether it fulfills or infringes the requirements of normal forms. Main reason
for normalization is to prevent possible corruption of data that can arise from insert,
delete and update anomalies.
Database is normalized after logical modeling but prior to physical phase of database
First Normal Form: A database table is said to be in First normal form when it does not
contain any repeating group i.e. when it doesn’t contain any multi-valued attribute.
For example, Considering an ERD for database of books (College Library) rented out
maintained by some library which contains Customer ID, Full Name, Address and books
Here, Books Rented is multi-valued attribute as one customer can take more than one
book. Therefore, to be in first normal form, each field shou...