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
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