[Solved] SQL Data models

Question

for 1.2 you will need one more table which will hold task and items relation ship for example

Table : Task_Item_Rel {TaskID,ItemID}

whenver you want item related to a particular task simply have a query with joins between task,item and Task_Item_Rel

Accepted Answer

for 1.2 you will need one more table which will hold task and items relation ship for example

Table : Task_Item_Rel {TaskID,ItemID}

whenver you want item related to a particular task simply have a query with joins between task,item and Task_Item_Rel