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

Database Systems B(Bbit 232) (Cisy 221) (Dbit 221) (Dcis 106) 3Rd Trimester 2015

Database Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit221) (Dcis106) 1St Trimester 2016

Bbit 232 Cisy221 Comp 340 Bsis 115 Dbit221 Dcis106 ( Database Systems) 2 Trimester 2016

Database Systems(Bbit 232 )(Cisy 221)( Dbit 221)( Dcis 200)3Rd Trimester 2016

Database Management Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit 221) (Dcis106)1St Trimester 2017

Computer Operating System I (Cisy 300) (Bbit 213) 1St Trimester 2014

Operating Systems (Cisy 300) (Bbit 213) 2Nd Trimester 2014

Computer Operating Systems (Cisy 300) (Bbit 213) 3Rd Trimester 2014

Computer Operating Systems (Bbit 213) (Cisy 300) 1St Trimester 2015

Computer Operating Systems I (Cisy 300) (Bbit 213) 2Nd Trimester 2015

Operating Systems (Bbit 213) (Cisy 300) 3Rd Trimester 2015

Computer Operating Systems (Cisy 300) (Bbit 213) (Dcis 201) (Dbit 210) 1St Trimester 2016

Bbit 213/ Cisy 300(Computer Operating System )(2 Trimester 2016) Full Time

Bbit 213:Computer Operating System End Of 3Rd Trimester 2016

Bbit 213: Operating Systems I (Cisy 300) 2Nd Trimester 2012

Computer Operating Systems (Cisy 300) (Bbit 213) 1St Trimester

Introduction To Computer Networks (Bbit 241) (Cisy 131) 1St Trimester 2014

Introduction To Computer Networks (Bbit 241) (Cisy 131) 2Nd Trimester 2014

Introduction To Computer Networks (Cisy 131) (Bbit 241) 3Rd Trimester 2014

Introduction To Computer Networks (Bbit 241) (Dbit 223) (Dcis 121) (Cisy 131) 1St Trimester 2015

Introduction To Computer Networks (Cisy 131) (Bbit 241) (Dbit 223) (Dcis 121) 2Nd Trimester 2015

Introduction To Computer Networks (Bbit 241) (Cisy 131) 3Rd Trimester 2015

Computer Networks (Bbit 241) (Cisy 131) (Dbit 223) (Dcis 121) 1St Trimester 2016

Bbit 241 Cisy 131 (Computer Networks / Telecommunication Networks)(2 Trimester 2016)

Object Oriented Programming (Cisy 210) (Bbit 223) 1St Trimester 2014

Object Oriented Programming (Bbit 223) (Cisy 210) (Dcis 120) 2Nd Trimester 2014

Object Oriented Programming (Bbit 223) (Cisy 210) 3Rd Trimester 2014

Object Oriented Programming (Cisy 210) (Bbit 223) 1St Trimester 2015

Object Oriented Programming (Bbit 223) (Cisy 210) 2Nd Trimester 2015

Object Oriented (Bbit 223) (Cisy 210) (Dcis 120) 3Rd Trimester 2015

Object Oriented Programming (Bbit 223) (Cisy-210) (Dcis-210) 1St Trimester 2016

Object Oriented Programming(Bbit 223)( Cisy 210)(Dcis 210) 3Rd Trimester 2016

Computer Networks (Bbit 241) (Cisy 131) (Misc 434) ( Bict 323) ( Dbit 223 ) (Dcis 121) 1St Trimester 2017

Sociology (Sost 131) 1St Trimester 2014

Introduction To Sociology (Sost 131) 2Nd Trimester 2014

Introduction To Sociology (Sost 131) 3Rd Trimester 2014

Introduction To Sociology (Sost 131) 1St Trimester 2015

Introduction To Sociology (Sost 131 ) 2Nd Trimester 2015

Introduction To Sociology (Sost 131) 3Rd Trimester 2015

Introduction To Sociology (Sost 131) Pt 1St Trimester 2016

Introduction To Sociology(Sost 131)2Nd Trimester 2016

Introduction To Sociology (Sost 131) 3Rd Trimester 2016

Introduction To Sociology (Sost 131) 3Rd Trimester 2013

Introduction To Sociology (Sost 131) 2Nd Trimester 2013

Telecommunication Network (Bbit 242) (Cisy 231) 1St Trimester 2014

Telecommunication Networks (Bbit 242) (Cisy 231) 2Nd Trimester 2014

Telecommunication Networks (Bbit 242) (Cisy 231) 3Rd Trimester 2014

Telecommunication Networks (Bbit 242) (Cisy 231) 1St Trimester 2015

Telecommunication Networks (Bbit 242) (Cisy 231) 2Nd Trimester 2015

Telecommunication Networks (Bbit 242) (Cisy 231) 3Rd Trimester 2015

Popular Exams

Return to Question Papers

Quick Links