I've currently got a database with two tables, "Product" and "Option". Each parameter is tied to one product. We want to extend this data with a new concept of a "Project". A product will have many projects and each project will list what the default values for each option are for that product. The trouble I'm having is thinking how to ensure that each project lists every option for the product it's tied to.
E.g. if a product has options A, B, and C. Each project needs to define the default value for A, B, and C. Adding a new option should require updating all the projects.