Explain the functions of a database management system.

How to lay out the answer. Follow the frame, then write it in your own words.

1 · Define and give examples. A DBMS is software that creates, manages and controls access to a database, e.g. Access, Oracle, MySQL.
2 · Definition and manipulation. Creates tables and relationships; adds, changes, deletes and retrieves data, usually with SQL.
3 · Security and integrity. User accounts and access rights; validation rules and referential integrity keep data correct.
4 · Concurrency, backup and recovery. Many users can work at once safely; data can be restored after a failure.
5 · Data dictionary. Keeps metadata: field names, types and relationships.
6 · Sri Lankan business example. A bank's server DBMS serves branches, ATMs and the mobile app from one set of accounts.

Scoring tip: Name each function and add one line on why the business needs it.