Junction Table

[Christo Yssel]

Hi,
I need to confirm that I have done this correctly:

I have the following tables:
Suppliers
SuppliersID (pk)

Products
ProductID (pk)
SupllierID (fk)
UnitPrice (from supplier)
one-to-may relationship between products and suppliers
Every supplier has many products but products have only one supplier

Clients
ClientID (pk)

Here I have a slighty different problem. Every Client has a unique price for
every product, which means every Client is charged a different price for the
same product

I am using the following junction table to solve this many-to-many
relationship between product and client

ClientProductPrices
ClientID
ProductID {Composite pk)
ClientProductPrice

Thanks
Christo

 

[Douglas J Steele]

What you've got looks correct. However, are you going to need to worry about
history? (What price did this customer pay for that product on such and such
a date?)