I have the following table structure:
As the picture shows, a Product consists of a number of Components and each Component is going through a number of Processes.
Here is my problem: there are some Products that consist of no Components, but the Product itself is going through a number of Processes (these Processes are the same as those Components do go through).
What do you think is the best way to alter the above table structure as it does not apply to the case where the Product has no Components?
As the picture shows, a Product consists of a number of Components and each Component is going through a number of Processes.
Here is my problem: there are some Products that consist of no Components, but the Product itself is going through a number of Processes (these Processes are the same as those Components do go through).
What do you think is the best way to alter the above table structure as it does not apply to the case where the Product has no Components?