MCS-014 :: Systems Analysis and Design
Objectives
The objective of the course is to enable the student to
• Identify the software projects in an organization after studying various functionalities in the organization.
• Structure various requirements
• Do the design
• Select the best method to develop the system
• Implement and maintain the system
• Acquaint self with different quality standards
• Plan and design Management Information System(s).
Syllabus
Block 1: Introduction to Systems Development
Unit 1: Introduction to SAD
• Fundamentals of System
o Important Terms related to Systems
o Classification of Systems
o Real Life Business Subsystems
• Real Time Systems
• Distributed Systems
• Development of a successful System
• Various Approaches for development of Information Systems
o Structured Analysis and Design Approach
o Prototype
o Joint Application Development
Unit 2: Systems Analyst-A Profession
• Why do Businesses need Systems Analysts?
• Users
• Analysts in various functional areas
o Systems Analyst in Traditional Business
o Systems Analyst in Modern Business
• Role of a Systems Analyst
• Duties of a Systems Analyst
• Qualifications of a Systems Analyst
o Analytical Skills
o Technical Skills
o Management Skills
o Interpersonal Skills
Unit 3: Process of System Development
• Systems Development Life Cycle
• Phases of SDLC
o Project Identification and
Selection
o Project Initiation and planning
o Analysis
o Logical Design
o Physical Design
o Implementation
o Maintenance
• Product of SDLC Phases
• Approaches to Development
o Prototyping
o Joint Application Design
o Participatory Design
• Case Study
Unit 4: Introduction to Documentation of Systems
• Concepts and process of
• Documentation
• Types of Documentation
o System Requirements Specification
o System Design Specification
o Test Design Document
o User Manual
• Different Standard for Documentation
• Documentation and Quality of Software
• Good Practices for Documentation
Block 2: Planning and Designing Systems
Unit 5 : Process of System Planning
• Fact finding Techniques
o Interviews
o Group Discussion
o Site Visits
o Presentations
o Questionnaires
• Issues involved in Feasibility Study
o Technical Feasibility
o Operational Feasibility
o Economic Feasibility
o Legal Feasibility
• Cost Benefit Analysis
• Preparing Schedule
• Gathering Requirements of System
o Joint Application Development
o Prototyping
Unit 6: Modular and Structured Design
• Design Principles
o Top Down Design
o Bottom Up Design
• Structure Charts
• Modularity
o Goals of Design
o Coupling
o Cohesion
Unit 7: System Design and Modelling
• Logical and Physical Design
• Process Modeling
o Data Flow Diagrams
• Data Modeling
o E-R Diagrams
• Process Specification Tools
o Decision Tables
o Decision Trees
o Notation Structured English
• Data Dictionary
Block 3: More Design Issues and CASE Tools
Unit 8: Forms and Reports Design
• Forms
o Importance of Forms
• Reports
o Importance of Reports
• Differences between Forms and
Reports
• Process of Designing Forms and
Reports
• Deliverables and Outcomes
• Design Specifications
o Narrative Overviews
o Sample Design
o Testing and Usability Assessment
• Types of Information
o Internal Information
o External Information
o Turnaround Document
• General Formatting Guidelines
o Meaningful Titles
o Meaningful Information
o Balanced Layout
o Easy Navigation
• Guidelines for Displaying Contents
o Highlight Information
o Using Colour
o Displaying Text
o Designing Tables and Lists
• Criteria for Form Design
o Organization
o Consistency
o Completeness
o Flexible Entry
o Economy
• Criteria for Report Design
o Relevance
o Accuracy
o Clarity
o Timeliness
o Cost
Unit 9: Physical File Design and Data base Design
• Introduction to Database design
o Flat files vs. Database
o Steps in Database Design
o E-R model to Database Design
o Inputs to Physical Database Design
o Guidelines for Database Design
• Design of Data Base Fields
o Types of Fields
o Rules for Naming Tables and Fields
• Design of Physical Records
• Design of Physical Files
o Types of Files
o File Organization
• Design of Database
• Case Study
Unit 10: CASE Tools for Systems Development
• Use of CASE tools by organizations
o Definition of CASE Tools
o Use of CASE tools by Organizations
o Role of CASE Tools
o Advantages of CASE Tools
o Disadvantages of CASE Tools
• Components of CASE
o Types of CASE Tools
o Classification of CASE Tools
o Reverse and Forward Engineering
• Visual and Emerging CASE tools
o Traditional systems development and CASE based systems development
o CASE environment
o Emerging CASE Tools
o Objected oriented CASE tools
o Creating documentation and reports using CASE tools
o Creating and executable prototype using Object Oriented CASE tools
o Sequence Diagrams
Block 4: Implementation and Security of Systems & MIS
Unit 11: Implementation and Maintenance of Systems
• Implementation of Systems
o Conducting System Tests
o Preparing Conversion Plan
o Installing Databases
o Training the end users
o Preparation of User Manual
o Converting to the new System
• Maintenance of Systems
o Different Maintenance activities
o Issues involved in Maintenance
Unit 12: Audit and Security of Computer Systems
• Definition of Audit
o Objectives of Audit
o Responsibility and Authority of the System Auditor
o Confidentiality
o Audit Planning
• Audit of Transactions on Computer
o Transaction Audit
o Audit of Computer Security
o Audit of Application
o Benefits of Audit
• Computer Assisted Audit Techniques
o Audit Software
o Test Data
o Audit Expert Systems
o Audit Trail
• Computer System and Security issues
o Analysis of Threats and Risks
o Recovering from Disasters
o Planning the contingencies
o Viruses
• Concurrent Audit Techniques
o Need for Concurrent Audit
o Techniques
o An Integrated Test Facility
o Techniques
o The Snapshot Techniques
o SCARF
o Continuous and Intermittent
o Simulation Technique
Unit 13: Management Information Systems
• Role of MIS in an organization
• Different kinds of Information Systems
o Transaction Processing System
o Management Information
o System
o Decision Support System
o Expert System