Get premium membership and access revision papers, questions with answers as well as video lessons.
Cisy 221/Bbit 232 Question Paper
Cisy 221/Bbit 232
Course:Database Management Systems
Institution: Kenya Methodist University question papers
Exam Year:2010
KENYA METHODIST UNIVERSITY
END OF 3''rd ''TRIMESTER 2014 (FT) EXAMINATION
FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : COMPUTER SCIENCE AND BUSINESS
INFORMATION
UNIT CODE : CISY 221/BBIT 232
UNIT TITLE : DATABASE SYSTEMS
TIME : 2 HOURS
INSTRUCTIONS
Answer question one and any other two questions
Question One (30 marks)
List five advantages of DBMS over file processing systems.
(5 marks)
What are the application areas of database systems?
(5 marks)
Using a well-illustrated diagram, describe the three levels of the database architecture.
(6 marks)
Briefly explain the properties of a transaction that must be maintained by any DBMS.
(4 marks)
List and explain the four groupings of integrity checks on data.
(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 intersection on the following relations:-
(6 marks)
R(A)
Jamie 555-234-546
Lydia 555-978-160
Martin 555-610-948
Norah 555-420-614
Owen 555-087-391
Peter 555-237-765
Robert 555-859-716
Tobias 555-104-309
R(B)
Ingra 555-794-625
Katherina 555-254-921
Martin 555-610-948
Norah 555-420-614
Owen 555-087-391
Quincy 555-703-498
Robert 555-859-716
Silvia 555-423-765
Question Two (15 Marks)
Making a refined structured relational is achieved by the process of normalization. Normalize the following data structure in its first normal form (INF) to the 3NF
(10 marks)
Student ID NAME Advisor Dept Dept. name Course name grade
123 Anita Dorothy CS Comp Sci CISY 404 A
123 Anita Dorothy CS Comp Sci CISY 221 A
123 Anita Dorothy CS Comp Sci CISY 131 B
321 Mwafusi Riungu CS Comp Sci CISY 401 E
321 Mwafusi Riungu CS Comp Sci CISY 400 E
999 Quiqie Timothy BBIT BUSS IT BBIT 232 A
SQL is a date sub language. Explain five basic SQL statements used.
(5 Marks)
Question Three (15 Marks)
There is a requirement that a department sponsors projects that are monitored by employees. These employees manage the department for a given period of time. Using the following schema, draw an aggregated EKmodel.
(10 marks)
Employee (SSN, name, lot)
Projet (pID, start – on, pBudget)
Department (dID, dname, budget)
State and explain the stages of the database lifecycle.
(5 Marks)
Question Four (15 Marks)
A country bus Company owns a number of buses. Each bus is allocated to a particular route although some routes may have several buses. Each route passes through a number of towns. One or more drivers are allocated to each stage of a route, which corresponds to a journey through some or all of the towns on a route. Some of the towns have a garage where buses are kept and each of the buses are identified by their registration number and can carry different number of passengers, since the vehicles vary in size and can be single or double decked. Each route is identified by a route number and information is available on the average number of passengers carried per day for each route. Drivers have an employee number, name, address and sometimes a telephone number.
List all the possible entity types and their attributes that can be derived from the above bus company narrative.
(6 Marks)
List any three possible cardinality in the entity types relationships that can be derived from the bus company
(3 Marks)
Draw the E-R diagram for the bus company.
(6 Marks)
More Question Papers
Popular Exams
Return to Question Papers