The system analysis and design project must be realistic and it will be done using techniques covered in this course.
The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, students are required to use the MS Project software for their project schedule.
Phase 1: Requirement analysis
A. Problem definition
B. Issues
C. Objectives
D. Requirements
E. Constraints
F. Description of the proposed system
G. Logical model design
1. Data flow diagrams
• Context diagram
• Diagram 0
o Diagram 1 (Diagram 1 is optional)
• Descriptions of processes in each diagram
2. Descriptions of outputs/inputs/performance/security or controls
H. Specific requirements, if any (interface, operational, resource, performance, etc.)
Phase 2: System and database design
A. User interface
Design an overall user interface consisting of screens, commands, controls, and features to
enable users to u
se the system.
1. How data will be input to the system?
• The physical layout for each input
• The input design and procedures
2. How data will be output from the system?
• The physical layout for each output
• The output design and procedures
B. Data design
Develop a plan for data organization, storage, updating, and retrieval.
1. Database design
• Database tables with their attributes should be presented
• Primary key(s) should be identified in each table, if any
• Three steps of normalization should be included.
2. Entity-relationship diagrams
3. Data file storage and access
C. System architecture
Determine the architecture of the system as Web-based interface, client/server architecture,
Internet/Intranet interface, network configuration, etc.
Phase 3: Project plan
A list of tasks or activities needed for implementing the proposed system
Estimating completion time and costs
A project schedule for performing those activities (Gantt charts or PERT charts)