Characteristics / Advantages of Normalisation :-
After successful completion of normalisation proces resultant relation R Shows following Characteristic advantages-
(i) Normalised relation doesn't have data redundency and inconsistency problem.
(ii) Normalised relation is very simple, clear and easy to understand and it will also represent database objects and their relationships.
(iii) Normalised database returns Very fast and hundred percent accurate results against any user's query, it means it will increase the performance of database upto several times.
(iv) Normalised database utilizes memory space of computer.
(v) Normalized database is free from all types of Anomalies like multi attribute, partial functional dependency, Transitive functional dependency, determinant problem,
multi-value dependency (mvd) and join dependency.
No comments:
Post a Comment