2017 final

Question 1

Explain what the following terms mean in terms of the relational database:
i) Structure
ii) Integrity
iii) Language

Question 2

List three types of integrity constraints.

Question 3

State what the following JDBC interfaces do:
i) driver
ii) connection
iii) statement
iv) resultset

Question 4

Write code snippets that show the use of driver connection statement and resultset.
[8 marks]

Question 5

q2 do it on paper

Question 6

The following are design principles of OOP: Encapsulation, Abstraction, Polymorphism, Inheritance and Composition.

Explain each principle.

Question 7

Name 4 diagrams and expalin them. that form part of UML.

Question 8

Define what a software requirement is.
[2 marks]

Question 9

Give an example of a functional requirement of a banking system.
[2 marks]

explain functional vs non-fuctional requirement

Question 10

Explain what a UML Activity Diagram models.

Question 11

Identify symbols used for the following in an activity diagram:
Start state, end state, activity. Flow and decision.
[6 marks]

Question 12

Describe the following fields using in use case scenario templates: purpose, pre-condition, post condition, exceptions, priority and frequency.
[6 marks]

Question 13

Explain the impact of the final keyword in the code that follows:
final class Math {
…
}

Question 14

Explain the impact of the final keyword in the code that follows:
final static double PI = 3.14159;

Question 15

Identify two categories of methodologies

Question 16

q 4 do it on paper

Question 17

Describe what an immutable class is.
[3 marks]

Question 18

List four activities the occur in the requirements engineering process.
[4 marks]

Question 19

Write short notes about an Interface.
[5 marks]

Question 20

Draw a diagram that shows how a database application system is arranged.
[4 marks]

Question 21

Explain what database metadata is. [1 mark]

Question 22

do 5 c on paper

Question 23

super keyword?