Bbit 107 Database Management Systems Question Paper
Bbit 107 Database Management Systems
Course:Bachelor Of Science In Information Technology
Institution: Kca University question papers
Exam Year:2014
1
UNIVERSITY EXAMINATIONS: 2013/2014 ORDINARY EXAMINATION FOR THE BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY BBIT 107 DATABASE MANAGEMENT SYSTEMS (DISTANCE LEARNING) DATE: APRIL, 2014 TIME: 2 HOURS INSTRUCTIONS: Answer Question ONE and any other TWO QUESTION ONE: [30 Marks]
a) Define the following terms as used in database design and development.
i). Database [1 Mark]
ii). Data management [1 Mark]
iii). Knowledge [1 Mark]
iv). Information [1 Mark]
b) Describe any THREE ways of classifying databases. [6 Marks]
c) Describe SIX functions of a database administrator. [6 Marks]
d) Discuss THREE applications of distributed databases. [3 Marks]
e) Discuss any TWO security threats of a database system. [4 Marks]
f) Discuss the components of database environment. [5 Marks]
g) Describe the term data definition language (DDL). [2Marks]
QUESTION TWO: [20 MARKS]
a) Discuss THREE advantages and THREE disadvantages of object oriented database models. [6 Marks]
2
b) Using your knowledge on object oriented database models and the case below answer the questions that follow.
In a truck management system, each truck is assigned a driver .Each truck is used to carry cargo to different destinations. The cargo consists of assortment of items. A driver can only drive one truck at a time.
i). Identify the objects in this case. [3 Marks]
ii). Identify three attributes for each object [3 Marks]
iii). For each object identify at least three operations [3 Marks]
iv). Draw an object diagram [5 Marks]
QUESTION THREE: [20 MARKS]
a) Describe FOUR functions of a database management system (DBMS). [4 Marks]
b) Describe the THREE levels of database architecture. [6 Marks]
c) Discuss THREE components of a database management system (DBMS). [6 Marks]
d) Explain FOUR factors considered when selecting database management system (DBMS). [4 Marks]
QUESTION FOUR: [20 MARKS]
a) Discuss THREE functions of a database view. [3 Marks]
b) Given the following relations use appropriate SQL statements to:
Department CourseNo DepartmentName D01 Human Resource D03 Marketing D09 Sales D08 Operations D04 Customer relations
Employee EmpNo FirstName MidName SurName Age Gender DeptNo 0120 John Christopher Oduor 23 Male D01 0122 James John Ochieng 25 Male D01 0123 Janet Adhiambo Oduor 27 Female D03 0125 Fredrick Otieno Omollo 29 Male D09 0128 Festus Omimo Odhiambo 28 Male D09 0129 Faith Awuor Oduor 29 Female D04
3
0134 Henry Denis Wekesa 27 Male D03 0133 Henry Joshua Kamau 28 Male D04 0145 Peter Kamau Njogu 30 Male D03 0156 Mary Wambu Njogo 32 Female D03 0167 Peris Mumbua Mutia 23 Female D01 0166 Anita Kimotho Mwangi 22 Female D04 0129 Faith Awuor Oduor 29 Female D04
i). Display mean age of all the employees [2 Marks]
ii). Display the employee(s) whose first name begins with F and age is not 29.
[4 Marks]
iii). Display employee details if they do not work in human resource department.
[3 Marks]
iv). Create a view named employee departments to display full name and department name [4 Marks]
v). Insert a new record in the employee table. [4 Marks]
QUESTION FIVE: [20 Marks]
a) Define the term normalization with respect to logical design. [2 Marks]
b) Describe three anomalies that are associated with bad database design. [6 Marks]
c) Use the form below to normalize it to third normal form. [6 Marks] Order Form Order number: 12000 Date: 11/04/2013 Customer number: 9000 Customer name Kenga Customer address 400 Thika Road City-country Nairobi, Kenya ProductNo Description Quantity Unit Price A003 Book 200 Kshs 400.00 B004 Soda 300 Kshs 500.00 C002 Salt 400 Kshs 200.00
d) Describe the following functional dependencies.
i). Transitive dependency [3 Marks]
ii). Partial dependency [3 Marks]
More Question Papers
Exams With Marking Schemes