Data owned by both individual and group

[waharris]

I'm having trouble wraping my head around some relationships and was hoping for some help. This post deals with data that might be related to both an individual AND a group of individuals. Thanks in advance.

Example: A tutoring organization

Mary is a student. She has two parent/guardians - Frank and Susan. Mary has a brother - Sam - Sam is not being tutored. However, we would like to keep track of siblings because they might be a source of more business.

The Family (group) has three address - home1 (the billing address), home2 (the home in this area), and location of tutoring (library)

The Family (group) has two phones - land line 1 (home) and land line 2 (fax)

Frank has three personal phones - work, cell, and fax

Frank has one personal address - work

Susan has one personal phone - cell - Is the main contact for the family tutoring needs - normally called at home but occasionly in an emergency we need the cell.

Mary has one personal phone - cell

Sam does not have a phone - He can only be reached at home - however, is very young now and will not be able to answer the phone for several years - We really shouldn't be talking to

sam at all - but if he answers the phone in several years - we'd like to at least know he exists..

Mary has tutor - Ginger

Ginger teaches Mary two subjects - Trigonometry and Physics

Ginger has three phones - home, work, and cell

Ginger is qualified to teach five subjects - Trigonometry, Physics, Chemistry, etc.

Ginger has one personal address - payment address (home)

Ginger tutors Mary at the library - address.

Ginger tutors several other students whose family structure is similar

Ginger tutors in small groups (also) example - she has 3 students that meet her at the YMCA - location address.

I think I need the following tables; however, I realy don't know how to relate them because of the group (family, small tutoring group) owning addresses and persons owning addresses, phones, etc.

(table) Person

Name

(table) Group - Family, Organization, Small tutoring Group, (Maybe also Just a person, Individual)

(table) Address

Type

Line1

City

State

Zip

(table) Phone

Type

Number

(table) Qualification

(table) Subject

(table) Assignment - Join a tutor and a student both are persons

(table) Relationship - sibling, tutor, parent, etc.

Edited June 5, 2006 by Guest
Add mor info