Ariadne index page

The Ariadne Data Model

 

  
Contents
1. Introduction
2. Object definition model
3. Conceptual data model
4. Table model
5. Database model
6. Database table descriptions		 author: Gerrit van Dalfsen
version: 1.5
date: 24 Sep 2002

3. Conceptual Data model

The Conceptual Data Model specifies the properties of object classes and the contingent relations that hold between object classes, as relevant for the processes related to the kayak slalom competition.

3.1 The conceptual data model for the Slalom competition

3.1.1 Conceptual Data Model Slalom competition: Modeling decisions

(1) - A KAYAK CLUB has only an adress via a contact person. (This has been changed per Ariadne version 4.0, where a kayak club can have an address of its own)

(2) - A COMPETING UNIT can compete in only one EVENT. However, a competing unit can compete in the same time in one or more shadow events. (normally, there will be never more than one shadow event. (A Shadow event is a rearrangement of categories for some reason. The idea of 'Shadow event' evolved when the categories of the GM-championship did not match the categories of the Dutch National Slalom League.)

(3) - The observation of the START by the starter and the FINISH by the finish judge is not modeled because start and finish event registration wil be automated.

(4) - PROGRAM is not modeled as a separate object from Slalom Competition, because both have the same properties ( Program is a paper representation of slalom competition).

(5) - EVENT RESULTS are not modeled, because they have no relevant properties of their own (In future the time stamp of publication may become relevant). Event results can be derived any moment from event and runs.

(6) - In the competition executing process, relating disqualifications to runs only is adequate.

(7) - It is decided to have one ranking scale per competition. (It is possible to have scales per boat type, e.g. a scale for K1, C1, C2) . The effect of one scale per competition is that het best C1, C2 etc. do not rank as 100.

 

3.2 Conceptual Data Model Ariadne System management

 

3.2.1 Modeling decisions

None so far.