Author Archives: Sumit Thakur
PURPOSE OF NORMALIZATION: Why It Is Used So Much?
PURPOSE OF NORMALIZATION: Why It Is Used So Much? Data normalization rearranges data in a database so users can use it for further querying and analysis. Put simply, it is…
Data Abstraction in DBMS? Examples, Levels, Advantages and Disadvantages
Data Abstraction in DBMS? Examples, Levels, Advantages and Disadvantages: Do you often wonder why few websites bring different uses for different users? Just take the example of a school website…
Shadow Paging in DBMS? Example, Advantages, Disadvantages
Shadow Paging in DBMS? Example, Advantages, Disadvantages: The process of recovering data in a database management system is known as Shadow Paging. It is a recovery technique where the transactions…
What is RAID in DBMS: 7 Levels with Advantages and Methods
What is RAID in DBMS, 7 Levels with Advantages and Methods: RAID, fully abbreviated as Redundant Array of Independent Disk uses different small and low-cost drives to be transformed into…
File Organization in DBMS: Types with Advantages and Importance
File Organization in DBMS: Types with Advantages and Importance: The File Organization can be defined as the logical relationships between different records in the file. It is mainly related to…
Aggregation in DBMS: Types, Example, Techniques and Importance
Aggregation in DBMS: Types, Example, Techniques and Importance: Aggregation can be defined as a procedure for combining multiple entities into a single one. In database management, it is a design…
Metadata in DBMS, Types and Importance
Metadata in DBMS, Types and Importance: Metadata can be defined as the complete context of data in DBMS that assists in organizing, identifying, and understanding it. In simple language, it…
35 Examples of Popular Database Management Systems (DBMS)
35 Examples of Popular Database Management Systems (DBMS): There are lots of examples of Database Management Systems (DBMS) and all over the world these are widely used by companies. Big…
Generalization in DBMS with Example
Generalization in DBMS with Example: An extended ER diagram has features such as Specialization, Generalization, and Aggregation. In the previous tutorial, we have covered Specialization. Now, let us proceed to…
Specialization in DBMS: Definition, Examples and its Need
Specialization in DBMS: Definition, Examples and its Need: A simple Entity Relationship (ER) diagram represents the relationship of various entities which are stored in a database. Likewise, an Extended Entity…