If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Design help for community group database
I am trying to set up a database to track Girl Guide leaders in my Region
along with their training and awards history. Each leader has another leader as a Guiding Partner (or mentor) and this has to be reflected in their training history. Each leader's qualifications need to be "appraised" every 3 years and I need to be able to track when that is due. I also need to be able to get reports such as which leaders have certains training qualifications (modules) etc. Would appreciate any help. So far I have set up the following tables: LEADERS TABLE: MemberID (using Girl Guides membership number, not autonumber) primary key First Name Last Name District Division Region Position Home Phone Work Phone Mobile Address City State Postcode QUALIFICATION TABLE: QualID (autonumber) primary key Module Type Start Date Completion Date Expiry Date TRAINING COURSES TABLE TrainingID (autonumber) primary key Course Name Date attended AWARDS TABLE: AwardsID (autonumber) Primary key Award Type Date Received GUIDING PARTNERS TABLE GuidingPartnerID (autonumber) Primary key This is as far as I have gone as I haven't yet got my head around how to do the relationships, particularly in regards to foreign keys and object dependancies. I understand the concept of foreign keys, but not sure how to apply them with my scenario. The examples I have seen only have 3 tables so it is fairly simple to apply them. I have only a very basic knowledge of databases and I am getting confused by all the "techy" talk in the various online tutorials I have read, so I need advice is fairly simple language, sorry. 1)Am I on the right track? (ie have I designed the tables the best way) 2)Do I need any more tables for the relationships? Thanks for any help Anne |
Thread Tools | |
Display Modes | |
|
|