Define database management system (2mks) Define the terms (4mks) Physical schema Logical schema . Define data model
Question:
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).
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi