Database, Businss logic & Web Interface

Outstanding end to end web development skills using MySQL and any web interface technology. Experience in pulling data from multiple sources/ external databases. Server side programming including databases and business logic. ## Deliverables * * *This broadcast message was sent to all bidders on Monday Feb 23, 2009 4:55:10 PM: Elaborate requirements below. Please respond with timeline and a quote. General: The overall project will have 3 parts……. 1) Database 2) Calculation Modules (in Java, C++ etc.) 3) Web Interface Database • The Database shall pull data from the given vendor’s database or system, each night. Data consists of two fields for names, two for day and date and one for value. MySQL database is suggested. • Once the initial data is stored, up to the latest date on which our database is populated, nightly refreshing shall happen only for the last day’s data, and not the entire database. • The capacity of the database for Phase I shall be sufficient to store about 20,000 names and related raw and calculated data. • There are about 20 simple relational database tables in the database, each containing about 7 to 15 data elements. Calculation Engine Modules • The calculation engine modules simply pull data from the Database Tables and fill the derived data back into appropriate tables in the same database. • The calculations in each module use basic arithmetical and standard statistical formulae or Excel type functions. These do not require complex operators or coding. Web Interface • The web interface has several separate pages corresponding to a directory of services. • Power Point designed mock-ups and place holder text for all web pages shall be provided by me, in addition to regular communication with the developer. • Most pages are passive, fixed text items. All pages have dummy boxes, displays, buttons, text and contents. • Only 4 buttons on the web pages are active. The information entered here by the user should be exported to the Database. • The active web page has 3 boxes to allow a user to type in (or select from drop down list) a maximum of 5 items or names or chose the default setting. • When all information in the three buttons is filled out, and a GO button is clicked, the active web page shall quickly refresh and display a graph and table. The graph is an X-Y graph with bars, colored dots, lines and labels along the axes and inside the graph. • When the mouse is held on a dot or line in the graph, a small drop down window shall show a name, and data values corresponding to that point. • Sufficient IP Address tracking and visitor counting services shall be provided on each page and sections. The clicking data for various pages and sections shall be stored by date, IP Address, or other Registration Information, in the database, in a separate table. This will be useful for analyzing user response and acceptance. Initial Trial Data Initial historical data up to a current date will be provided. The data for following dates shall be pulled automatically from the vendor source. Generally, a simple C# or Java code written to talk to the vendor’s API. Data from the vendor must be automatically populated and updated every night for the latest date. _________________________________________