Dan Spinosa dspinosa 2/1/05 cs190 List of Requirements __Project__ The Football Idea __Overview__ The football program here mails out over 10,000 recruiting questionaires to prospective athletes on an annual basis. They receive about a 30% return rate. This translates to over 3,000 forms, each with over 50 fields filled out, that must be manually entered into the database. After the information is entered into the database it is used by the football staff to contact, rank, and organize their recruits. The questionaire is available online as a pdf document but this must still be printed, filled out, mailed, and enetered manually. As computer access and skills of prospective athletes incerease it would be advantageous to allow the form to be filled out electornically. The recruiting coordinator Donna Fanion requested a solution to allow students to fill out the form on the web and have its submission entered directly into the recruiting database. __Requirements__ [1-3] = [highest-lowest] priority [1] Web based form, compatible with all major browsers, that is intuitive and easy to use [1] Form may be generated by any server but linked to from the Brown Football web page [2] Design should be made for and tested against high school football players, the primary users of the web based form [1] Form must collect all information currently collected on the Brown University Football Questionaire [1] Input type should be constrained client-side [1] Submission should be automatically checked (server-side) for required information as defined by recruiting office [2] Auto-reply email and "thank you" page should assure user the data was sucessfully submitted [1] Form submission should initiate input of the information to the currently used FileMaker DB (they *love* filemaker and do not want to change) [1] Form need not be hosted from same server as the database so long as reliable communication can be provided [2] Duplicate entries must be marked for review by recruiting office personel [2] Security must be provided as sensitive information (including SSN) will be entered electronically [3] An acceptable digital signature (by athelete and/or parent/guardian) must be obtained and stored [1] Web based form entry into database must not interfere with continued manual information entry, and vice-versa [1] System should be able to handle hundreds of multiple simultaneous form submissions, including bad submission and duplications [2] Database must be moved to secure, redundant storage, as many paper copies will be eliminated [2] Databse backup should be automated [3] (extension) Create a Brown Football prospective athlete personal info desk -- individualized for each prospect, easily and automatically customized and updated with changes to filemaker db -- organize and maintain communication between the prospect and the coaches -- organize and provide reminders of invitations/dates - recruting camps - summer day - official and unnofficial visits... -- confirm receipt or reqeust of materials (videos, workout plans, etc) -- maintain contact information in one easy to find, organized place __external dependencies__ The website administrator we need to deal with to attain final implementation of the system may not respond to our requests in a timely manner. The football office was quick to inform us that the webmaster has not updated a listing of a coach who has not worked at Brown for over a year. The entire system may be implemented without any need for the webmaster. He is only needed to make the service publicly available on the Football webpage. Cooperation from the football office will be required to obtain further specs of the exact makeup of their computer system and filemaker DB implementation. We then need access to a compatible database (either theirs or a mock-up) for the duration of the development process. Ultimately we will need a full time host for the database and web form. It is unclear at this time exactly on whom that will depend.