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

Cop 317 Database Development, Administration And Maintenance Question Paper

Cop 317 Database Development, Administration And Maintenance

Course:Bachelor Of Science In Computer Science

Institution: The Presbyterian University Of East Africa question papers

Exam Year:2016

PRESBUTERIAN UNIVERSITY OF EAST AFRICA
NAKURU CAMPUS
PROGRAMME: Bsc Computer Science
UNIT CODE: COP 317
UNIT NAME: DATABASE DEVELOPMENT, ADMINISTRATION AND MAINTENANCE
STUDENTS: 3
INSTRUCTIONS: ANSWER QUESTION ONE (COMPULSORY) AND ANY OTHER TWO QUESTIONS
Question one (30 Marks)
a) Discuss the following terms (10 marks)
i. ResultSet
ii. Stored procedure
iii. Embedded SQL
iv. Data modelling
v. Referential integrity
b) Using examples, illustrate how database metadata can be examined (7 marks)
c) Briefly explain two applications of SQLJ iterators (5 marks)
d) Describe any possible violations of the INSERT operation (8 Marks)

Question Two (15 Marks)

a) Using diagrams, illustrate the normalization process (7marks)
b) Describe the process of removing many to many relationships (5 marks)
c) Explain the term Complex query.

Question Three (15 Marks)
a) Briefly describe the entity relationship model. (7 marks)
b) Define: (8 marks)
i. Data Definition Language
ii. Relationship cardinality
iii. Transitive dependency
iv. Database maintenance

Question Four (15 Marks)
a) Using diagrams, describe the structure of a redundant relationship (9 marks)
b) Explain the term stored procedure and explain its advantages (6 Marks)

Cop 317 Database Development, Administration And Maintenance Question Paper

More Question Papers

Popular Exams