Author Archives: Sumit Thakur - Page 2
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…
Pagination in SQL Server, MySQL and Oracle with Examples
Pagination in SQL Server, MySQL and Oracle with Examples: Often, while working with the application with a huge result set in the backend, it is not desired to display all…
Structure of DBMS: Users and Interfaces with Diagram
Structure of DBMS (Database Management System): Users and Interfaces with Diagram: A DBMS – Database management system is a complex software system that stores a huge amount of data and…
What is Schedule in DBMS? Types, Advantages, Disadvantages
What is Schedule in DBMS? Types, Advantages, Disadvantages: In DBMS, the schedule is the sequence following which the instruction of transactions will be performed. It is a process using which…
Decomposition in DBMS? Types, Advantages, Properties, Issues
Decomposition in DBMS? Types, Advantages, Properties, Issues: Decomposition can be defined as a database management system process for dividing a single relation into multiple sub-relations. Its main purpose is to…
What is Serializability in DBMS? Types, Advantages, and Significance
What is Serializability in DBMS? Types, Advantages, and Significance: Serializability can be called a process used for finding the correct non-serial schedules in the database. It basically helps maintain the…