Database Systems Design And Development Question Paper
Database Systems Design And Development
Course:Bachelor Of Science In Information Technology
Institution: Kca University question papers
Exam Year:2009
UNIVERSITY EXAMINATIONS: 2008/2009
SECOND YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
BIT 2104: DATABASE SYSTEMS DESIGN AND DEVELOPMENT
DATE: AUGUST 2009 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE (COMPULSORY)
a) Briefly explain the meaning of the following concepts. Give one example for each concept
i) Distributed database (2 Marks)
ii) Database transaction (2 Marks)
iii) Cardinality (2 Marks)
b) i) By use of an example, discuss the ACID properties of a typical database transaction (4 Marks)
ii) Identify and briefly discuss any five benefits of using the DBMS as opposed to the file system to
handle organizational data (5 Marks)
c) i) Distinguish between data security and data integrity (2 Marks)
ii) Illustrate three types of data integrity in database systems (3 Marks)
d) i) Describe the term ‘normalization’ and demonstrate how this is important (4 Marks)
ii) Explain the rules for the first three levels of normalization (6 Marks)
QUESTION TWO
a) i) Define the term ‘abstraction’ with reference to object database model (2 Marks)
2
ii) Discuss two ways in which abstraction can be implemented in a data model (4Marks)
b) i) Identify the anomalies that can result from bad database design (6 Marks)
ii) Highlight the types of data independence (2Marks)
c) Discuss the types of cardinality that can be mapped in an E-R diagram (6 Marks)
QUESTION THREE
a) i) Using appropriate illustration, define the term ‘deadlock’ ’ (2 Marks)
ii) Describe the two different ways of deadlock prevention (2 Marks)
b) Use the RESTAURANT relation below to describe and point out the following;
RestaurantId Name Location Class Seating Capacity
R001 The Café Nairobi 2 70
R002 Bon Appetit Lavington 3 35
R005 Bismillah Eastleigh 3 50
R006 Kisumu Dishes Kisumu 4 85
R007 Pearl Takeaway Naivasha 4 37
i) Primary key index (2 Marks)
ii) Cardinality (2 Marks)
iii) Attribute (2 Marks)
iv) Tuple (2 Marks)
v) Degree (2 Marks)
vi) Relation (2 Marks)
c) Write a DDL statement that can create the structure of the table without data (4 Marks)
QUESTION FOUR
a) Distinguish between the following types of attributes;
i) Single-valued and multi-valued attributes (2 Marks)
ii) Simple and composite attributes (2 Marks)
b) Examine the following table and answer the accompanying questions;
3
Patient
PatientNo Names Gender Contacts DOB
1001 Agnes Wanjala Female Box 5575 Nairobi 09/09/1987
1002 Peter Kamau Male Box 474 Nairobi 02/07/1985
1003 Susan Ogolla Female Box 95858 Nairobi 11/04/1987
1004 Lilian Chelimo Female Box 56 Githurai 08/12/1972
Prescription
PrescriptionNo DoctorNo PatientNo Date Drug Dosage Amount
E09668 D101 1002 25/04/09 Panadol 25 250.00
E09669 D207 1003 25/04/09 Malaratab 12 410.00
E09670 D205 1001 26/04/09 Breacol 12 573.00
E09671 D106 1002 28/04/09 Actal 30 512.00
E09672 D207 1004 30/04/09 Zantac 10 800.00
i) Justify the meaning of the underlined titles for the field names (2 Marks)
ii) Write SQL DML statements to;
- Select all prescriptions by doctor D207 (2 Marks)
- Select the patient no, names and birth date of all female patients (2 Marks)
- Select all prescriptions by ascending order of drug name (2 Marks)
- Select drug name, dosage and amount of prescriptions costing above 500.00
(2 Marks)
iii) Write an SQL statement to display the numbers of customers who have orders (2 Marks)
c) Draw a logical entity relationship diagram that can translate into the above tables (4 Marks)
QUESTION FIVE
a) Highlight the differences that exist between these two database concepts;
i) Database Schema (2 Marks)
ii) Database instance (2 Marks)
b) i) When given a database requirements scenario from the user requirements specification, apply
your design knowledge to define the steps that can result into an entity-relationship diagram
(4 Marks)
4
ii) Identify the five major activities that are performed during database implementation
(5 Marks)
c) i) With help of a diagram, illustrate the five states of a database transaction (5 Marks)
ii) Discuss any two functions of the data dictionary (2 Marks)
More Question Papers
Exams With Marking Schemes