The difficult I do immediately, the impossible takes a little bit longer.

Data Models

Data Model ~ Clubs or Associations...
This data model was designed to handle Club or Associations.  (Note, there only tables included in this database the balance is up to you!)
Business Rules...

Groups will have different Levels (ie: Beginner, Intermediate, Advanced)

Groups may have Group Leaders

Groups will have varying Beginning/Ending Dates and Times

There will be multiple Members

Each Member may or may not belong to a Group

Members may have one or more Roles

Groups will have Types

Clubs will have one or more Groups

Main Entities...



Members could belong to one or more Groups

Groups may become inactive

Download Sample (Access 2007 and up and an unzipping program needed)