Document Version 1.2
January 20, 2005
Moki Mac River Expeditions, a small family-owned company in Salt Lake City, inspired RivX. Moki Mac uses a system called Breeze to schedule their river expeditions. Breeze runs on their three Windows95 machines and uses an old Microsoft database called FoxPro. The would like to upgrade, but the company that developed Breeze has gone out of business. After discussing Moki Mac's situation with the team, we immediately saw a project possibility that could include development in several areas of interest: desktop application development, database design, and web application development. We also recognized that other companies like Moki Mac that schedule outdoor recreation tours and expeditions will need a replacement for Breeze.
The proposed project is a system for scheduling outdoor recreational expeditions. This system will use some of the Breeze functionality as a starting point. The core system task is maintaining customer and scheduling information in a database. The system also provides functionality for billing invoices, printing out general business reports, tracking leads, and printing labels for mailings. We see great potential in exceeding the Breeze system's functionality by integrating scheduling with a web site as well as web based forms for customers to schedule expeditions. By adding a web application piece to the over all system, outdoor recreation companies have fewer barriers between them and their customers. Currently Moki Mac receives the largest number of inquiries and leads through their web site via email.
Though Moki Mac provided the inspiration for this project, Professor Henderson will serve as the customer. Our project goal will be to provide a general solution not specific to any one recreational sport, type, or company.
The projects that our team would like to work on, in order from highest to lowest preference, are as follows:
| Project | Shawn | John | Gib | Kyungseog | Total |
|---|---|---|---|---|---|
| RIV X | 10 | 10 | 10 | 9 | 39 |
In order to be successful on this project, our team will need the ability to develop a desktop and web application using C# and the .Net Framework. We also need to be proficient in administrating an SQL database server and designing a normalized relational database structure for the system. We believe that as a group we meet these qualifications. As a group we have experience in the following areas:
We believe that these skills will be adequate to successfully complete our project. Furthermore, we have experience working in teams and groups, and we feel we are prepared to combine our skills to make this project a successful team effort.
In order to run our web application, we will need a server that can run both .net programs and also access an SQL database. We currently don't have a server that can run .NET programs, however we do have experience in setting up a server, and we hope to aquire one soon. We are creating a general program that can be used by any company, but at the same time we are building the application based on the needs of a single company. Therefore the specific needs of the company might make the program less available for general use. Another consideration is that the system will need to be secure, and we don't have a lot of experience in security.
Our high-level vision of the project includes four components: an SQL database, a compiled C# class library that maps tables to objects, a C# .NET desktop application, and a ASP .NET web application. We intend to use the class library as the logic layer between the database and the presentation of the desktop and web applications.
Specific things to be done:
A majority of these tasks can be accomplished through discussions with the company and experimentation with their existing system.
We currently need to decide where the database server will reside and how much of the application functionality resides on the Internet.
We also need to decide how to break up the work among our team members.
| version | date | description |
|---|---|---|
| 1.0 | 12 Jan 2005 | - Created project bid document. |
| 1.1 | 13 Jan 2005 |
- Strengths and qualification for each project added
- Explanation of each project's approach and consideration |
| 1.2 | 20 Jan 2005 |
- More details added to Strengths and qualification
- More details added to explanation of each project's approach and consideration |