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
Exams With Marking Schemes
Popular Exams
Mid Term Exams
End Term 1 Exams
End Term 3 Exams
Opener Exams
Full Set Exams
Return to Question Papers