Define database management system (2mks)

Define the terms (4mks)

Physical schema

Logical schema.

Define data model? State and explain any THREE database models known to you (7mrks).

Define the following terms as used in databases (10mks).

Database

Super Key.

Primary Key.

Field

Tuple

Differentiate between Data Manipulation Language (DML) and Data Definition Language(DDL) (4mks)

What is SQL, and why is it important? (3mks)

State and explain any four advantages of using the database approach over the traditional approach(8mks).

Differentiate between the following terminologies in databases: - (4mks)

Logical data independence and physical data independence

With a well labeled diagram describe the three levels of database view (8mks).

QUESTION THREE (20 MKS).

Define data backup (2mks).

Describe the Components of DBMS (10mks).

Discuss any FOUR threats to data security (8mks).

QUESTION FOUR (20 MKS).

State and explain the ACID properties of a transaction (8mks).

Outline any FIVE functions of a database administrator (6mrks).

Explain the difference between a full, differential and incremental database backup(6mks)

QUESTION FIVE (20MKS).

Discuss each of the following database architectures listed below (12mks)

Centralized DBMS architecture

Client/server architecture

Two-tier client/server architecture

Three-tier architecture

Write an SQL command that would do each of the following(4mks)

Create a new database for bonus payments and name it BONUS

Display all records and columns from the CUSTOMER_INFO table.

Define indexing, state any three different kinds of indexing known to you (4mks).