Opinions

[Arg81]

Database Design Opinions

I thought I was OK at database design, but it seems it's the simple ones that catch me out...

Here's the scenario.
Originally a database system was to be set up to record samples sent to customers.
Customer table was linked to SamReq table.
SamReq table was linked to SamProd table - this recorded the products sent for that sample.

Now I've been asked to start the system from scratch. Basically there now needs to be a middle man - SystemID. Products are sent out as a system, i.e. 4 products could be sent as System1 (Hot&Spicy) and 2 products could be sent out as System2 (Cool&Tangy). But those 6 products are sent out in the same batch.

I need advice on what would be the best design.
The following is inc. in the table specs:

SampleRequest:
-SampleRequestNo
-CustomerID
-FAO
-Date
-AccountManager
-Comments

System:
SystemID
SampleRequestNo
SystemName

SystemProd:
ID (?)
SystemID
ProductName
Description
Usage

This seems fine in SQL, but there's something about it that just doesn't seem right. Any advice would be much appriciated.

Regards,
Luke

 

[Arg81]

Any advice guys? I need some help on this as it's causing me a few problems and I'm not sure if it's to do with the DB design.

cheers,
Luke