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 realworld project.
Topics Suggestions

1. 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:
   a) Ticket purchase system (airline, train, cruise, concert, or others)
   b) Internet shopping sites (clothing, shoes, books, music, or others)
   c) Local real estate agency system
   d) Rental system (car, video, or others)
   e) Warehouse management system
   f) Student record system
   g) Banking system
   h) Insurance purchase system (life, medical, homeowner, or others)
   i) Credit card management system
   j) Library circulation system
2. The above list is meant to be suggestive and if you have an idea about a specific topic, please consult with your instructor early to determine if it is suitable
   for the course.
3. 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
   A. Problem definition
   B. Issues
   C. Objectives
   D. Requirements
   E. Constraints
   F. Descriiption of the proposed system
   G. Logical model design
4. Data flow diagrams
   • Context diagram
   • Diagram 0
   o Diagram 1 (Diagram 1 is optional)
   • Descriiptions of processes in each diagram
5. Descriiptions 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 use the system.
6. How data will be input to the system?
   • The physical layout for each input
   • The input design and procedures
7. 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.
8. 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.
9. Entity-relationship diagrams
10. 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.