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

Database Management Systems Y2s1 Question Paper

Database Management Systems Y2s1

Course:Bmit

Institution: Kabarak University question papers

Exam Year:2010

COURSE CODE: BMIT 216
COURSE TITLE: DATABASE MANAGEMENT SYSTEMS
STREAM: Y2S1
DAY: THURSDAY
TIME: 2.00 – 5.00 P.M
DATE: 16/12/2010

INSTRUCTIONS:
• Question One is compulsory from section A.
• Choose other three questions and attempt from section B.
PLEASE TURN OVER
QUESTION ONE: (40 MARKS)
a) List and briefly describe five different categories of databases and give an example for
each type. (5 Marks)
b) What does the term data dependence mean and why is an important goal in database
management? (5 Marks)
c) Explain the different the three levels of the same database. (5 Marks)
d) Give three reasons why many system designers believe that data modeling is the most
important part of system development. (3 Marks)
e) What is the degree of a relationship? List and briefly describe three types of relationships
with examples. (5 Marks )
f) List three conditions that you can apply to determine whether a relation is in first normal
form is also in second normal form. (3 Marks)
g) List five important criteria in selecting a file organization. (5 Marks)
h) Define index and state five rules of thumb for choosing indexes. (5 Marks)
i) What is the difference between an authentication scheme and authorization scheme?
(4 Marks)
SECTION B (20 Marks each)
QUESTION TWO: (20 MARKS)
a) List and five additional costs associated with the database approach. (5 Marks)
b) Explain how relationships between tables expressed in a relational database
(3 Marks)
c) From a study of the business process at a certain organization the following information
was extracted: (6 Marks)
• The company sells number different furniture products. These products are grouped
into several product lines. Each product is uniquely identified with a product id
while the product line is identified with a product line id and product line name.
Referring to customer’s invoice it was identified the following were additional
details of the products: product description, product finish and standard price. A
product must belong to exactly one product line.

• Customers submit orders for products. Each order is uniquely identified by an order
No, and order date. A customer may submit any number of orders, but need not
submit any orders. Each order is submitted by exactly one customer. Each customer
is uniquely identified by customer I, customer name, customer address and postal
code.

d) Differentiate between the following giving an example for each: (5 Marks)
i. Multi valued and composite attribute
ii. Super type and subtype
e) Define normalization. (1 Mark)

QUESTION THREE: (20 MARKS)
a) Explain three objectives of selecting a data type for an attribute. (4 Marks)
b) How can one represent a 1: M relationship in a relational model? (4 Marks)
c) Describe two properties that must be satisfied by a candidate key. (2 Marks)
d) Explain purpose and scope of database security. (6 Marks)
e) Define the following: (4 Marks)
i. Transaction
ii. Functional dependency
iii. RAID
iv. Composite key

QUESTION FOUR: (20 MARKS)
a) List six properties that should hold for a relation to exist in the database. (6 Marks)
b) How can one represent an M: N ternary relationship in a relation model? (4 Marks)
c) A business operator wants to keep track of his clients and the orders the place. Each
client has a client name, client number, client address and city. The orders must have a
client number, order number and description. Later he discovered there ought to be the
total cost of each order placed. Use the SQL commands to implement this information to
the database adhering to all constraints.
(6 Marks)
d) List and explain four measures that can secure data from threats. (4 Marks)

QUESTION FIVE: (20 MARKS)
a) Define five roles of a data administrator. (5 Marks)
b) Differentiate between unique constraint and primary key constraint. (3 Marks)
c) Explain three anomalies associated with concurrent transactions. (6 Marks)
d) Explain the entity integrity constraint. (4 Marks)
e) Define denormalization. (2 Marks)

Database Management Systems Y2s1 Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams