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 Principles Question Paper

Database Systems Principles

Course:Bachelor Of Science In Information Technology

Institution: Kca University question papers

Exam Year:2011

UNIVERSITY EXAMINATIONS: 2010/2011
FIRST YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
BIT 1207: DATABASE SYSTEMS PRINCIPLES
DATE: APRIL 2011 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE (30 MARKS)
a) Define the following database system concepts;
i) Tuple (2 Marks)
ii) Entity set (2 Marks)
iii) Distributed database (2 Marks)
iv) Conceptual modeling (2 Marks)
b) Discuss three approaches for modeling data (6 Marks)
c) List the types of relationships that can be used to link relations (3 Marks)
d) Identify four roles of the database administrator (4 Marks)
e) Below is a list of potential entities for a hotel database;
- Customer
- Meal
- Service
Identify at least three attributes for each of these entities (including primary and/or foreign
keys) and draw an entity-relationship diagram illustrating these entities (9 Marks)
QUESTION TWO (20 MARKS)
a) Describe each of the following levels of data normalization;
2
i) First Normal Form (2 Marks)
ii) Second Normal Form (2 Marks)
iii) Third Normal Form (2 Marks)
b) State four advantages of normalization (4 Marks)
c) Define the term “data dictionary” and identify four contents of a data dictionary (6 Marks)
d) Describe how one would remove a field called “NoOfRepairJobs” from a table called
MECHANIC” (4 Marks)
QUESTION THREE (20 MARKS)
a) Define the following terms with reference to distributed database systems;
i) Fragmentation (2 Marks)
ii) Replication (2 Marks)
b) Identify the problems an organization may incur as a result of using a distributed database system
(6 Marks)
c) Define the term “DBMS” and list any DBMS applications you know (6 Marks)
d) List any four factors you may consider when choosing the appropriate DBMS (4 Marks)
QUESTION FOUR (20 MARKS)
The table below stores information relating to a concert session. Study it and answer the questions that
follow;
PERFORMANCE
performanceID performer date instrument
P01 Allen Wallen 01/04/2011 Violin
P02 Wade Brown 08/04/2011 Cello
P03 Patel Peters 08/04/2011 Flute
P04 Matthews Black 09/04/2011 Cello
P05 Lee Roys 10/04/2011 Oboe
a) State the result of repeating the PerformerID “P002” for the sixth record (2 Marks)
b) Write SQL statements to perform the following;
i) Create the above table with appropriate data types (3 Marks)
3
ii) List the names of all Cello performers (3 Marks)
iii) List the instrument being played by Matthews (3 Marks)
iv) List performances that will be made on the 8th of April (3 Marks)
c) Discuss three types of interfaces that are offered by a standard DBMS (6 Marks)
QUESTION FIVE (20 MARKS)
a) i) Define the term “data integrity” (2 Marks)
ii) Identify two principle integrity rules applied to a foreign key (2 Marks)
b) Highlight two ways of enforcing security on a database (4 Marks)
c) Discuss the steps involved in the database development lifecycle (12 Marks)

Database Systems Principles Question Paper

More Question Papers

Popular Exams