AnsweredAssumed Answered

Relational database question

Question asked by hidaz on May 11, 2016
Latest reply on May 12, 2016 by hidaz

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.

Outcomes