Hi I'm new to database design but am trying to make sure I get things right first time so as not to pick up bad habits. My question is I have a set of people for which I want to record needs mapped to importance. Needs should be taken from a set to avoid duplicates creeping in. Each person will take a subset of these and grade their importance. i.e. needs =[tea, biscuits, toilet facilities, internet access] People = [Phil, Bryan]
Phil needs tea and biscuits, tea with an importance of 10 biscuits with an importance of 3.
Bryan needs internet access and biscuits with importance of 4 and 7 respectively.
How would you suggest organizing the tables to implement this. Thanks