August 1999
SW204 : SOFTWARE AND
FILE DESIGN

QUESTION 3

Total Marks: 20 Marks

 Click here to access other questions

Click to access
SUGGESTED SOLUTIONS
for Question 3
(a) In deciding which type of file organisation should be employed in a system, a designer has to take into account a number of factors. Explain each of the following factors which may have to be considered :
(i) Volatility

(ii) Run integration

(iii) Access type

(iv) Hit rate

(v) Life expectancy

 

 [2]

[2]

[2]

[2]

[2]
(b) Describe the use of normal and overflow track entries in relation to Indexed Sequential Files.

 

 [6]
(c) Name two structures that can adopted by Indexed Sequential Files.

 

 [2]
(d) Give two advantages of Indexed Sequential Files.

 

 [2]