Table structure question
I'm a little perplexed so I need your help; please refer to the attachment.
I have four "domains" that I want to create a parent-child relationship since, as you can see, each domain has multiple fields which will be used in summary/aggregate reports later. (Each red square is a field where users would enter a number from 1 to 4; they're named D1a, D1b, D1c...D3c, D3d, D3e.) Since there's a one-to-many relationship I need to create parent-child tables.
Here's the question: Should I create a separate child table for each Domain, e.g., Domain1 would store only the Domain 1 data, Domain 2 for only Domain 2 data, etc., or should I have one child table to store all the data, it broken out by data field and Domain number?
TIA for your input!