80 likes | 296 Vues
Team RTFM: Paul Reit , Nick Chase, Keaton Freude , Lee Mann. Outsourcing Proposal. Introduction. Scope Project Behavior Requirements. Scope. The contracted programmer will need to be able to retrieve data from the database to populate a leaderboard
E N D
Team RTFM: Paul Reit, Nick Chase, Keaton Freude, Lee Mann Outsourcing Proposal
Introduction • Scope • Project Behavior • Requirements
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
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
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
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
CONCLUSION • Database entry/retrieval functions • Array of Structs • Two strings • Integer • Questions?