Get premium membership and access revision papers, questions with answers as well as video lessons.

Database Management (Bbit 232) (Cisy 221) 2Nd Trimester 2015 Question Paper

Database Management (Bbit 232) (Cisy 221) 2Nd Trimester 2015 

Course:Bachelor Of Business Information Technology

Institution: Kenya Methodist University question papers

Exam Year:2015



DATABASE MANAGEMENT (BBIT 232) (CISY 221) 2ND TRIMESTER 2015
KENYA METHODIST UNIVERSITY

END OF 2'ND 'TRIMESTER 2015 (FT) EXAMINATION

FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : COMPUTER SCIENCE & BUSINESS INFORMATION
UNIT CODE : BBIT 232/CISY 221/BSIS 115/DBIT 221/DCIS 106
UNIT TITLE : DATABASE MANAGEMENT
TIME : 2 HOURS


Instructions: Answer question one and any other two.

Question One

State and explain the advantages of database management systems in organizations.
(5mks)
Define the terms below and give examples.
Data
Field
Record
Relationship
Primary key
(5mks)
State any five roles of a database administrator in on organization. (5mks)
Given the following rules, create an appropriate entity relationship diagram. (5mks)
A company has many department
Each department employs one or more employees
Each employee has one or more dependants
Each employee has an employment history
Describe the three layered architecture of a database management system.
(5mks)
Using Ms Access 2007 as an example, explain the concept of a relational database.


(5mks)
Question Two

Explain the following database concepts, give examples,
Table
Attribute
Normalization
Data types
(10mks)
Ms Access has three main views namely datasheet view, design view and form view. Explain each of these views.
(10mks)


Question Three

Why is it necessary to set the data types in Ms Access? Give examples of the data types in Access.
(10mks)
State and describe some of the security mechanisms that the DBA can use to safeguard data in an organization.
(10mks)


Question Four

State and explain the characteristics of a good database management system.
(10mks)
Briefly explain the different activities that can he performed during database management.
(10mks






More Question Papers


Popular Exams


Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams



Return to Question Papers