NATIONAL OPEN UNIVERSITY OF NIGERIA

UNIVERSITY VILLAGE, PLOT 91, CASDASTRAL ZONE, NNAMDI AZIKIWE EXPRESS WAY, JABI, ABUJA.
FACULTY OF SCIENCES
APRIL 2019 EXAMINATION

COURSE CODE: CIT851

COURSE CREDIT: 3

COURSE TITLE:  ADVANCED SYSTEMS ANALYSIS AND DESIGN

 TIME ALLOWED: 2½ HOURS

INSTRUCTION: ANSWER QUESTION ONE (1) AND ANY OTHER FOUR (4) 

                                   QUESTIONS

QUESTIONS

1a. You have been invited as a guest speaker to a seminar organised by MTN foundation for Internet Service Providers. The letter of invite indicates that you should speak about the three (3) major stages of database design. Name and explain the (3) major stages involved in database design.  (6 marks)

1b. State any four (4) types of CASE tools employed in systems analysis   (2 marks)

1c. Describe the process of denormalization of tables (4 marks)

            1d. Explain five common types of files common in RDBMS  (10 marks)

 [22 marks ]

2a. Outline the steps involved in the process of documentation in system analysis  (7 marks)

2b. State 5 features of a typical system    (5 Marks)

 [Total = 12 marks]

3a. Explain the various layers found in the architecture of a Distributed System   (10 marks)

3b.Give a concise definition of an automated system (2 marks)

[Total = 12 marks]

4a. Explain the criteria for designing attractive forms.  (10 marks)

4b. Define the term ‘Decision Support Systems’.  (2 marks)

[Total = 12 marks]

5a.State five (5) rules that must be observed by a Systems Analyst while observing a site.  (10 marks)

5b. List any 4 categories of coupling.  (2 marks)

[Total = 12 marks]

6a. Discuss the procedure undertaken by Systems Analysts in the course of gathering information about an existing system. (10 marks)

6b. List 2 common forms of Interviews in Systems Analysis and Design.    (2 marks)

[Total = 12 marks]