Back to the Data Model.
The Area being Modelled is :-
These Requirements have been provided by
A. THE USER REQUIREMENTS :
Dear Barry Williams
I come from South Korea.
I found your Web Site by search engine.
Your Data Models and Web Site are brilliant.
I do appreciation for your contribution in this area.
As you mentioned on website you offer datase design service.
Therefore I want to ask is there any chance to have an Access database for a badminton club designed by you?
Here is some information about this database:-
Including club member,their category(e.g.level),the club coaches and the different competitions that the
members participate in.
There is an annual membership fee and members have to pay for some of the competitions that they enter.
Additional Requirement are as follows:
(1)There needs to be a record of any payments made.
A member may make many payments and each payment is associated with only one member.
(2)A club member could belong to different catregories at different times.
(3)A member can be trained by zero,one or more coaches and a coach can train one or more members.
(4)A member can participate in zero,one or many competitions.
I am looking forward your reply,many thanks for your help!
John Kung Kon