D
Daniel Crane
My company makes filters. And I have been having trouble on how to
approach the database design for our products. I'm hoping for some
suggestions...
Whenever a new filter is designed, and ready for production I want to
add a Product to our List of products. Now we have up to 117
different tests or specifications that we currently do here on the
finished product that the product must be able to meet.
I want a user to be able to:
a) Create a new product in my database.
b) Assign an undetermined number of tests to be performed on that
product.
For instance: Bubble Point Test, Thickness Test, Length
c) For the tests / specifications that have been applied to the newly
created product, I need to be able to put in a numeric value
For instance: Bubble Point Test (Min, Max), Thickness Test
(Min, Max), Length(Min)
The reason it needs to be dynamic is because some Filters require
certain test, while others don't.
I might have Filter A that needs test (or spec) A,B,C,D,E,F,G while
Product B only needs test (or spec) A, C, D, G.
Every Product will have a ProductNumber, ProductName, ProductCategory.
Once a "Product Master" (template) has been created, then it will be
possible to add Inventory. An inventory item will be added. A user
will "Add Inventory" and choose what type of product is being entered
by choosing a name from the existing list of approved products.
That inventory will be associated with the "Product Master". Then
that inventory item will be given it's appropriate tests and that data
will be entered into the database. Once the inventory item's data is
properly entered it's data will be verified against it's "Product
Master" to see if all the data falls within the limits.
I would really appreciate whatever help you can offer. Perhaps it's
just some small ideas that will lead me in the right direction. But
the structure is killing me. Thanks for the time you took to read
this, and for any posts you've made regarding this subject!
Daniel
approach the database design for our products. I'm hoping for some
suggestions...
Whenever a new filter is designed, and ready for production I want to
add a Product to our List of products. Now we have up to 117
different tests or specifications that we currently do here on the
finished product that the product must be able to meet.
I want a user to be able to:
a) Create a new product in my database.
b) Assign an undetermined number of tests to be performed on that
product.
For instance: Bubble Point Test, Thickness Test, Length
c) For the tests / specifications that have been applied to the newly
created product, I need to be able to put in a numeric value
For instance: Bubble Point Test (Min, Max), Thickness Test
(Min, Max), Length(Min)
The reason it needs to be dynamic is because some Filters require
certain test, while others don't.
I might have Filter A that needs test (or spec) A,B,C,D,E,F,G while
Product B only needs test (or spec) A, C, D, G.
Every Product will have a ProductNumber, ProductName, ProductCategory.
Once a "Product Master" (template) has been created, then it will be
possible to add Inventory. An inventory item will be added. A user
will "Add Inventory" and choose what type of product is being entered
by choosing a name from the existing list of approved products.
That inventory will be associated with the "Product Master". Then
that inventory item will be given it's appropriate tests and that data
will be entered into the database. Once the inventory item's data is
properly entered it's data will be verified against it's "Product
Master" to see if all the data falls within the limits.
I would really appreciate whatever help you can offer. Perhaps it's
just some small ideas that will lead me in the right direction. But
the structure is killing me. Thanks for the time you took to read
this, and for any posts you've made regarding this subject!
Daniel