Need assistance in setting up a filemaker pro 12 database. The database is comprised of data of past horse races. The data is contained in a large number of comma delimited files. I need to be able to extract the comma delimited files into the appropriate fields and then analyze the data. Assistance is needed in setting up the relationships between fields as there are many elements involved.
I need to be able to analyze elements within individual races as well as across a wide number of races. Attached are the 2 types of comma delimited files which will be used as the basis for the database. One file contains all the entrants for all the races on a particular day at a particular track. The second file contains the results of all the races on a particular day at that track.
Attached is an excel file which contains the fields and field names of each csv file.
I have broken them down into the tables I believe I need. Sheet #1 contains the 1435 fields to be extracted from prx0101.csv 1) Race Info - Info about one specific race before the race was run. 2) Horse Info - Info and data about a specific horse in a specific race before the race was run. Each race will obviously have multiple horses. There are also a number of blank fields in the csv that I don't need.
Sheet #2 contains the 122 fields to be extracted from 2012resultsprx0101.csv. 1) Race info - Info about the race from after the race was run. Needs to be added to the race info table. 2) Horse info - Info and data about one speciifc horse from a specific race after the race was run. Each race has multiple horses and not all the entered horses will be in the results. I need to add a field that indicates a horse was "scratched" (was listed in entries but is not in results). 3) Wager info - Info about the different wagers which were available in the race, their payouts and which horses figured in those wagers.
I envision 3 tables 1) Race Info 2) Horse info 3) Wager info.
Where I have difficulty conceptualizing this database is in making the relationships between a race, the horses in that race and the results of the race, which does not include all the horses which were entered.
I also need to automate the process as much as possible for extracting the data into the relevant tables.
12 freelancers are bidding on average $590 for this job
I have +4 year experiences in database architecture and administrator . To Provide Well Documented , quality code and professional work. Thanks & Regards Hardik G. Dumaswala
Hi my Dear, i am a statistician engineer working as a data manager and data analyst there is 4 years. What you want it's what i master a lot. I am ready to start it for you. Let's go in PM please
Sir ,I have 2+ years experience in Filemaker Pro 12 [url removed, login to view] Importing From Csv files and analize this data depending of some conditions , I can make that very easily. Can I Show you an [url removed, login to view] me a cha Mais