Introduction
A database is an organized, persistent collection of related data that models some part of the real world (students, accounts, flights). A Database Management System (DBMS) is the software that lets you define, store, retrieve, update, and control access to that data safely and efficiently — examples are Oracle, MySQL, PostgreSQL, SQL Server and MongoDB.
This topic — DBMS Concepts and Architecture — is the foundation of the entire subject. In BCS, Bank IT/AGM-IT, and IT-officer written and MCQ exams, questions from here appear almost every year: the definition of a DBMS, the three-schema (ANSI/SPARC) architecture, data independence, data abstraction levels, DBMS vs file system, the role of the DBA, and the data models. Master this lesson and you can answer both the direct-recall MCQs and the short-note/explanation questions.
Learning objectives
By the end of this lesson you should be able to:
- Define data, database, DBMS, schema, instance, and metadata precisely.
- Explain why a DBMS is superior to traditional file-processing systems.
- Describe the three levels of data abstraction and the three-schema architecture (internal, conceptual, external).
- Distinguish logical and physical data independence and give examples.
- List and compare the major data models (relational, hierarchical, network, ER, object, NoSQL).
- Identify database languages (DDL, DML, DCL, TCL, DQL) and their commands.
- Explain DBMS system architecture (2-tier, 3-tier), the query processor, storage manager, and the roles of DBA, designers, and end users.
- Describe database users, and the client/server structure.