Relational Modelling Question

i m not sure if i m right in this group, but i think relational database modelling is a theoretical issue:

I have to following (simplified) situation. I have a company which sells

• simply one article
• a basket with an amount of the same article
• a customer special bill of material (n articles with amount)

Now the question is: How should i correctly model that with sql on a relational database?

3 different tables for my products? But than: What should i reference in the sales document (also a table)?

Constraints:
- It s not allowed to use positions for the basket

• It s not allowed to add a foreign key (to the sales document) to the article table

In my opinion, this problem is prety much a object orientated inheritance problem ...

Any help appreciated,
Dan Received on Wed Apr 21 2010 - 18:08:38 CEST