Answer 2 questions (out of 4). Each question carries 30 marks.
A house cleaning company has been set up to provide cleaners in the local area. They require a system which deals with customers,
jobs, staff, allocation of jobs, purchase and provision of cleaning material, paying both staff and suppliers.
a) What is the purpose of system analysis and what skills are required by a system analyst?
b) Identify the processes, data stores and external entities in the above case study
c) Give THREE reasons why DFDs should be used and give an example from the above case study
a) Describe the functions of a feasibility study, discussing its place in the System Development Life Cycle (SDLC).
b) Identify FOUR fact finding techniques, giving one different advantage and one different disadvantage of each
c) Briefly describe TWO different approaches to the system development life cycle and techniques used in each
a) Write brief notes describing the advantages and drawbacks of each of the following:
i) Ecommerce (5 marks)
ii) Data Warehousing (5 marks)
iii) Client Server technology (5 marks)
iv) End user computing (5 marks)
b) Briefly describe the most common features of relational database systems.
a) What is HCI and why is it important in application design?
b) What techniques are used for good interface design?
c) Briefly describe the role and responsibilities of a project manager within the development of a computerised system.
d) Briefly discuss why documentation should be produced for a computer system and give examples of THREE different types of
documentation explaining the basic content of each.
Answer 5 questions (out of 8). Each question carries 12 marks.
a) Define what is meant by the following mathematical terms:
(3 x 2 marks)
b) For the following selection of numbers,
1, 1, 1, 1, 2, 2, 3, 3, 4
calculate, showing workings, the
(3 x 2 marks)
Discuss with respect to Rapid Application Development the following terms:
a) Joint Requirements Planning
b) Time boxing
c) Joint Application Development
(3 x 4 marks)
Discuss the typical management structure for a computing department within a company.
Discuss the following terms, giving examples
a) Operational data
b) Strategic data
c) Tactical data
(3 x 4 marks)
Discuss the typical functions of a database administration team.
What is meant by the following terms and provide examples
a) Structured data
b) Un-structured data
(4 x 3 marks)
a) Discuss briefly what it meant by the term Evolutionary Prototyping.
b) Discuss briefly the advantages and disadvantages of this technique.
Normalisation and Entity Relationship Diagrams are two techniques for designing data structures.
a) Describe these two techniques
(2 x 3 marks)
b) What are the advantages and disadvantages of these two techniques?