Database Management System (DBMS)

How structured data is stored and managed — core DBMS terminology and the SQL language used to query it.

📖 ~4 min read 💻 RRB NTPC / Group D — Computer Awareness

A DBMS is software that manages the creation, storage, retrieval, and manipulation of data in a structured database.

Term	Meaning
Table	A structured collection of data organised into rows and columns
Primary Key	A unique identifier for each record in a table
Foreign Key	A field linking one table to the primary key of another table
SQL	Structured Query Language — used to query and manage relational databases

Relational DBMS (RDBMS): Stores data in tables with relationships (MySQL, Oracle, PostgreSQL)
Hierarchical DBMS: Data organised in a tree-like structure
Network DBMS: Data organised as a graph, allowing multiple parent-child relationships

This free chapter covers the key concepts. For complete coverage with 500+ MCQs, mock tests, and previous year analysis — grab the premium eBook.