PPhhiillaaddeellpphhiiaa UUnniivveerrssiittyy Lecturer : Dr. M. Maouche

Coordinator : Dr M. Maouche

Internal Examiner : Dr. A. Sulaiman

Course Name: System Analysis and Design (731332) Section: 1 Final Exam

Second Semester Academic Year: 2009/10 Date: June, 6th

, 2010 Time: 2 hours

Information for Candidates

1.This examination paper contains 6 questions, totaling 50 marks

2.The marks for parts of questions are shown in round brackets.

Advice to Candidates

1. You should attempt all questions.

2. You should write your answers precisely, clearly and to the point.

I. Basic Notions Objectives. The aim of the question in this part is to evaluate the required minimal student

knowledge and skills. Answers in the pass category represent the minimum acceptable standard.

Question1: (15 marks) Give the correct answer for each of the following MCQ questions (1 mark for each)

1. Graphically representing the processes that capture, manipulate, store, and

distribute data between a system and its environment and among components within a

system best describes

a. Logic modeling

b. Data modeling

c. Process modeling

d. Dynamic modeling

2. The act of going from a single system to several component processes refers to:

a. Structuring.

b. Balancing.

c. Decomposition.

d. Formatting.

e. Regeneration

3. Which is not, from the following, a data flow?

a. Movement

b. Exchange of information

c. Store

d. Data movement between external entities to processes

4. The lowest level of DFDs is:

a. Level-0 diagram.

b. Context diagram .

c. Level-1 diagram .

d. Primitive data-flow diagram .

e. Systematic diagrams.

FFaaccuullttyy ooff IInnffoorrmmaattiioonn TTeecchhnnoollooggyy DDeeppaarrttmmeenntt ooff MMaannaaggeemmeenntt IInnffoorrmmaattiioonn

SSyysstteemmss

Examination Paper

5. Which of the following is not an entity type?

a. Name

b. Store

c. Product

d. Work center

6. The primary deliverable from logical database design is:

a. Normalized relations

b. Design specifications

c. An updated baseline project plan

d. A list of alternative design strategies

7. The three major steps for designing dialogues include each of the following except:

a. Assessing usability

b. Designing the dialogue sequence

c. Building a prototype

d. Implementing the dialogue

8. Training on the use of the system begins during the early stages of:

a. Systems analysis phase.

b. Logical design.

c. Implementation.

d. Systems planning and selection phase.

e. Physical design

9. A testing technique in which participants examine program code for predictable

language-specific errors defines:

a. Walkthrough

b. Inspections

c. Desk checking

d. Syntax checking

10. The process of bringing together all of the modules that comprise a program for

testing purposes is referred to as:

a. Unity testing

b. Integration testing

c. System testing

d. Implementation

11. The bringing together of all the programs that comprise a system for testing

describes:

a. Unity testing

b. Integration testing

c. System testing

d. Implementation

12. The purpose of acceptance testing is to:

a. Determine if new requirements must be added to the newly completed system

b. Determine if the system meets user requirements

c. Determine if the system meets its objectives

d. Do none of the above

13. Written or other visual information about an application system, how it works, and

how to use it best defines:

a. System documentation

b. User documentation

c. Internal documentation

d. External documentation

14. The process whereby the physical design specifications created by the analysis

team is turned into working computer code is referred to as:

a. Coding

b. Testing

c. Implementation

d. Analysis

15. The part of the design phase of the SDLC in which the outcomes of the logical

design are transformed into technology-specific details best describes:

a. Implementation

b. Object modeling

c. Physical design

d. Logical design

II. Familiar Problems Solving Objectives. The aim of the question in this part is to evaluate that the student has some

basic knowledge of the key aspects of the lecture material and can attempt to solve

familiar problems.

Question2: (11 marks) A banking system is managing banking accounts for customers. Customers may be

provided with saving accounts and/or cheque accounts.

A customer requests details on his/her saving and/or cheque account(s) from a bank.

First the system should check the identity of the customer, then the appropriate

cheque/saving account information is retrieved and provided to the customer.

1. Draw the context DFD diagram related to the above scenario. Identify the external entities

and the external inputs outputs. (2 marks)

2. We wish to draw the DFD level 0 of the above system:

a. Identify and describe briefly the required processes. (2 marks)

b. Identify and describe briefly the required data stores (2 marks)

c. Identify and describe briefly the required data flows (2 marks)

d. Draw the resulting DFD level 0. (3 marks)

Question3: (5 marks)

The policy followed by a company to process customer orders is given by the

following rules:

(i) If the customer ordered quantity is less that the quantity in the stock and if his

credit is OK, supply his order.

(ii) If the customer credit is not OK do not supply. Send him an announcement.

(iii) If the customer credit is OK but items in stock are less than in his order, supply

what is in stock, and enter the balance to be sent in a back-order file.

Build a decision table for the above policy.

Question4: (9 marks)

A department of a company has a supervisor and at least one employee. Employees

must be assigned to at least one, but possibly more departments. At least one

employee is assigned to a project, but an employee may be on vacation and not

assigned to any projects. The important data fields are the names of the departments,

the projects, the supervisors and the employees, as well as the supervisor and

employee number and a unique project number.

1. Draw the ER diagram related to the scenario described above.(6 marks) 2. Select one many to many association from the drawn ER diagram and. transform this

association and its attached entities into a set of relations. (3 marks)

III. Unfamiliar Problems Solving Objectives. The aim of the question in this part is to evaluate that the student has some basic

knowledge of the key aspects of the lecture material and can attempt to solve unfamiliar

problems.

Question5: (5 marks)

We wish to design a form that allows a teacher to enter the marks (first,

second, assignment and final) of a given student for a given course.

a. What are the input data and their types that are required to be entered by

the user. Explain your choices. (2 marks)

b. Specify the kind of control (if any) that must be done for each of the

required input data. (2 marks)

c. Is it necessary to enter the student name? Why? (1 mark)

Question6: (5 marks)

An airline reservation system offers the capability to print a report that

displays the list of daily flights that connect two pre-defined airports.

The displayed flight information are: week day, departure airport, arrival

airport, flight number, departure time, arrival time, airplane type and the

number of seats.

Airport names: alphabetic string (maximum 20 characters)

Flight numbers: alphanumeric string (first two characters are

alphabetic ones, the following four characters are digit ones)-

Example: RJ1234

Airplane type: alphanumeric string (first character is alphabetic one,

the following three characters are digit ones)- Example: A320

Number of seats: Integer with 3 digits

Week day: one digit (from 1 to 7) - Example: 1 for Monday.

Time: HH:MM ( HH: 00 to 23; MM: 00 to 59).

Suggest and design a layout for this report.