en-USnl-NL
Goal:
Draw a first map of your datamodel.
This is the datadefinition phase.

Execution:
Examine the information and determine the datasets: what will be your tables?
There are a couple of entities in the case; put them in a table and name them:
    The society
    An Activity
    An Activity Officer
    Members

These entities have properties:
    The society has members, a contribution fee, the administrator (i.e. you) and Activity Officers, maybe more....
    An activity has an activity officer, a price, a plandate, and more...
    An activity officer has an activity, a name, a DNN role and maybe more....
    A member has a name, a gender and age, spouce or child, some more....

So now we can define our tables that contain the data:
    The Society table
    The Officer table
    The Activities table
    The Members table

And the fields that contain the actual data per table:

The Society table contains at least the fields:
    Society name                        SocietyName
    Scociety contribution fee      SocietyFee
 The Officer table contains at least the fields:
    Officer Name                        OfficerName
The Activity table contains at least the fields:
    Activity Name                       AcitvityName
    Activity Description              ActivityDescription


 
The Members table contains at least the fields:
    Member First Name            MemberFirstName
    Member Last Name            MemberLastName
    Member Gender                 MemberGender
    Member Age                      MemberBirthYear
    MemberChild                      MemberChildYesNo
    MemberSpouce                  MemberSpouceYesNo

These are the most obvious tables that you might recognize, but there are more! Can you tell wich?
We will develop them in following lesssons.

Now it's time to get the DatabaseBuilder.
Download the file: My Pleasure; Lesson 1 from the dowloadpage and store it in your Tutorials folder on your computer.
You migt as well create a backup folder here to store any backup DatabaseBuilder files to be used in case something goes horrible wrong....

 ---->> To Lesson 2: Examine the DatabaseBuilder