Normalization

Normalization transforms arbitrary relation schemes into ones without these problems. A relation with one or more of the above mentioned anomalies is split into two or more relations of a higher normal form.Normal Forms Normalization is basically; a process of Read More …

Normalization

Eliminate various anomaliesRepetition anomaly, Update anomaly, Insertion anomaly, Deletion anomaly.The normal forms are based on certain dependency structures. BCNF and lower normal forms are based on functional dependencies (FDs), 4NF is based on multivalued dependencies, and 5NF is based on Read More …

Transparent Management of Distributed and Replicated Data

Transparency refers to separation of the higher-level semantics of a system from lower-level implementation issues. In other words, a transparent system “hides” the implementation details from users. The advantage of a fully transparent DBMS is the high level of support Read More …