-6

Can someone help me out with this task (I didn't get it)?

Data Model

logi-kal
  • 7,107
  • 6
  • 31
  • 43
Jihed Zouari
  • 61
  • 5
  • it's not a homework, it's something i need right now (i'm not asking for answers just hints about Q.1.2 ) – Jihed Zouari Feb 07 '18 at 12:28
  • This sounds like you have to create a [Foreign Key to multiple tables](https://stackoverflow.com/q/7844460/8097737) –  Feb 07 '18 at 12:45

1 Answers1

0

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

BlindSniper
  • 1,731
  • 3
  • 16
  • 30