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

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)

Database Design And Management(Bsis 315) Question Paper

More Question Papers

Popular Exams