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)
More Question Papers
Popular Exams
Return to Question Papers