Transcript ppt - SIUE Computer Science

The Juggernaut Team

Tyler Douthitt
 Project
Manager
 Lead Website Developer

Mike Harman
 Lead

Programmer
Eric Rakers
 Lead
Documenter
 Lead Analyst
Client
Office of Student Financial Aid
 Contacts:

Berry – Director of the Office of
Student Financial Aid
 Martin Mokoosio – Server Maintenance
 Sharon
The Problem

Financial aid representatives spend too
much time dealing with repetitive
questions
 Phone
calls
 Email

Time and Staff Intensive
The Solution
 Web-based
 Interactive
 Frequently
 Asked
 Question
 System
InterFAQs Overview
Web client module that stores FAQs
(frequently asked questions) and allows a
normal website visitor to browse and
search through them
 Administration module that allows
authorized financial aid representatives to
add, modify, and delete the FAQs

InterFAQs Overview (cont)
Dynamic solution to a dynamic problem
 A no-cost solution to a commercial
problem

Requirements

Functional
 FAQ
Search
 Browsing capabilities
 Ability to ask a question
 Web-based administration
 Active and inactive questions
 FAQs belong to Topics
Requirements

Nonfunctional
 Follow
design of existing website
 Secure & Stable
 Run on Windows 2000 Server
 Use PHP and MySql
Interfaces

2 Interface Groups
 InterFAQs

Web Client
Accessible to the general public
 InterFAQs Admin

Only accessible via 2 step login
 Available

Module
at
http://www.interfaqs.com/prototypes.php
ER Diagram
Architecture

Programming Languages
 HTML

Hypertext Markup Language
 PHP

PHP: Hypertext Preprocessor
 MySql

My Server Query Language
Architecture

Access Control and Security
 Server
Security
 Application Security

Web Client


Careful with user input
Admin Module
2 step login
 Passwords stored as md5 equivalent

Development Tools

Macromedia Dreamweaver MX
 File
check in/out
 Excellent for PHP and MySql coding

www.interfaqs.com
 Test
Server
 Runs same versions of PHP and MySql as
financial aid servers
Lifecycle

Modified Waterfall (Shashimi)
Gantt Chart (Overview)
Gantt Chart (Full)
Deliverables
 Feb. 25th, 2005
 InterFAQs Version .25 Complete
 Web Client Delivered
 Apr. 1st, 2005
 InterFAQs Version .75 Complete
 Administration Module Delivered
 Apr. 11th, 2005
 InterFAQs Version .9 Beta
 Entire application BEFORE extensive testing
 Apr. 29th, 2005
 InterFAQs Version 1 Final Release
Risk Management

Search algorithm
 Trouble

with implementation, efficiency
Remote Development
 Ability
to develop and test code outside of
Engineering building

Learning Curve
 PHP

& HTML
Delay in Client Communication
 How
well clients respond when info is needed
Status

Where do we stand now
 Design
finished
 Interfaces reviewed by clients

What’s next?
 Become
PHP & HTML experts
 Ready, set, implement!!!
Questions???
Web Client Main
Web Client Browse By Topic
Web Client Search
Web Client Search Results
Web Client Answer
Web Client Ask a Question
Web Client Send Question
Admin Module Login
Admin Module Main
Admin Module Inactive Question
Admin Module Orphaned Questions
Admin Module Pending Questions
Admin Module Add Question
Admin Module Topics Main
Admin Module Topic Tree Priority
Admin Module User Administration
Admin Module My Account
Admin Module Backup Main
Admin Module Backup
Database

Search Query
 Use

MySql’s Boolean Full-Text Search
SELECT qa.question, qa.answer,
MATCH(qa.question, qa.answer)
AGAINST (‘computer science’ IN BOOLEAN
MODE) AS rel
FROM QuestionInfo qi, QuestionAnswer qa
WHERE MATCH(qa.question, qa.answer) AND
qi.questionId = qa.questionId
AGAINST (‘computer science' IN BOOLEAN MODE)
ORDER BY rel DESC, qi.treePriority
LIMIT 0, 10