Many to Many to Many relationship

View previous topic View next topic Go down

Many to Many to Many relationship

Post  DBAHeart on Fri May 03, 2013 6:33 pm

Hi,

I considered a bridge table but I thought it would be less complicated to have 2 FACT tables. I would greatly appreciate any design advice on this relationship.

I have included at the top - a description of current transactional data and at the bottom the 2 fact tables. I am concerned that even with 2 fact tables, I have 2 different grains and because one is lower it is a many to many relationship

IO's (feedings) to milks type = M - M
Milk types and instances have a many to many relationship with Additives both on type and on measures such as calories, and amounts

DBAHeart

Posts : 3
Join date : 2013-03-20

View user profile

Back to top Go down

Re: Many to Many to Many relationship

Post  cjrinpdx on Thu May 16, 2013 1:51 pm

I'm having trouble following you. Could you restate your question?

cjrinpdx

Posts : 51
Join date : 2011-07-14
Location : Portland, OR

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