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)
More Question Papers
Exams With Marking Schemes