There's often more than one way to structure your data.
Consider that both clients and providers have nearly identical contact fields (name, address, phone, etc.)
You may want to create a contacts table that stores the contact info for both clients and providers in the same table. A field in this table can identify which are clients, which are providers (and it's not unheard of for a provider to also be a client...)
Consider how many phone numbers, email/social networking addresses a person can have. You may find it useful to define a separate table of phone numbers (and maybe email/etc addesses) so that a flexible number of these numbers can be recorded for a single contact.
Ok, so I can create a contact table with has all the phone numbers and emails etc for everyone and add a field for contact type where i can label them, I'm assuming linked by a relationship by the ID number of the person...is that correct?
But the providers I have are companies, not an individual person, so would I still have them on one table with clients?
Yep. Keep in mind this is an option to consider as you plan your database. Often companies and people can be managed in the same table, but you don't have to. The Guardian contact info could also be recorded in this table.
And you might put phone numbers in a table separate from but related to contacts to facilitate recording multiple contact numbers..
It is easier to put things together than take them apart.
for instance can avoid the data entry problem of formatting a phone number (xxx) xxx-xxxx ext xxx
is my preference for ease of reading and formatting the Address Data to your requrements.
You have clients, referrers, parents, day provider, residence provider, etc
I would look at your most complex and simplest examples, the complex will tell you more...
Note Fields should be included in whatever form your data entry people think they need.
Two addresses? Vacation home? work number, home number, cell number, fax number, vacation phone, emergancy phone???