Database management systems and SQL

A database management system is software that stores, organises, retrieves and protects data for many users and applications. In recruitment-level questions, DBMS is contrasted with the traditional file-processing system. File systems commonly suffer from redundancy, inconsistency, poor sharing, difficult security control and weak recovery after failure. A DBMS solves these by keeping a managed database, a data dictionary, query processing, authorisation rules, backup and recovery facilities, and transaction management in one controlled environment.

The ANSI/SPARC three-schema architecture is a high-yield frame. The internal level describes physical storage, indexes and access paths. The conceptual level describes the whole logical database, including entities, attributes, relationships and constraints. The external level describes user views, so one clerk, teacher or analyst may see only a relevant slice. Physical data independence means changing storage without changing the logical design; logical data independence means changing the conceptual schema without breaking external views. A Rajasthan recruitment portal, for example, can expose separate views for applicant status, payment reconciliation and centre allocation while protecting the same core records.

Exam cue: DBMS questions often test the difference between stored data, metadata, schema, instance, data independence and the weakness of ordinary files.