Get premium membership and access revision papers, questions with answers as well as video lessons.
Got a question or eager to learn? Discover limitless learning on WhatsApp now -
Start Now!
Cisy 221:Database Management Systems Question Paper
Cisy 221:Database Management Systems
Course:Computer Science
Institution: Kenya Methodist University question papers
Exam Year:2012
KENYA METHODIST UNIVERSITY
END OF 2ND TRIMESTER 2012 (EVENING) EXAMINATIONS
FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : COMPUTER SCIENCE & BUSINESS INFORMATION
UNIT CODE : CISY 221/BBIT 232
UNIT TITLE : DATABASE MANAGEMENT SYSTEMS
TIME : 2 HOURS
Instructions: Answer Question ONE which is compulsory and any other TWO Questions.
Question One
List and explain the four different types of database end users.
(4 Marks)
Why would you choose a database system instead of simply storing data in operating system files?
(4 Marks)
Explain the following terms as seen in database management systems.
(6 Marks)
The data definition language.
The data manipulation language.
The data Model
Explain what is meant by the term attribute in an entity relationship diagram in DBMS.
(2 Marks)
List any TWO reasons as to why a database may be left in an inconsistent state.
(2 Marks)
Briefly explain what a data warehouse is and its contents and key application in the world today.
(4 Marks)
In relational algebra there are unary and binary fundamental operations. In the Binary operations perform a union, difference [R(A) – R(B)] and an intersection on the following relations.
(4Marks)
A B
Alpha 1967
Charlse 1972
Delta 1977
Echo 1988
Alpha 1967
Bravo 1972
Delta 1977
Foxprof 1982
Echo 1987
(b) Define and explain the acronym A.C.I.D. (4 Marks)
Question Two
Making a data structured relational is achieved by the process of normalization. Normalize the following data structure in its First Normal Form (INF) to third Normal Form (3NF).
(9 Marks)
Module Dept Lecturer Text
M1 D1 L1 T1
M1 D1 L1 T2
M2 D1 L1 T1
M2 D1 L1 T3
M3 D1 L2 T4
M4 D2 L3 T1
M4 D2 L3 T5
M5 D2 L4 T6
In transactions, describe the strict two-phase locking in concurrency control.
(2 Marks)
Clearly distinguish between discretionary security mechanisms and mandatory access control.
(4 Marks)
Question Three
Joyken chain of pharmacies has to give you a free lifetime supply of medicine if you design its database. Given the rising cost of health care, you agree. Here is the information that you gather:
Patients are identified by an SSN and their names, addresses and ages must be recorded.
Doctors are identified by an SSN. For each doctor, the name, speciality and years of experience must be recorded.
Each pharmaceutical company is identified by a name and has a telephone number and address.
For each drug, the trade name and formula must be recorded company and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company is deleted, you need not keep track of its products any longer.
Each pharmacy has a name, address and phone number.
Every doctor has at least one patient.
Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies and the price could vary from one pharmacy t another.
Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients and a patient could obtain prescriptions from several doctors.
Pharmaceutical company have long term contracts with pharmacies. A pharmaceutical company can contract with several pharmaceutical companies. For each contract, you have to store a start date, an end date and the text of the contract.
Pharmacies appoint a supervisor for each contract. Thee must always be a supervisor for each contract.
Answer the following questions from the information that is provided above.
List all possible entities that are discussed in the above narration.
(3 Marks)
(ii) List any THREE possible relationships (showing cordinality of each) that can be demand from the above nitration. (3 Marks)
(iii) Design and draw an E.R diagram that captures the information narrated
above. (4 Marks)
What problems are caused by data redundancy in database management systems? List and explain any two.
(2 Marks)
DBMS is a collection of programs that enables users to create and maintain databases. It can also be described as a general purpose software system that facilitates the process of defining, constructing and manipulating databases for various applications. Explain the terms defining, constructing and manipulating.
(3 Marks)
Question Four
Student ID* Name Advisor Dept Faculty Year GPA
CIS-1-01-10 Peter Juma CIS Sciences 2007 2.93
BUS-0-07-03 Jane Abdi BBA Business 2008 3.01
CIS-0-02-08 Mary Henry CIS Sciences 2008 3.32
BUS-1-01-06 Andrew Abdi BBA Business 2007 2.79
MAC-1-03-07 John Juma CIS Sciences 2008 3.42
Study the above relation and answer the following questions.
(i) Express how the SQL statement for SELECT will appear to display the above table. (2 Mark)
(ii) Show the results of the above statement offer the above operation on the ’student’ table. (2 Marks)
(iii) Adding a new record to the table uses the SQL statement "INSERT INTO",
with the following details show how this statement will be applied.
(2 Mark)
Student ID:BCM-1-20-11, Name: Beth, Advisor: Henry, Dept: BBA, Faculty: Sciences, Year: 2011, GPA: 2:75.
(iv) Show the results of the above statement after the above operation the
’Student" table. (2 Marks)
(v) Delete the student named Mary from the above table, show the SQL statement you will use for this operation. (2 Mark)
(vi) show the results of the above statement after the above operation on the "Student" table. (2 Marks)
(b) Using a diagram, discuss the THREE level database architecture briefly
explaining each of the levels of the three-scheme architecture. (6 Marks)
More Question Papers
Popular Exams
Return to Question Papers