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


Popular Exams


Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams



Return to Question Papers