Functions of DBMS DBMS provides several functionalities, which are discussed below: 1. Data Storage Management Creating…

Database  Recovery Techniques  After a failure or corruption, database recovery is the process of returning a database …

Automatic Storage Management Automatic Storage Management (ASM), an Oracle Database feature, simplifies storage managem…

A schedule is the sequence of actions that connects one transaction to the next. Scheduling is the process of schedulin…

Locking in Concurrency  Control A variable that is connected with a data item and specifies the item's current stat…

Relational Calculus In DBMS, Relational Calculus is a unique technique to query creation. Relational calculus in DBMS i…

Relational Algebra   Relational algebra is a procedural query language that accepts instances of relations and returns …

Indexes SQL indexes are specialized lookup tables that help the database search engine get data faster.  In simple word…

Normalization The process of arranging data in a database is called normalization. It involves creating tables and inte…

Integrity Constraints Integrity constraints are guidelines that support maintaining the consistency and correctness of …

ER Model  ER Model stands for Entity-Relationship Model. A diagram is used in an entity-relationship model to show the …

Weak Entity Types  Entity types  An entity type is a grouping of entities that share common characteristics. A corporat…

Attribute in DBMS An entity is any object or thing that can be distinguished from other objects in a database managemen…