When designing a database using normalization what kind of p

When designing a database using normalization, what kind of problems can you expect?

Solution

Normalization is basically to design a database schema such that duplicate and redundant data is avoided. If some piece of data is duplicated several places in the database, there is the risk that it is updated in one place but not the other, leading to data corruption.

without normalization, database systems can be inaccurate, slow, and inefficient, and they might not produce the data you expect.

The following are the three most common normal forms in the normalization process:

The first normal form

The second normal form

The third normal form

please check the link for above Normal forms

http://www.studytonight.com/dbms/database-normalization.php

When designing a database using normalization, what kind of problems can you expect?SolutionNormalization is basically to design a database schema such that dup

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site