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!
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:2010
UNIVERSITY EXAMINATIONS: 2010/2011
SECOND YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
BIT 2104 – DATABASE SYSTEMS DESIGN AND DEVELOPMENT
DATE: DECEMBER 2010 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE (30 MARKS)
a) State the use of the following clauses in a typical SQL statement
i. REFERENCES (2 Marks)
ii. ROLLBACK (2 Marks)
iii. DISTINCT (2 Marks)
iv. ALTER TABLE (2 Marks)
v. COMMIT (2 Marks)
b) Outline four functions of a database management system (4 Marks)
c) Define the term ‘database transaction’ and identify four properties exhibited by database
transactions (10 Marks)
d) Describe three levels of the DBMS architecture (6 Marks)
QUESTION TWO (20 MARKS)
a) Define the following terms as used in the control of concurrent database transactions;
i) Shared lock
ii) Timestamp
iii) Deadlock (6 Marks)
2
b) Consider the CUSTOMER relation with fields as follows;
CustomerId Names Address City Age
Write SQL statements to perform the following transactions;
i. Return details of all customers aged below 30 years who reside in Nairobi city (3 Marks)
ii. Insert the data (5001, Mary Mutuku, Box 56 Machakos, Machakos and 34 years) into the
respective columns (3 Marks)
iii. Amend the city data from ‘Nairobi’ to ‘Mombasa’ for a Customer Id ‘5001’ (3 Marks)
Hint: Assume that CustomerId and Age are number fields
iv. Empty the CUSTOMER relation of all data (2 Marks)
c) List three functions of the data dictionary (3 Marks)
QUESTION THREE (20 MARKS)
a) Identify two properties that a primary key must possess; (2 Marks)
b) Explain the benefits of the object-oriented data modeling (6 Marks)
c) A popular method of implementing concurrency control in a multi-user database environment is
through the use of data locking mechanisms.
i. Define the concept of data locking (2 Marks)
ii. Identify and describe five data locking levels (10 Marks)
QUESTION FOUR (20 MARKS)
a) Define the term ‘Query by example’ (QBE) (2 Marks)
b) The following diagram illustrates a QBE interface
LECTURERS
staffNo staffName status deptName salary
p. p. Computer Studies >50,000
i. State the result of the following above execution (4 Marks)
ii. Write a corresponding SQL statement that would yield the same result (4 Marks)
c) Define the following attributes in relational database design;
i. Multi-valued attribute (2 Marks)
3
ii. Composite attribute (2 Marks)
iii. Derived attribute (2Marks)
d) Identify the steps during database design that will result in an entity-relationship diagram
(4 Marks)
QUESTION FIVE (20 MARKS)
a) i) Define the term ‘Normalization’ with respect to logical data design (2 Marks)
ii) Describe any three anomalies that are associated with bad database design (6 Marks)
b) Below is a table illustrating the renting information for customers of DreamHome real estate
company;
CUSTOMER RENTAL TABLE
Cust_No CName Prop_
No
P_Address RentStart RentFinish Rent Owner_No OName
CR76 John Kay PG4
PG16
6 Lawrence
Street
Glasgow
5 Novar Drive,
Glasgow
1-Jul-93
1-Sep-96
31-Aug-95
1-Sep-96
350
450
CO40
CO93
Tina Murphy
Tony Shaw
CR56 Aline
Stewart
PG4
PG36
PG16
6 Lawrence
Street
Glasgow
2 Manor Road,
Glasgow
5 Novar Drive,
Glasgow
1-Sep-92
10-Oct-93
1-Jan-95
10-Jun-96
1-Dec-94
10-Aug-95
350
375
450
CO40
CO93
CO93
Tina Murphy
Tony Shaw
Tony Shaw
i. The table above violates the rule of the first normal form (1NF). Explain how and identify a
possible consequence of this inconsistency (4 Marks)
ii. Organize the data in the table above into the 1NF, then into 2NF (8 Marks)
More Question Papers
Popular Exams
Return to Question Papers