-
DBMS Tutorial
- dbms-tutorial
- what-is-database
- types-of-databases
- what-is-rdbms
- dbms-vs-rdbms
- dbms-vs-file-system
- dbms-architecture
- three-schema-architecture
- data-models
- data-model-schema
- data-independence
- dbms-language
- acid-properties-in-dbms
Data modeling
- er-model-concept
- notation-for-er-diagram
- er-design-issues
- mapping-constraints
- dbms-keys
- dbms-generalization
- dbms-specialization
- dbms-aggregation
- convert-er-into-table
- relationship-of-higher-degree
Relational data Model
- relational-model-concept
- relational-algebra
- join-operation
- integrity-constraints
- relational-calculus
Normalization
- functional-dependency
- inference-rule
- dbms-normalization
- dbms-1nf
- dbms-2nf
- dbms-3nf
- dbms-bcnf
- dbms-4nf
- dbms-5nf
- relational-decomposition
- multivalued-dependency
- join-dependency
- inclusion-dependence
- canonical-cover
Transaction Processing
- transaction
- transaction-property
- states-of-transaction
- dbms-schedule
- testing-of-serializability
- conflict-schedule
- view-serializability
- recoverability-of-schedule
- failure-classification
- log-based-recovery
- dbms-checkpoint
- deadlock-in-dbms
Concurrency Control
- concurrency-control
- lock-based-protocol
- time-stamping-protocol
- validation-based-protocol
- thomas-write-rule
- multiple-granularity
- recovery-concurrent-transaction
File organization
- file-organization
- sequential-file-organization
- heap-file-organization
- hash-file-organization
- b+-file-organization
- dbms-isam
- cluster-file-organization
Indexing and B+ Tree
Hashing
RAID
Misc
- 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
SQL Introduction
- sql-introduction
- characteristics-of-sql
- advantage-of-sql
- sql-datatype
- sql-command
- sql-operator
- sql-table
- sql-select-statement
- sql-insert-statement
- sql-update-statement
- sql-delete-statement
- sql-view
- sql-index
- sql-sub-queries
- sql-clauses
- sql-aggregate-function
- sql-join
- sql-set-operation
DBMS MCQ
Interview Questions
AggregationIn aggregation, the relation between two entities is treated as a single entity. In aggregation, relationship with its corresponding entities is aggregated into a higher level entity. For example: Center entity offers the Course entity act as a single entity in the relationship which is in a relationship with another entity visitor. In the real world, if a visitor visits a coaching center then he will never enquiry about the Course only or just about the Center instead he will ask the enquiry about both.  Next TopicDBMS Convert ER into table
|