Help in designing tables

[aparnawangu]

Hi Friends,
I am designing a database structure for my organisation.Its a small Org providing daycare facilities to different age groups of children.
there are 3 main tables called components,Plan and program.
Component table contains App fees,admission fees etc and the values of that components.
Plan will be related to different corporates like IBM,ACC etc.
Program will be Infant,Toddler,Junior KG etc.


I have to link these tablles in such a manner that component will get linked to plan and plan get linked to program.
Pls help me out with the relations and table design.I am attaching the database for the reference.

Thanks in advance.

[ranman256]

(The db did not attach) but,
Don't bother relating minor tables like... Zip code table feeds into an address. This is just a lookup table that holds choices.
DO relate parent -child tables....where
Client table tClient: Joe smith, 123
has literally 2 children in the tInfant table, InfantID

ClientID, InfantID, name
123, 1, billy
123, 2, sally

you want this relationship to be 1 to many, with enforce ref entegrity.
so the db won't allow to delete a parent, if children exist.

[aparnawangu]

I am attaching the screen shot of DB for the reference.Pls guide on table structure and relationships.

[larrywang]

Boss, if you do not mind could you please attach the . accdb format without records. I've seen your attachment on Relationship report however I'd like to see the relationships. Thank you. You may screen capture or simply share the access format without compromising customer information.

Thank you.

I am attaching the screen shot of DB for the reference.Pls guide on table structure and relationships.