Information Systems Design and Management (CSCT3102)
Computer Science - COS
Semester: First Semester
Level: 300
Year: 2019
1/1
FIRST SEMESTER EXAMINATION
SCHOOL: H.T.T.T.C DEPARTMENT: COMPUTER SCIENCE
OPTION : FCS300 /ICT300 COURSE CODE: CSCT3102 &&CSCT3113:
COURSE TITLE: Information systems design and management &Design and analysis of Information Systems CREDIT VALUE: 3
DATE: March 2019 DURATION: 1:30 START TIME………END TIME………………
LECTURER: Mr. DJAMEN NYONKEU Gildas
Instruction: Answer all questions.
Question 1: (5mks)
a- Define Information system(IS) and give an example of IS: (4mks)
b- What are the components of an IS
c- Differentiate between system analyst and Project Manager
d- What is SDLC and what is it used for?
e- What are the different types of SDLC methodologies?
Question 2: The goal of this exercise is to design an Entity Relationship (ER) model for a college database
Specifications:(2+2+2+2+4=12)
− A college contains many departments
− Each department can offer any number of courses
− Many instructors can work in a department
− An instructor can work only in one department
− For each department there is a Head
− An instructor can be head of only one department
− Each instructor can take any number of courses
− A course can be taken by only one instructor
− A student can enroll for any number of courses
− Each course can have any number of students
1. Identify the Entities
2. Identify the key attributes of each entities
3. Identify other relevant attributes
4. Identify the relationships between entities
5. Draw complete ER diagram
Question 3: (6+6+6=18)
Assume there is a library system with the following properties. The library contains one or several copies of
the same book. Every copy of a book has a copy number and is located at a specific location in a shelf. A copy
is identified by the copy number and the ISBN number of the book. Every book has a unique ISBN, a
publication year, a title, an author, and a number of pages. Books are published by publishers. A publisher has
a name as well as a location. Within the library system, books are assigned to one or several categories. A
category can be a subcategory of exactly one other category. A category has a name and no further properties.
Each reader needs to provide his/her family name, his/her first name, his/her city, and his/her date of birth to
register at the library. Each reader gets a unique reader number. Readers borrow copies of books. Upon
borrowing the return date is stored.
a) Design the context diagram (level-0 DFD) of this library system.
b) Design the level-1 DFD of this library system by decomposing the level-0 DFD.
c) Create an ER diagram of this library system
“A good presentation of the paper is advisable”
REPUBLIC OF CAMEROON
Peace – Work – Fatherland
THE UNIVERSITY OF BAMENDA
P.O. BOX BAMBILI
www.schoolfaqs.net
