Shuttle Logo Shuttle Logo

E.S.B.L. Database Description.

Badminton Home Page   to the Badminton Home Page.

This page is provided for the benefit of all database lovers out there to illustrate how I process the score cards. I use a hierarchical system with six linked panels containing information on clubs, teams, matches, player selections and individual players with a final one to gather statistics. Each main panel is described below adjacent to an example image.

Club panel This is the Club panel with one record per club. There is a panel link to establish the connection to this club's players. On the right there is a panel link with a related-records window showing the teams in that club with their current scores. To enter a score card I first select the home club and then go down through this link to see the list of it's teams.
Team panel This is the Team panel with one record per team. The image shows a lookup to select a particular home team. At the bottom there is a panel link with a related-records window showing it's home matches already played. To continue entering a score card I first select the actual home team and then create a new record in the match panel through this link.
Match panel This is the Match panel with one record per match. The image shows a lookup to select the away team from those in the same division. This is the next step in entering a score card. Each match is then allocated a unique reference number and it's played date is entered followed by the "aces" won. Equations calculate the individual match scores and others automatically update the total scores for both teams. Then any match comments are added. The match record is completed by adding players as shown below.
Player Selection panel This shows the Player Selection panel overlaying the match panel. At the bottom of the match panel there are 2 panel links with related-records windows showing the actual match players. Players for both teams are entered by creating a new record for each one in the player selection panel through these links. This allows only registered players from that club to be selected for each team.
Individual Player panel This is the Individual Player panel. At the bottom there is a panel link with a related-records window showing the matches which that player has played in - these are indexed to list in played date order. This is where the information is derived from for the "Player Match" pages on this web site.


After entering a batch of cards there are a collection of reports I run. These check for a range of mistakes and checks player validity especially for any infringement of Rule 16(g). Further reports then directly generate the HTML files for the League Results Tables Page, the Score Card Comments Page and the Player Match Pages (which include embedded JavaScript code).
If you have any questions about this please contact me by e-mail as shown on the Badminton Home Page.


For information on, and support for, the database program used here - follow these links.
Udo Tjalsma DataPerfect Users Discussion Group Mailinglist - for the program used here.
Bruce Conrad Sanbachs.com - "Serving the DataPerfect Community".


You are visitor number   WebCounter from http://www.digits.com/   to this page since 11 Feb 2001.
Top of this Page   to the Top of this Page.
Badminton Home Page   to the Badminton Home Page.