Case Study $7$: Decision Rules for Racehorse Wagering

Problem Description

People have bet on the outcome of horse races for a very long time. They try to earn large profits from their bets by finding ways of outwitting other betters. A large number of books have been published on horse races, and each author claims that following his$/$her methods will lead to profits. So far you have not been able to make big profits using any of the existing methods. Therefore, you decide to build a system that will help you and others place sophisticated bets.

Horse racing is one of the most documented sports. There are thousands of pieces of data published on each upcoming race. This data is available to you, and you need to build a database to keep all this information. Once you build your betting support system, you need to test it on some sample data and report your observations.

Database Design

The following are the main entity types of the racehorse wagering database. For each entity type, we provide some of the corresponding attributes.

Horse: The main attributes are identification number, name, birthday, height, weight, breed $($Arabian$,$ English, etc.$),$ races attended, races won, injuries, etc.

Owner $($of the horse$)$: The main attributes are identification number, name, address, etc.

Jockey: The main attributes are social security number, name, address, weight, height, birthday,