database normalization

[Rosinino]

Hi,

I'm designing a database for my place of work. I've created the tables and relationships, and would like to know if the design conforms to Normalization?

A .jpg is attached to this message showing the relationships.

Any help would be appreciated.

 

[neileg]

You have three unconnected tables. That can't be right.

 

[GolferGuy]

One of the parts of normalization is making sure we don't have the same type of data repeated in a table. This is not an absolute, but something to always look for. And what I see in your tblCarePlan is Disability, Medication, Requirements, Achievements/Targets as four of your fields, all associated with one CarePlanID. I would think, but sure don't know, that for one care plan, there might be more than one medication needed, and the fact you have Requirements being plural looks like there could be more than one requirement with one care plan.
Also, you have Phone and Mobile (2 different PhoneNumbers) in several of your tables. These can be broken out into their own table of PhoneNumbers. A phone number table would need a few extra fields for identification of which table these phone numbers are associated with, the ID field of that associated table, and the type of phone the number is for (Home, Office, Mobile, Fax, etc.). Please note, leaving the phones the way you have them is not "wrong" as such, I'm just pointing out from a position of Normalization of the data.
And as Neileg pointed out, what are you doing with tblVolunte..., tblStaff, and tblTraining? There seems to be no connection of these with your tblClients.