Appendix E: Task Assignments Appendix F: Test Plan …………………………………………………………….. 87 Appendix G: Test Results Section 1: Technical Review Results Section 2: Unit Level Test Results (Sample) Section 3: System Level Test Results ……………………………………. 104 3.1: Integration Test Results ………………………………………. 104 3.2: Browser Compatibility Test Results …………………………. 110 3.3: Usability Test Results ………………………………………… 114 Section 4: Acceptance Test Results ………………………………………. 119 Section 5: Defect Log …………………………………………………….. 123 Appendix H: Data Dictionary …………………………………………………….. 125 Appendix I: Sample Source Code ………………………………………………… 128 Appendix J: Directory Structure ………………………………………………….. 130 Appendix K: Configuration …………………………………………………. 132 Appendix L: Meeting Minutes ……………………………………………………. 133 Appendix M: School Event Coordinator User Guide …………………………….. 149 Appendix N: Site Administrator User Guide Appendix O: Faculty Presentation LIST OF FIGURES Figure 1: Projected Schedule ………………………………………………… 21
APPENDIX B CLIENT AGREEMENT This is an agreement between … 1. SERVICES RENDERED. TEAM agrees to perform following Web design services: Website design Simple graphic design including logos, navigation bar, buttons, etc. Home page, sign-up page, page, terms of service page, privacy policy page Website application that allows for the sale of school event tickets to the public Search for school and event using state and city, zip code or school ID. Shopping cart that allows the purchase of school tickets via PayPal confirmation of all orders Management area for schools to enter events and tickets Management area for Site Administrator to manage schools All pages, graphics, coding, design and work to run the site including not more than 40 programmatically generated web pages Database design
invoice varchar 14 N Random generated to be used at the event to validate the tickets. Each ticket will have a unique key that defines that very specific ticket (event, date and quantity). This will be used to validate tickets at the event and ensure duplicate tickets are not printed off. sales decimal 7,2 N Sum of all items sales transaction varchar 80 N Transaction ID from Paypal sales email varchar 80 N Valid email address Email of customer sales date datetime N Must be a current date/time Sales date/time sales firstname varchar 25 N Alpha characters, periods and spaces First name of customer lastname varchar 25 N Alpha characters, periods and spaces Last name of customer address varchar 40 Alphanumeric characters, periods and spaces Address of buyer from Paypal sales city varchar 25 Alpha characters City of buyer from Paypal state varchar 25 characters State of buyer from Paypal sales zip varchar 5 Numbers Zip of buyer from Paypal sales varchar 12 N Numbers, dashes, periods and parenthesis Phone of customer sales validated char 1 Y/N Set to 'Y' once Paypal IPN returns salesitems salesitemid int 11 N System generated unique identifier of this specific ticket (event, date and quantity) salesitems salesid int 11 N fk Foreign Key to sales record salesitems ticketid int 11 N fk Foreign Key to ticket record salesitems quantity tiny int 4 N Number of tickets purchased
salesitems pricelevel char 1 N 1, 2 or 3 Price level (general, student, etc) tickets ticketid int 11 N System generated unique identifier tickets eventid int 11 N fk Foreign Key to event tickets tickettitle varchar 255 N Alphanumeric, spaces dashes and slashes for this type of ticket (Balcony seats, etc.) tickets ticketsavailabile small int 6 N 0 Can be 0 (unlimited) Number of tickets available (if blank, unlimited) tickets ticketssold small int 6 N 0 Numeric Number of tickets sold so far for this ticket type tickets price1 decimal 5,2 N for a level 1 ticket (general, student, etc) tickets price2 decimal 5,2 for a level 2 ticket tickets price3 decimal 5,2 Price for a level 3 ticket tickets ticketdescription text 4000 N Cleaned for cross site scripting. HTML allowed, no javascript. Description of this ticket events eventid int 11 N System generated events schoolid int 11 N fk Foreign Key events eventname varchar 80 N Alpha characters, periods and spaces Name of the (Holiday Concert, etc) events eventdescription text 4000 N Cleaned for cross site scripting. HTML allowed, no javascript. Description of the event schools schoolid int 11 N System generated schools stateid small int 6 N fk Foreign Key (State of the school) schools activated char 1 N Y/N Determins if the account has been activated by the school schools approved char 1 N Y/N Determins if the account has been approved by the site admin schools schoolcode char 9 N System generated unique code used to link directly to the school page schools schoolname varchar 80 N Alpha characters, periods and spaces Name of the school (Valley View Elementary, etc)
Minutes: 3/16/11 6:30 – 8:00 PM PST Participation: ALL Open forum - Nothing noted. Eric up-date: Working on an Executive Summary Continuing with system interface and design edits Will up-date Team Capabilities Will write System metrics (few academic paragraphs) Detailed Milestone 5 tasking Final and exhaustive (and final) comments on deviations and identify slippage post testing Researching all remaining APA formatting questions Capstone binding looks to be more expensive than NU's quoted $50 per copy 3. George up-date: Nearly finished with all ad hoc test results / comments Plans web interface design / adjustment complete by Sat, March 19 Leave quickly written schools for other testing. Clean-up should happen week before demo. 4. Chris up-date: Test on schedule Successfully folding ad hoc test results into formal documentation Looking at a couple different ways to tackle the "Evaluation of Usability Tests" requirement
Page 5 Add and Activate a Ticket Type Create a New “Add Tickets” as shown in Figure 5. Figure 5 Click “Add a Ticket Type” as shown in Figure 6. Figure 6 Enter all ticket information as shown in Figure 7, to include a title, description, total available for purchase, the price for “General Admission” as well as separate price levels for “Students” and “Seniors” (latter two are optional). Page 6 Figure 7 By default, an event is not active until the “Toggle” link displays “Yes” as shown in Figure 8. Click “Toggle” when ready to advertise tickets to the public via the Home Page of SchoolTicketsOnline.com. Figure 8
Table of Contents Purpose …………………………………………………………………………… 2 Web Browser Requirements ……………………………………………………… 2 Log in …………………………………………………………………………….. 3 Activate a School …………………………………………………………………. 4 Delete a School …………………………………………………………………… 5 Disable a School ………………………………………………………………….. 6 Full Backup of Site ………………………………………………………………. 7 Partial Backup of Home Directory ……………………………………………….. 9 Backup of Databases …………………………………………….……… 12 Restore the Home Directory ………………………………………………. ……... 14 Restore MySQL Databases ……………………………………………………….. 16 Purpose
“Toggle” when ready to make the school searchable by the general public via the Home Page of SchoolTicketsOnline.com. Figure 2 Page 4 Delete a School Log-in as the Site Administrator. Find the school listed on the Site Administrator Control Panel as shown in Figure 3. Click “Delete.” Figure 3
Page 5 Disable a School By default, a school is not active until the “Toggle” link displays “Yes” under the Active column as shown in Figure 4. Figure 4 If the school is active, click “Toggle” when ready to disable the school. “No” will display. The school will no longer be searchable by the general public via the Home Page of SchoolTicketsOnline.com.
Figure 20 Page 15 Restore MySQL Databases Follow steps 1 – 4 in “Restore the Home Directory.” Click “MySQL Database” as shown in Figure 21. Figure 21 Click “Browse” as shown in Figure 22. Find and select the backup file “school_tickets.sql.” Click “Upload” to start the restoration of the MySQL databases as shown in Figure 22. Figure 22 Page 16