HI, I`m trying to model the case as below.
Source Table (Task ID | Attr1 | Attr2 | Countries | Products | LastModificationDate), is providing attributes for Tasks, all the attributes are single valued, except Countries and Products, which are lists/arrays and can contain 0…n elements each.
Model which so far I come to is as following:
HUB_Tasks (Task ID)
SAT_Tasks_Details (Attr1 | Attr2 | LastModificationDate)
SAT_MAS_Tasks_Countries (record for each country element and LastModificationDate)
SAT_MAS_Tasks_Products (record for each product element and LastModificationDate)
Could you please advise if this is right/best way of doing it? What better options you could propose please?