I need a programme that collects xml feeds and saves the data to a flat table.
?
This programme should update the data (from the feeds) to the table every number of seconds (set by the user). By default the update should be every ninety seconds.
?
The system must also be able to cater for a game that becomes suspended or stops being offered. In this case it must save an indicator in the table.
The programming language used has to be VB.NET client 2008.
The database used has to be MS SQL Server 2008.
?
The source code and all the relevant files are needed.
## Deliverables
What I need ??" Part A
I need a programme that collects xml feeds and saves the data to a flat table.
?
This programme should update the data (from the feeds) to the table every number of seconds (set by the user). By default the update should be every ninety seconds.
?
The system must also be able to cater for a game that becomes suspended or stops being offered. In this case it must save an indicator in the table.
?
?
The xml feeds are from the following bookmakers and betting exchanges:
?
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
?
?
Table Schema
?
Table1
tb_bet_info_btf
btf_pk? ? ? ? ? ? ? ? ? ? ? ? ? serial? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? primary key
**btf_fxt_fk**? ? ? ? ? ? ? integer? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? fixture ID
**btf_mkt_fk**? ? ? ? ? integer? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? market ID
**btf_bts_fk**? ? ? ? ? ? integer
btf_odd_back? ? decimal
btf_odd_lay? ? ? ? ? decimal
btf_active_ind? ? integer? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? (1 active, 0 not active)
btf_timestamp? ? Datetime current year to second
?
Table2
tb_fixture_type_fxt
fxt_pk
fxt_desc
?
Table3
tb_bet_site_bts
bts_pk
bts_desc
?
Table4
tb_market_type_mkt
mkt_pk
mkt_desc
?
?
The programming language used has to be VB.NET client 2008.
The database used has to be MS SQL Server 2008.
?
The source code and all the relevant files are needed.