Database Design And Management(Bsis 315) Question Paper
Database Design And Management(Bsis 315)
Course:Information Science
Institution: Kenya Methodist University question papers
Exam Year:2010
TIME : 2 HOURS
INSTRUCTIONS Answer THREE Questions in Section A and TWO Questions in Section B
SECTION A
Question 1
Explain the following terms
a) Database
b) Database system
c) Data models
d) Database design
e) Entity- relationship diagram (10marks)
Question 2
Explain the participants in a database environment. (10marks)
Question 3
Briefly discuss TEN benefits of a database technology. (10marks)
Question 4
Using illustrations where necessary, explain the elements of a database. (10marks)
SECTION B
Question 5
Using an illustration discuss the stages in the database systems development cycle (20marks)
Question 6
Use an entity-relationship diagram to depict the following requirements for a library.
• The library employs a number of librarians. A record is kept of each librarian`s name, address, phone number and salary. • Each librarian can work in either section in the library. The Name of the section either shelving or front desk is recorded.
• The front section constitutes of lending in terms of Borrower name, book author, Date borrowed and return date.
• The shelving section involves arranging books according to their disciplines of use e.g. information science, BBIT, Health science, Computer science, Business Administration.
State any assumptions made in the design of the E-R diagram (20marks)
Question 7
a) Data warehouses and their architecture vary depending upon the specifics of an organizations situation. Using illustrations discuss three common architectures (15marks)
b) Explain the components of a data ware house (5marks)
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