I want to create a relational database but am struggling with the architecture. The scenario is this:
I have 45 products that people can request printed literature for.
Each product has 4 - 11 pieces of related literature.
There’s a total of 33 pieces of literature.
People may request literature for more than 1 product possibly resulting in multiple requests for the same piece of literature. In this case, only 1 instance of that piece of literature is sent.
People requesting are circa 150 daily.
Some literature changes frequently (monthly offers etc,)
What I am trying to do is keep track of the literature I have on hand.
Any help would be much appreciated.