Database Management System Books
Recommended Books By Gate Vidyalay
|
Why You Should Read Book By Raghu Ramakrishnan?
Database Management System Books
Database Management System Notes
ER Diagrams-
- ER Diagrams | ER Diagram Symbols
- Entity Sets in DBMS | Strong and Weak entity set
- Relationship Sets
- Cardinality in ER Diagram
- Participation Constraints | Total and Partial participation
- Types of Attributes
- Converting ER Diagram to Tables | Rules for Conversion
- Problems On Converting ER Diagrams to Tables
Constraints-
Keys-
- Closure of an Attribute Set | Steps to Find Closure
- Concept of Keys | 10 Different Keys in DBMS
- Finding Candidate Keys of Given Relation
Functional Dependency-
- Concept of Functional Dependency
- Functional Dependencies Equivalence
- Canonical Cover of Functional Dependencies
Decomposition-
- Decomposition of a Relation | Lossless and Lossy Decomposition
- Conditions to Check whether Decomposition Is Lossless Or Lossy
Normalization-
Transactions-
- Transaction in DBMS | Transaction States
- ACID Properties of Transaction
- Concurrency Problems in Transactions
Schedules-
- Types of Schedules | Finding Number of Schedules
- Serializability in DBMS | Conflict Serializability
- Problems On Conflict Serializability
- View Serializability
- Problems On View Serializability
- Recoverability | Recoverable and Irrecoverable Schedules
- Cascading Rollback | Cascadeless Schedules | Strict Schedules
- Equivalence of Schedules | Practice Problems
Relational Algebra-
- Introduction to Relational Algebra | Relational Algebra Operators
- Selection Operator
- Projection Operator
- Set Theory Operators | Union, Intersection, Difference
More Articles Coming Soon…Subscribe To Receive Email Notifications!