tenants and children versus facts

View previous topic View next topic Go down

tenants and children versus facts

Post  elementary on Wed May 23, 2012 9:05 am

I have a tenant dimension which can be related to various facts (maintenance on houses/apartments, payments, hire requests ...)
A tenant can have numerous attributes which could be of importance to 1 or more facts.

Now, each tenant also can have children, which upon their turn can have different attributes (age, income, job, gender ... and lots more).
What we want to achieve is to be able to use the childrens' attributes versus a(ny) fact table.

Important remark: a fact table is related to a tenant. A tenant is related to 0,1 or more children. None of the facts is related to children directly.

example:
- give me the payments for tenants which have at least 2 children, of which at least 1 child is older than 18 years.
- give me the number maintenances done in period x for tenants with a mutual income of more than 10.000 dollar and where at least 1 child is x% handicapped
- ...

Any thought on how to model this?

elementary

Posts : 4
Join date : 2012-05-18

View user profile

Back to top Go down

Re: tenants and children versus facts

Post  BoxesAndLines on Wed May 23, 2012 3:37 pm

A bridge table to a Tenant dimension should work. Put the role (child, Parent) in the bridge table as well. All tenants, children and parents go into the tenant dimension.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum