Loading Revision Notes. Please Wait, it may take upto a minute
Functional Dependency, Trivial FD, Closure Of set of FDs, Armstrong's Axioms, Closure: Algorithm, and related Topics.
Introduction, Normalization, Purpose of Normalization, Updation Anomalies, Deletion Aomalies, NULL values, Lossy Decompostion, and other topics.
Functional Dependency, Trivial FD, Closure Of set of FDs, Armstrong's Axioms, Closure: Algorithm, and other topics.
Closure of an attribute Set, Uses of Clossure of Attribute Set, Closure of Attribute Set: Algorithm, Equivalence of FDs, Canonical Cover, Extraneous Attributes, and other topics.
Canonical Cover: Definition, Canonical Cover: Algorithm, Decomposition, Lossless Join Decomposition, Dependency Presevation Property, Dependency Preservation: Algorithm, and other topics.
Introduction, 1NF, Prime Attribute, Full Functional Dependency, 2NF, Transitive Dependency, and other topics.
3NF: Illustration, BCNF, Multivalued Dependency, 4NF, 5NF, and other topics.
Distributed Computing System, Distributed DB, Distributed Database, Advantages of DDBMS, Special Functions of DDBMS, Fragmentation, Horizontal, Vertical, Mixed/ Hybrid Fragmentation, Fragmentation Schema, Allocation, Allocation Schema, and other topics.
Introduction, Data Replication, Query Processing, Semi Join, Concurrency Control, Distinguish Copy Techniques, Primary Site, Primary Site with Backup, Primary Copy Technique, Selecting a Co-ordinator , Voting Based Techniques, and other topics.