SYSTEMS ANALYSIS AND DESIGN
COURSE OUTLINE
Hafid Agourram
WEDNESDAY: 18:00 to 21:00 E-mail: [email protected] ROOM: H303
PHONE: 822 9600 ex. 2715
OFFICE: Hamilton 218 OFFICE HOURS: MW: 9-11
INSTRUCTIONAL FOCUS:
This course covers in detail the information systems development process from the management perspective. The MIS application development process (the systems life cycle) will be covered in detail starting from the planning phase to the implementation phase. Students are required to do a term team project. The project consists on combining all IS development phases in a case. Project presentations are scheduled at the end of the semester. Details about the project will be provided during the third week of the course.
OBJECTIVE
The course is intended to help students understand the most popular methodology of information systems development and how to use both technological and business skills to IS development.
TEXTS AND READINGS:
Systems Analysis and Design, second edition, by Alan Dennis and Barbara Haley Wixon, Wiley, 2003. ISBN 0-471-073229
OTHER REFERENCES AND READING MATERIAL: As assigned or distributed in class. Several case studies of exercises will be used in class to facilitate the students' understanding and application of key theories and concepts. All students are expected to attend all classes in their entirety.
Students' work during the term will be evaluated on the following basis:
TYPE OF EVALUATION: Percentage
1. Mid Term Examination 20 %
2. Class Assignment (2) 15%
3. Team Project 30%
3. Final Examination 35%
TOTAL: 100%
CLASS PARTICIPATION:
Students’ participation during classroom sessions is highly encouraged. You are expected to read ahead and come to class prepared to discuss substantially any assigned material. Being well prepared will enable you to discuss assigned readings and cases and to engage constructively in experiential exercises.
DETAILED COURSE OUTLINE:
An outline of the topics to be covered during the course appears on the following page. It will allow you to gain an overview of the subject content and indicates the various reading for class preparation and due dates for assignment and examination.
Plagiarism is cheating! It is an offence under University policy and is dealt with severely. Students should ensure that all assignments and term work are authentic and properly credited and documented.
CLASS DATE CHAPTER TOPIC
1 January 9th Relationship between business processes, production processes and information systems 2 January 16th Chap 3
System development methodologies 3, 4 and 5 January 23rd,
30. Feb 6 and 13.
Chap 4, 5 Planning and Analysis phases of the SDLC (System development life cycle
Assignment 1 distributed on the 6th
6, 7 And 8
February and 27. March 12
Chap 6 System design Design strategy
Selecting a design strategy
Moving from logical to physical design
Assignment 1 submitted on the 13th Project initiation
Midterm on February the 20th
Architecture design
Elements of an architecture design Creating an architecture design Hardware and software specifications
User interface design
Principles of User Interface Design User Interface Design process Navigation design
Input Design Output Design
Assignment 2 distributed on the 27th
9 Marc h 19th March 26th
Chap 6 Database Storage Design Data storage format Optimizing data storage
Program Design
Structure chart
Program specification
Assignment 2 submitted on the 12th
10 April 02nd Chap 7, 8 Construction
Managing programming Designing tests Developing documentation Assignment 3 distributed on 11, 12 Chap 9 Installation Conversion Change management
Post implementation activities 13 April 09th Project presentations
VIII. Term Project (Group) Requirements:
Locate a small organization that uses an iformation System application that you can work on during this course. The system should be small and need further development. You may also find an organization which does not have and IS and desires to have one. Finally, you may come up with a virtual case to work on. A 2-pages document that indicates the following information must be handed in class.
• Name of each team member
• Phone number of each team member • The name of the organization
• A description of the business process or the existinig infomrmation system that you are • going to work on.
TASK:
Develop the information system that would support one or more
business processes. There should be at least 8 processes or modules in
the DFD. The data model must have at least 10 entities.
1 Prepare the system request for the IS.
2 Discuss the analysis strategy you will employ in the project (BPA, BPI, BPR)
3 Provide a detailed discussion on the project initiation step of the project planning phase 4 Provide a detailed discussion on the project management step of the project-planning
phase. To estimate the time required to implement the system, take an estimate of how long the planning phase would take and use the industry standards to estimate the timing for the remaining phases of the project. (20% planning, 30% analysis, 25% design, 25% implementation). You need to compare this time estimate to the actual time spent on the project.
5 Develop the context DFD of the business processes. 6 Develop the level 1 DFD
7 Develop the level 2 DFD’s for two processes. 8 Develop the level 1 physical DFD.
9 Think of possible entities in the case. Draw a table that shows each entity along with its corresponding attributes.
10 Develop the Entity relationship data model
11 Explain the relationships between the entities of the diagram (business rules).
12 Develop the corresponding database design model (ERD). You need to draw all the tables and clearly identify the keys. You need to justify the choice of the keys.
13 Develop the architecture design of the system 14 Describe the software and hardware specification 15 Develop the interface diagram of the system
16 Develop the structure chart of the system
17 Develop the program specification of each module in the structure chart
18 Implement the database using Access DBMS. You need to enter at least five rows in each table and connect the tables by their relationships.
19 Perform at least 10 different SQL instructions on the data in the database
20 Do not forget to give me a CD that contains your database as well as the queries.
Final Report should include: DUE: April 8th 2008 a. A cover page
b. Table of contents
c. The body: point 1 -20 above. d. A conclusion
