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 …

Distributed Concurrency Control:

Concurrency control involves the synchronization of accesses to the distributed database, such that the integrity of the database is maintained.The alternative solutions are pessimistic and optimistic.

Distributed DBMS

Distributed DBMS is then defined as the software system that permits the management of the distributed database and makes the distribution transparent to the users.Distributed database are much complex than centralized environment. Data is remotely available at different sites so Read More …