IGCSE Computer Science Paper-2: Specimen Questions with Answers 11 - 12 of 12

Question number: 11

Edit

Essay Question▾

Describe in Detail

What do you mean by Fact-finding in Database Management System? List some of the techniques.

Explanation

Fact-Finding in DBMS is defined as the technique used to collect facts about systems, requirements and preferences. The formal process of techniques such as interviews and questionnaires are used. These techniques are used in case of database design and the later stages of the lifecycle to a lesser extent.

Techniques used:

i) Examining documentation

ii) Interviewing

iii) Observing the enterprise in action

iv) Research

v) Questionnaires

Question number: 12

Edit

Short Answer Question▾

Write in Short

Write a Pseudocode or an alogorithm to input any three numbers and then printing them in the ascending order.

Explanation

Let’s assume the three numbers as 6,5, 4. At the end it should look like 4,5, 6.

Boolean flag = true; //proceeding to sorting

Array [] = [4,5, 6]; //the list of numbers to be sorted

Int len = length (array); // (three numbers here)

Int i = 0; //Index pointing to the member of the array or the list

Int buffer = 0; //temporary storage empty at the beginning

While (flag) // sorting is not finished

  1. {
  2.  If array ⟦i⟧ is ⟩array ⟦i+1⟧ //if first element is greater than second
  3.  {
  4.   buffer=array ⟦i⟧; //saving the first element in temporary storage
  5.   arrayi⟧=arrayi+1⟧; // installing first element in the second place
  6.   array ⟦i+1⟧ =buffer//placing the first element
  7.   if (ilen); index increases if i is within the array length
  8.    i=i+1// concentrating on the next pair
  9.    else i=0//starting the bubble again
  10.    }
  11.    }

Choose Paper