More about Database Management System (DBMS)
{tocify} $title= {Table of Contents}
More about Database Management System (DBMS)
Misc
- Function and Services of DBMS
- Decomposition Algorithms
- Storage System in DBMS
- Data Dictionary Storage
- File Organization Storage
- Selection of RAID Levels
- Bitmap Indexing
- Buffer Replacement Strategies
- Database Buffer
- Estimating Query Cost
- Query Processing in DBMS
- Evaluation of Expressions
- External Sort-Merge Algorithm
- Hash Join Algorithm
- Materialization in Query Processing
- Merge Join Algorithm
- Nested-Loop Join Algorithm
- Selection Operation in Query Processing
- Double-Pipelined Join Algorithm
- Implementation of Pipelining
- Pipelining in Query Processing
- Advanced Query Optimization
- Transforming Relational Expressions
- Candidate Key
- Closure of an Attribute
- QUESTIONS ON BOYCE CODD NORMAL FORM
- QUESTIONS ON NORMALIZATION
- QUESTIONS ON THIRD NORMAL FORM
- EQUIVALENCE OF FUNCTIONAL DEPENDENCY
- Referential Integrity constraint
- Questions on Lossy and Lossless Decomposition
- LOSSY OR LOSSLESS DECOMPOSITION (second method)
- QUESTIONS TO IDENTIFY NORMAL FORM
- Types of Relationship in Database Table
- Candidate Key in DBMS
- Primary Key in DBMS
- Super Key in DBMS
- Alternate Key in DBMS
- Composite Key in DBMS
- Foreign Key in DBMS
- Surrogate Key in DBMS
- Unique Key in DBMS
- Purpose of Normalization
- COMMIT vs ROLLBACK in SQL
- DDL vs DML
- Denormalization in Databases
- ER Model vs Relational Model
- Database Security
- Problems with ER Model
- Advantages of Database Management System (DBMS)
- Advantages and Disadvantages of Database Management System (DBMS)
- COMMIT Protocol in DBMS
- Anomalies in DBMS
- DBMS Examples
- Entity in DBMS
- Characteristics of Database Management System (DBMS)
- Components of Database Management System (DBMS)
- Disadvantages of DBMS
- Instance and Schema in DBMS
- Data Abstraction in DBMS
- Applications of DBMS
- Redundancy in DBMS