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

Bmit 216 2009/2010 Academic Year Question Paper

Bmit 216 2009/2010 Academic Year

Course:Bachelor Of Business Management And Information Technology

Institution: Kabarak University question papers

Exam Year:2010

COURSE CODE: BMIT 216
COURSE TITLE: DATABASE MANAGEMENT SYSTEMS
STREAM: Y2S1

INSTRUCTIONS:
i. SECTION A is Compulsory
ii. Attempt any other THREE questions from SECTION B

SECTION A
QUESTION ONE
a. What are the responsibilities of a DBA? (4 Marks)
b. Define the following terms: - (4Marks)
i. Entity
ii. Attribute
iii. Schema
iv. Domain
c. Consider the following information about a university database: (5 Marks)
i. Professors have an SSN, a name, an age, a rank, and a research specialty.
ii. Departments have a department number, a department name, and a main office.
iii. Departments have a professor (known as the chairman) who runs the department.
iv. Professors’ work in one or more departments and for each department that they work in, a
time percentage is associated with their job.
Design and draw an ER diagram that captures the information about the university. Use only
the basic ER model here; that is, entities, relationships, and attributes. Be sure to indicate any
key and participation constraints.
d. What are the benefits of prototyping over waterfall development process (4 Marks)
e. Describe the different elements of a data flow diagram (4 Marks)
f. Define the following terms:- (3 Marks)
i. Foreign key
ii. Views
iii. Triggers
g. List the different data types in SQL server (5 Marks)
h. Differentiate between set operators and unary operators with examples (3 Marks)
i. Explain the following: - (8 Marks)
i. Normalization
ii. Entity integrity
iii. Data manipulation language
iv. Data warehousing

SECTION B

QUESTION TWO
a. Explain five functions of DBMS (5 Marks)
b. Why would one employ views in DBMS? (3 Marks)
c. Explain the different join operators (5 Marks)
d. What are the benefits of interviews over Questionnaire (5 Marks)
e. Explain the different users of database (2 Marks)

QUESTION THREE
a. As a DBA of an organization explain why would you choose database system over storing
data in operating system files? (5 Marks)
b. What are the problems associated with data warehousing (5 Marks)
c. Explain the following:- (5 Marks)
i. Concurrency
ii. Serializability
iii. Exclusive lock
iv. Distributed processing
v. Relation

d. Is web the best platform for DBMS? Explain why? (5 Marks)

QUESTION FOUR
a. Explain the ANSI-SPARC DB architecture (5 Marks)
b. Sailor’s relation
Sid S_name Rating Age
18 Jones 3 30
41 Jonah 6 56
22 Ahab 7 44
63 Moby null 15

Write SQL queries to compute the average rating, using AVG; the sum of the ratings, using
SUM; and the number of ratings, using COUNT from the table above. (5 Marks)
c. Explain the third normal form. (5 Marks)
d. List and explain the different methods of providing security for a database. (5 Marks)

QUESTION FIVE
a. Which approach replaced the file-based system and what are its demerits (5 Marks)
b. Mention the limitations of web-DBMS approach (5 Marks)
c. List the major components of a distributed Database management system (4 Marks)
d. Explain the different components in database environment (5 Marks)
e. Define a data model. (1 Mark)

Bmit 216 2009/2010 Academic Year Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams