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

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

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

Course:Bachelor Of Business Information Technology

Institution: Kenya Methodist University question papers

Exam Year:2015

DATABASE SYSTEMS B(BBIT 232) (CISY 221) (DBIT 221) (DCIS 106) 3RD TRIMESTER 2015
KENYA METHODIST UNIVERSITY

END OF 3'rd 'TRIMESTER 2015 (FT) EXAMINATION

FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : COMPUTER SCIENCE
UNIT CODE : BBIT 232/CISY 221/DBIT 221/DCIS 106
UNIT TITLE : DATABASE SYSTEMS
TIME : 2 HOURS

INSTRUCTIONS:

Answer question One and any other two questions
Question One

Explain the following terms as used in databases.
(5 marks)
Database
Database management systems (DBMS)
Tuple
Attribute
Distinguish between a database Administrator and a data administrator.
(2 marks)
Outline five duties of a data base administrator.
(5 marks)
Identify and explain five categories of database users.
(5 marks)
Explain the main functions of a DBMS.
(8 marks)
Outline five disadvantages of database systems.
(5 marks)

Question Two

Discuss the following database terms:
(6 marks)
Application program
Data independence
Views
Describe the functions that should be provided by a modern full-scale multi-user DBMS.
(9 marks)

Question Three

Discuss each of the following concepts in the context of the relational data model.
(5 marks)
Relation
Domain
Relational database
Discuss the properties of a relational table.
(7 marks)
What is a foreign key? How do foreign keys of tables relate to candidate keys
(3 marks)

Question Four

Explain the function of the following clauses in the select statement.
(5 marks)
FROM
WHERE
GROUP BY
SELECT
ORDER BY
Briefly describe the stages of the database system development life cycle. (DDLC)
(7 marks|)
Explain three database views
(3 marks)

More Question Papers

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

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

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams

Return to Question Papers

Quick Links