Important points for this course
Question types and examples for the
Selection questions (example)20marks
1. The stakeholders are those who have interests in the success of a new
system. Suppose there are three people, called P1, P2 and P3 respectively.
P1 pays for and owns the system, P2 uses the system on daily basis, and P3
ensures that the system operates in the computing environment of the
organization. Which of the following statement is correct?
(A) P1 is a user stakeholder.
(B) P1 is a client stakeholder.
(C) P1 is a technical stakeholder.
(D) P1 is both a client and a user stakeholder.
2. A questionnaire consists of the following three questions:
Question One: Are you a student?
Question Two: How many classes do you have each day?
Question Three: How can you make much achievement in your study?
Which of the following statement is correct?
(A) Question One and Question Two are open-ended questions.
(B) Question One and Question three are open-ended questions.
(C) Question One and Question two are close-ended question.
(D) Question One and Question three are close-ended question.
Judgement questions(example) 10marks
1. If one customer can place many orders, but one order can only be placed by one customer,
then the relationship between customer and order is a n-ary relationship.
2. A foreign key of one relational database table must be the primary key of another relational
3. Extranet and intranet use totally different network protocols.
4. Synchronization pseudostate is a method to represent the concurrent behavior of an object
by dividing one state symbol into many compartments, with each compartment contains a
Short answer questions(example)30marks
1. Bellow is a data flow diagram
The logic of the processes P1, P2 and P3 are respectively as follows:
Process P1: Process P2: Process P3:
if A>B then if D=E+100 then Y=B*E
End if else
Are there any miracle or black hole on the above DFD? Give your reason
2. Please state the advantages and disadvantages of using the internet as a
System analysis and design questions(example)40marks
ERD---Relational database Schema
Customer Order OrderItem InventoryItem
Name OrderDate Price ItemName
Address Tax Quantity QuantityOnHand
Phone GrandTotal AverageCost
A library has many books and many readers. One reader can borrow many books, one book
can be borrowed by many readers at different time. If a book is lent to a reader, the lending date
and return date must also be recorded. Attributes about book and reader are given below:
Book: book number, book name, author, price, publishing date, status;
Reader: card number, reader name, gender, address, phone number;
Please draw an entity relationship diagram about book and reader, if necessary, add associative
entity to represent the relationship between book and reader
Create event table and draw DFD(or from event table to DFD)
You are asked to develop a library management information system, the system contains only
the following information:
Book information including book number, book name, author, price, publishing date;
Reader information including library card number, reader name, gender, address,
Book lending and returning information including lending date and return date.
Please answer the following questions based on the previous information and your
Create an event table listing the main events that the system must respond, include event name,
trigger, source, activity, response, and destination for each event.
Draw a context diagram and event-partitioned diagram(diagram0) for this system.
PERT/CPM or gantt chart
1. Bellow is a list of tasks for an information system project. According to the list, answer the
i. Build the PERT/CPM chart
ii. Determine the critical path
iii. What is the meaning of slack time? Give an example from your PERT/CPM chart of
Task Description Duration Precedence
1 Task1 3 --
2 Task2 2 --
3 Task3 3 1,2
4 Task4 2 3
5 Task5 4 3
6 Task6 2 5
7 Task7 3 4,6
8 Task8 3 7
2. Build a Gantt char based on the above task list
The following is an event-partitioned data flow diagram for library management,
using transaction analysis technique to develop a structure chart for it.
Reader info Reader
Reader info book
Library card 2 Library card
number Reader number
Book lending info
3 book number
Book info book
Book info Return Book query
Book number book
deregister 4 Book
Draw Decision table/decision tree/structured English
5. The rules of deciding the postage of a postal parcel is described as follows: if the parcel is
to be sent by express, then the basic charge will be 6$/kg, otherwise the basic charge will
be 4$/kg. If the distance is over 200km, then each kg will be charged for one more dollar. If
the parcel’s weight is over 10kg, then another 0.5 dollar will be charged for each kg that
exceeds 10 kg. Suppose a parcel’s weight is W kilograms, please draw a decision table to
show the calculation of the postage for this parcel.
Improve the following table to third normal form(3NF) , identify each table’s primary key
Staff-wage table description:
StaffNumber, StaffName, WageLevel, BasicWage, EducationalLevel, GraduateDate