CSC 3700 - Software Analysis and Design
Project Proposal (Fall
2004)
|
Professor: |
Dr. Srini Ramaswamy |
|
Team: |
Arlene Chisley-Wade Patricia Humble Richard Bushart |
|
Team Name: |
APR |
|
Project: |
APR Training
Solutions |
|
Languages: |
HTML, SQL, Perl, JavaScript, and C++ |
|
Team Meetings: |
Tuesdays & Thursdays at 3:00 p.m. EST via conference calls |
|
Web Site: |
|
|
E-mail: |
achisleywade@att.net (Arlene) pat.humble@chattanoogastate.edu (Patricia) RBushart@midsouth.rr.com (Richard) |
|
Date: |
September 15, 2004 |
|
Member Responsibilities: |
|
|
Design: |
|
|
Richard: |
Creation of databases. |
|
Arlene: |
Creation of web site and forms. |
|
Pat: |
Creation of data access pages to interact between web site and database that resides on a server. |
|
Documentation: |
|
|
Richard: |
Flow Chart and other diagrams. |
|
Arlene: |
Web Site maintenance and updating. |
|
Pat: |
Design and development content. |
Project Proposal:
Our project proposal is for APR to design an Online
Training learning management system tied to a multi-user database. This system will be a web application with
an SQL Server database. This system
will be used by APR to keep track of students, companies, courses, instructors
and billing information to successfully maintain an e-commerce web site. One of the major challenges will be getting
the courses that businesses need to keep their employees technical skillful to
compete in today’s market. A second
challenge will be keeping the courses updated with the latest technology to help
students enhance their skills. A third challenge will be keeping the courses
updated and available 24 hours a day, 7 days a week.
Software Design Proposal:
When entering our web site the user
will originally be able to see a listing and brief description of the courses
we offer, basic information about our company, a login link to the courses, any
announcements we might share with students, companies or new clients and a link
to pay fees online by credit card.
Once the student uses the login link
from the home page they will be able to enroll and start the learning
process. Our online courses will be
available anytime day or night at our student’s convenience. Our courses will offer all of the available
material to study and learn many of today’s well known computer software, take
practice tests and quizzes, and communicate with an instructor for any
questions or problems that might experience.
In the enrolling process we will collect the basic information about our
clients for example, first and last name, address, date of birth, phone number,
city, state, e-mail address and the company they work for. When the student click on the submit button
if the information is not all filled in they will receive an error message
stating they must fill in the items they left blank. They will then be enrolled in the course they have selected and
sent an e-mail with a username and password to access the system from the same
login link.
There will be a table company that
will keep the company name, address, phone number, fax, e-mail address to allow
access for a company to be responsible for a client’s training. If companies are willing to reimburse
clients their training fees we will provide information to the company via the
student’s request that their progress can be sent to their company.
We will encourage our instructors to
keep their courses up-to-date and use all of the new technology available. This technology could include e-mail, chat
rooms, discussion postings, and video conferencing. We will keep a training software table in the database with these
fields course ID, course title, description, and instructor to be maintained by
database administrator. We will also
keep a table on instructors’ which will include the following information name,
address, city, state, e-mail address, phone, fax, and cell numbers along with
courses they can teach.
We will also have available after
courses are finished surveys and polls to find out what about the course could
be improved. These surveys and polls
will help us identify problems with courses or instructors. Also they will provide beneficial feedback
to the APR Company on our web page, courses, and instructors.
Information Flow Diagram:

Company Organizational
Diagram:

Data Flow Diagram:

Conclusion:
We hope this proposal from the APR
team meets the qualifications that you have set forth for the Software Analysis
class. We will gladly appreciate any
comments or suggestions you might have.
We do have a couple of questions concerning the web site and the
development of our software. Are we to
produce an actual live training web site and be able to deliver courses? According to the web site we can’t install
several Perl scripts that we will need to make this a fully functional product
and they do not have the space to accommodate our database. Can we package the full program as a zip
file and send it to you to run.