What is an ER model?

ER model stands for Entity-Relationship Model. It is a high-level data model diagram which defines the conceptual view of the database. It is a blueprint or design of a database that will be used to implement a database in the …

Read moreWhat is an ER model?

DBMS Languages

User can access, update, delete, and store data or information in the database using database languages. The following are the databases languages in the database management system: Data Definition Language Data Manipulation Language Data Control Language Transaction Control Language Data …

Read moreDBMS Languages

DBMS Schema

Schema It is a physical representation of data that appears in the database management system.  In simple words, a schema is the structure of any database. It defines how the data is stored in a database and relationship among those …

Read moreDBMS Schema

Types of DBMS

Types of DBMS There are four types of database management system (DBMS) based on the data models, which are as follows: Hierarchical Database Management Systems Relational Database Management Systems Network Database Management Systems Object-oriented Database Management Systems 1. Hierarchical Database …

Read moreTypes of DBMS

Applications of DBMS

Applications of DBMS There are various fields where a database management system is used. Following are some applications which make use of the database management system: 1. Railway Reservation System: In the railway reservation system, the database is required to …

Read moreApplications of DBMS

Components of DBMS

Components of DBMS There are the following components of DBMS: Software Hardware Procedures Data Users Software The main component of a Database management system is the software. It is the set of programs which is used to manage the database …

Read moreComponents of DBMS