Hi all,

I'm currently in the planning phase working with my ERD. I'm trying to normalize and I've become stumped.

I have a table for printers called machine and another table for paper called media.

manytomany.png

Many of the machines in the data set can support several of the paper supplies from the media table. I know a common suggestion would be to use a bridge table between the two but I can't wrap my head around how I would create unique relationships to the bridging table. Any advice or a direction to head in would be appreciated.

Example:
machines 1-15 could use all paper roll sizes from 24" up to 36" and from 150' length to 300' length (a total of 6 individual product numbers).