-
Problem with Normalizing a many to many
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).
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|