Design and Analysis of Information Systems (CSCT5102)
Computer Science - COS
Semester: First Semester
Level:
Year: 2019
1
First Semester Examinations
School:
HTTTC Department: Computer
Science
Option:
FCS
Course Code:
CSCT5102
Course Title: Design and analysis of information systems
Lecturer: Kamtchoum
V. Evrad
Credit Value:
3 Level: 500
Session: March 2019
Time: 2 hours Start Time:
7am
End Time:
9am
General instructions
You are reminded of the necessity for good English and orderly presentation of your material.
Where calculations are involved, show your working, giving your answer at each stage.
Exercise 1: Definition and Multiple-choice questions (3 marks)
1. Write in your answers sheet, the number of the question and the letter corresponding to the
best answer. Example 1.a; a good answer: 0.5 mark; a wrong answer: 0 mark
Q.1 an example of business enterprise that uses
information system to achieve operational
excellence is?
a. BICEC bank
b. Grinding Mill
c. A barber’s shop
d. A coffee shop
Q.2 What is the prime use of an information
system in an organization?
a. Decision making and control
b. Communications and data flows
c. Analysis of raw data
d. Creation of new products and services
Q.3 which of the followings is used to model
the static aspect of data stored in the
information system?
a. Entity-relationship model
b. Logical data model
c. Data and communication flow
d. Relational model
Q.4 data management technology consists of?
a. The physical hardware and media used
for storing data
b. The detailed, programmed instructions
that control and coordinate the
computer hardware
c. The software governing the
organisation of data on physical
storage media
d. The software and hardware used to
transfer data
Q.5 Which of the followings is said to be the
major point of the MERISE method?
a. Step by step progression
b. The formalization of data
c. Communication models
d. Processing models
Q.6 A database management system must
include which of the following components?
a. Data definition language
b. Data manipulation language
c. Data dictionary
d. A data redundancy protocol
THE UNIVERSITY OF BAMENDA
P.O. Box 39 Bambili
REPUBLIC OF CAMEROON
Peace-Work- Fatherland
www.schoolfaqs.net
2
Exercise 2: answer the following questions (4 marks)
1. Define the following term: information system, database. (1 mark)
2. what are the 3 activities of an IS that organizations use to control operations (1 mark)
3. list six important business objectives of information systems (1.5 marks)
4. which activity of an IS converts raw input into a meaningful form? (0.5 mark)
Exercise 3: modeling a process (5 marks)
Mr. MALONE, the CEO of JULLY VOYAGES, has decided to set up the reservation of seats for trips
on the internet from the 1
st
January 2018. To reserve, the customer has to fill an application that is
transmitted to a commercial agent. The commercial agent search for possibilities (availabilities) and
returns a proposal to the customer. If the proposal is accepted by the user, he notifies the commercial
agent that looks for different variables or options that can lead to a reduction (discount). In case of
possible reduction, the file proposal is sent to the General Manager that evaluates the possible
discount and returns the proposed reduced amount to the commercial agent. In case there is no
possible reduction, the commercial agent proceeds directly to the calculation of the net total amount.
That amount is communicated to the user. After the settlement of the amount, the commercial agent
confirms the reservation and returns a receipt with the initial file to the customer.
1. Draw (model) the diagram of the reservation process in JULLY VOYAGES. (4 marks).
2. Which type of process is the reservation process described here above? (1 mark)
Exercise 4: the information system a technical school (8 marks)
The principal of a technical secondary school wants to establish a database of the teaching activities of
his/her school. The management rules are as follows:
▪ The school is divided in 2 sections: industrial and commercial
▪ Each section has many specialties.
▪ Some specialties start only in the second cycles, some end in the first cycle, and some are
present in both first and second cycle.
▪ The classes are therefore divided according to the specialty and the level
▪ Subjects are also taught according to classes and specialties. The coefficients of those subjects
also vary according to the level of the class, the specialty and the section. E.g.: English is
taught in all classes but with different coefficients.
▪ Each subject has a weekly time allocation depending on the class, the level, and the specialty
of the class.
▪ Subjects are grouped in three categories: general education, professional education, and
complementary subjects.
▪ Teachers teach different subjects according to their specialty of training.
▪ Each student is registered in one and only one class
The principal wants a database able to produce for each class, the subjects taught, their
coefficients and the teachers teaching those subjects. For a subject, he wants to know all the
classes in which it is taught, the teachers and the different coefficients.
1) Establish the conceptual data model. (4 marks)
2) Establish the logical data model. (2 marks)
3) Write the queries in PostgreSQL to create your database tables. (2 marks)
www.schoolfaqs.net
