Completed

Create SQL Express database with Front End

I require a SQL database setting up.

It should have a reasonable looking front end.

The database is to be populated on a daily basis using two csv files.

There is a requirement to perform a calculation against the CSV ‘s before the data is committed to the database.

The subject being stored is the result of horse races.

The winner of the race is given a numerical rating by myself.

In every race a horse is allotted a certain weight to carry.

A calculation by deducting or adding 1 point for every 1 pound (imperial measurement) that each of the other runners behind the winner carried in weight is to be done.

The distance that the beaten horses is also to be calculated into a figure and further deducted against the winners winning figure/rating.

This calculation will require a lookup due to the fact that over the different distances a race may be run over the ratio between weight and gap between each horse varies. A length of a horse is considered about 3 to 4 pounds/points over a 5 furlong distance. I use 3.5 and please see the spreadsheet attached for a full listing.

There are 2 forms of racing Flat racing and with obstacles such as fences or hurdles this is called Jumps racing. There is a different scale to lookup for these two codes of racing.

The following Tables would be required.

One for the race event

One for the individual runners performance. So there would be common link between these two.

Though you may want to split the tables further for Horse Trainer Jockey.

A copy of the two CSVs also attached. These are a full week of races rather than a daily.

MainId in the details references the ID column in Main.csv. In the Main ID the winners rating is in the last column.

The Front end should have a button to access the [login to view URL] to fetch the rating. Then Calculate the ratings for all runners. Finally a button to load the [login to view URL] into the database, then load the [login to view URL] into the database.

There should also be an area to enter a horses name, press a button and bring back details of that horses past performances.

I expect all the code to be available afterwards to myself as I should be able to make minor changes.

Skills: Database Development, Database Programming, SQL

See more: spreadsheet jockey, performance press, sql, asp.net

About the Employer:
( 5 reviews ) Harrogate, United Kingdom

Project ID: #9101119

Awarded to:

prprojectsl

Hi, I have seen your attached details file, and the data format. I understood your requirement. I will design the code very simply with comment so you can make some simple changes by yourself. The entire job shou More

$105 USD in 3 days
(19 Reviews)
5.4

20 freelancers are bidding on average $201 for this job

mahmoudgamal008

I have more than 5 years of experience in database development. I am available now. I will start right away.

$110 USD in 6 days
(34 Reviews)
5.5
Vlzinch

Hi, I have big exeprience in creatig different types of databases using SQL programming. And honestly thats the cost for the good job in order to have functional and user freindly database. Let me know if you want t More

$500 USD in 10 days
(2 Reviews)
4.9
acronymsolutions

Hi , I am 16+ years experienced Database Programmer at CMMI-5 level company and I have 25 members team. We are working on : RDBMS :Oracle,MySQL,DB2,Sybase, MSSQL Server 7.0/2000/2008R2 and Onwards. Database T More

$411 USD in 10 days
(33 Reviews)
5.4
muzammaljanjua86

Dear Employer, I am working as a freelance programmer on different websites including rent a coder & freelancer dot come from over 5 years. With over 6 years of total experience in Clasical to .net technologies expe More

$222 USD in 10 days
(6 Reviews)
4.3
scorpioangry55

You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.

$416 USD in 5 days
(8 Reviews)
3.9
vishaltile

We are SQL professionals and we will deliver you in less time with quality for sure. We have professionals more than 10 yrs of experience.

$166 USD in 1 day
(11 Reviews)
3.9
khannanav

We have a team of expert DB Architects and developers with more than 10 years of rich industry experience & would be more than happy to work on the project. We have expertise in designing DB schema from scratch,wri More

$200 USD in 3 days
(7 Reviews)
3.8
arityinfoway

Hello, Hope You are doing well. ARITY INFOWAY is complete web based solutions company. We able to provide web solutions from scratch to hosting . We always go through every point of your projects scope and prov More

$157 USD in 5 days
(5 Reviews)
3.6
webcourage

Yes, I am the perfect one for your important project. Please check my freelancer profile for portfolio and work reviews. I read the project description properly, and I can start your important project right away if you More

$184 USD in 3 days
(1 Review)
3.4
BubbleJet23

Hi, I am currently employed as a C# Developer for a Software Company in Brisbane, Australia; and have extensive knowledge with SQL Server. I have been programming commercially for over 6 years and have decided to More

$138 USD in 3 days
(1 Review)
0.7
Luies

Hi i can do it, i am a oracle daatabase programmer at Era Infotech Limited. Which tool i need to use for making front end i prefer oracle [login to view URL] will look cool as your requirement. also csv load to [login to view URL] in ch More

$166 USD in 1 day
(0 Reviews)
0.0
rkinfotekh

I have gone through your requirement, it is very clear specs about project. we will complete that project within your given time duration. We are professional PHP,Mysql,bootstrap,javascript,JQuery, Graphic Desi More

$200 USD in 9 days
(0 Reviews)
0.0
vw8159451vw

Developer for a global retail enterprise, I have been developing software for almost a decade. I have been architecting n-tier, scalable applications for numerous corporates over the years. This project is exactly what More

$200 USD in 3 days
(0 Reviews)
0.0
Djole92

A proposal has not yet been provided

$111 USD in 10 days
(0 Reviews)
0.0
pravinsurvase

Scope of work 1. Development of stand alone application with front end and database to manage horse race data 2. There shall be functionality to import data from csv files 3. Calculation of horse standing and ratin More

$222 USD in 15 days
(0 Reviews)
0.0
dudyjr0609

A proposal has not yet been provided

$200 USD in 6 days
(0 Reviews)
0.0
wifercg3011

A proposal has not yet been provided

$88 USD in 4 days
(0 Reviews)
0.0
abhishektyagi001

Application will be fast and interactive. GUI will be user friendly.

$55 USD in 14 days
(0 Reviews)
0.0
ExemplarTeam

I have done similar type of csv imports in many industry. I will provide all the source code along with documentation to you. Your definition is very detailed. There are still some questions which I would like to get More

$166 USD in 6 days
(0 Reviews)
0.0