August 9th, 2007, 04:04 PM
|
|
Registered User
|
|
Join Date: Aug 2007
Posts: 1
Time spent in forums: 25 m 52 sec
Reputation Power: 0
|
|
|
Please help with ERD
Hiiii everyone,
Please help me with the following "homework"... i am trying to find entities... so far i have found only 5 (members, masters, classes, venue, Judo Intl Association).... i would appreciate your help.... i am not being a couch potato... i have read " Database Systems - A Practical Approach to Design, Implementation and Management"... but i am still struggling since i am a noob.
Quote: The LK Judo Club is a not-for-profit organization, teaching the martial art Judo in the Kyushindo style. Classes are held at a local youth centre. Classes are run on Monday evenings. There are two classes, the child class runs from 7pm to 8pm and the adult class runs from 8:15pm to 9:30pm.
There are currently two types of member, adult(over 16) and child(16 and younger. two masters currently teach each class. These are both adult black belt grades. All other members are of lower grades. There are currently 12 child and 9 adult members(not including the masters). grades run from white belt, through yellow, orange, green, blue, brown and black belt. Black belts may progress by earning Dan grades.
Every week the student attends, they pay a ma free, children pay £2.5, while adults pay £3.50 per session. This is used to pay the hall hire fee of £20.00 for the evening. Additionally, every member must pay a membership fee of £10.00. Of this fee, £6.00 is used to pay for individual insurance of the calendar year( 1st jan to 31st dec).
This is paid as one payment, for the whole club to the Kyushindo International Judo Association. Students paying late in the year will still have to renew on 1st Jan of the next year. Upon payment, each member receives a membership card detailing personal details and grading history, this is updated by the master when the student takes a grading, of which there are two a year.
the club itself also has to pay an annual fee of £120 to be affiliated with the Kyushindo International Judo Association, this also provides indemnity insurance for the club. |
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
