Define the term database management system (DBMS).

Identify three characteristics of logical schema.

Outline the purpose of a data definition language (DDL).

Identify two tasks that a database administrator carries out to ensure the security of the database.

Award up to [1 max].
A database management system (DBMS) is a set of programs that allows to read, store, change /extract data in a database;

Award up to [3 max].
Award [1] for each characteristic of logical schema identified up to [3 max].
All attributes for each entity in database are specified;
The primary key for each entity is identified;
Includes all entities and relationships among them;
Keys identifying the relationship between different entities (foreign keys) are specified;
Normalization occurs at logical level;

Award up to [2 max].
Award [1] for each identifying the role of Data Definition Language (DDL) and [1] for an expansion or explains how it may be used up to [2 max].
The Data Definition Language (DDL) are commands which define the different structures/objects in a database;
Database administrators use these commands during the setup and/or removal of a database and database objects (such as tables, indexes, and users);

Award up to [2 max].
Award [1] for each task that a database administrator carries out to ensure the security of the database up to [2 max].
DBA sets access levels and passwords;
DBA manages back-up procedures (allow examples of this);
DBA establishes a recovery plan for the database in disaster case;