Get premium membership and access revision papers, questions with answers as well as video lessons.

Dbit 301 Database Systems Question Paper

Dbit 301 Database Systems

Course:Diploma In Business Information Technology

Institution: Kca University question papers

Exam Year:2012

UNIVERSITY EXAMINATIONS: 2011/2012
EXAMINATION FOR THE DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DBIT 301 DATABASE SYSTEMS
DATE: MARCH, 2012 TIME: 1½ HOURS
INSTRUCTIONS: Answer Any Three Questions
QUESTION ONE
a) Define the following database system concepts;
i. Tuple (2 Marks)
ii. Entity set (2 Marks)
iii. Cardinality (2 Marks)
b) List the types of relationships that can be used to link relations (3 Marks)
c) Identify FIVE roles of the database administrator (5 Marks)
d) Below is a list of potential entities for a hotel database;
- guest
- room
-outlet
Identify at least two attributes for each of these entities (6 Marks)
QUESTION TWO
a) Describe each of the following levels of data normalization;
i. First Normal Form (2 Marks)
2
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 the components of an entity relationship diagram (4 Marks)
QUESTION THREE
a) Define the following terms with reference to database systems;
i. Encryption (2 Marks)
ii. Replication (2 Marks)
b) Define the term “DBMS” and list any DBMS applications you know (6 Marks)
c) List any four factors you may consider when choosing the appropriate DBMS (4 Marks)
d) Give three categories of SQL commands (6 Marks)
QUESTION FOUR
The table below stores information relating to a concert session. Study it and answer the questions that
follow;
PERFORMANCE TABLE
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 “P02” 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)
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)
3
c) Discuss three advantages offered by a standard DBMS (6 Marks)
QUESTION FIVE
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)

Dbit 301 Database Systems Question Paper

More Question Papers

Popular Exams