Outsourcing Proposal

1. Team RTFM: Paul Reit, Nick Chase, Keaton Freude, Lee Mann Outsourcing Proposal

2. Introduction • Scope • Project Behavior • Requirements

3. Scope • The contracted programmer will need to be able to retrieve data from the databaseto populate a leaderboard • The programmer will also have to create functions to store data from users after games have ended

4. ER Diagram

5. Project Behavior • The users will select a map to get information about • The server will be queried obtaining all scores and player information for that map • Data is returned in an array of structs containing the username, character name, and score • After users complete a map, their data will be stored in the database

6. Functional Requirements • The system should retrieve player data • The system should retrieve the player’s account name • The system should retrieve the player’s character name • The system should retrieve the player’s character’s score • The returned data should be in an array of structures • The account name will be a string • The character name will be a string • The character score will be an integer • The system should update the database with player data • The retrieving and updating should be done in one function • The function should be SQL Injection safe • The function will be passed a map ID integer from 0 to N

7. Non-Functional Requirements • The system should communicate between a C# program and an SQL Server 2008 database • The database and the C# program will be on the same host machine

8. CONCLUSION • Database entry/retrieval functions • Array of Structs • Two strings • Integer • Questions?