-
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
Notation of ER diagramDatabase can be represented using the notations. In ER diagram, many notations are used to express the cardinality. These notations are as follows:  Fig: Notations of ER diagram Next TopicDBMS Mapping constraints
|