This system appears very simple at first glance but is tricky when you understand the details of the activity, so it is very important that you understand the activity we are involved in (debate) and how a debate tournament runs.
Debate tournaments are composed of two person teams debating for distinct schools. Each school can have many two person teams. Each tournament has many schools. A typical large debate tournament will have around 300 teams and 150 debates each round. Each tournament has 6-8 'preliminary' rounds after which some number of teams advance to debate in 'outrounds' where winners debate winners until there is a final round with one winner. Each debate can have from 1-7 judges. Each two person team will switch sides. In preliminary rounds there will be an even number of debates and an even number of affirmative and negative rounds for each team. In outrounds sides are determined in more complex ways or sometimes randomly.
Fundamentally this system tracks a few important things:
-who debated who when and who won. If more than one judge, how many judges voted for each side.
-what our competitors are saying in their debate rounds. This will include several free text fields of varying length and must be able to accept any character input.
-where their evidence comes from. same as above but will need to be capable of storing several thousand characters.
-who they have debated - both what teams from our school and what teams from other schools
-quick view showing all teams with wins and losses so far during the tournament
I will provide screenshot mockups.
I believe there will need to be several data entry screens and several reporting/ viewing screens and a pretty robust search screen that can search on any combination of the areas described, including full-text search into the "what they are saying" part and the "where their evdidence comes from" part
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work. Must be implemented using a Visual Basic language (ASP, ASP.NET, client side VB or VB.NET or any combination) and querying a MS-SQL database. C# and Java languages are not acceptable.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment or seller must agree to fully support buyer during installation process.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request, if nescessary.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
** -**it must be replicated to each client in someways - they must be able to access all the information without an internet connection and be able to enter their reports without being connected. This is the most important part and the framework for the entire system. I would consider bids on a limited implementation of just this functionality.**
-it must upload to a central database server
-it must run on windows 98, XP, 2000 and either have a web interface for Mac users or have a Mac side client.
-must be possible to design data export to Word or Excel in the futur
-should probably run on MSSQL Server