Selected Topic:
Warehouse management system
Purpose
The purpose of the individual system analysis and design project is to demonstrate student's ability to apply the knowledge learned in this course to a real-world project.
Topics Suggestions
The system analysis and design project must be realistic and it will be done using techniques covered in this course. The list of topics suggested for this project is as follows:
Ticket purchase system (airline, train, cruise, concert, or others)
Internet shopping sites (clothing, shoes, books, music, or others)
Local real estate agency system
Rental system (car, video, or others)
Warehouse management system
Student record system
Banking system
Insurance purchase system (life, medical, homeowner, or others)
Credit card management system
Library circulation system
The above list is meant to be suggestive and if you have an idea about a specific topic, please consult with me early to determine if it is suitable for the course.
You have to select and submit the project topic for instructor's approval by the end of Week 2.
Project Deliverables
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.
The deadline for the Individual Project can be found in the schedule section of the class syllabus.
The following layout format covering a title page and all three phases is recommended for the project.
Title page (project name, author, and date)
Phase 1: Requirement analysis
Problem definition
Issues
Objectives
Requirements
Constraints
Description of the proposed system
Logical model design
Data flow diagrams
Context diagram
Diagram 0
Diagram 1 (Diagram 1 is optional)
Descriptions of processes in each diagram
Descriptions of outputs/inputs/performance/security or controls
Specific requirements, if any (interface, operational, resource, performance, etc.)
Phase 2: System and database design
User interface
Design an overall user interface consisting of screens, commands, controls, and features to enable users to use the system.
How data will be input to the system?
The physical layout for each input
The input design and procedures
How data will be output from the system?
The physical layout for each output
The output design and procedures
Data design
Develop a plan for data organization, storage, updating, and retrieval.
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.
Entity-relationship diagrams
Data file storage and access
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)
Note that there is no other required software package except the MS Project software in this ITEC-630 course. As a result, you are only required to use the MS Project software to handle the scheduling part of the project and for other parts, you can use any word editing software or any drawing tools software.