Hello Team, I’m passing EHDEN courses and particularly the quiz below. The main question is to find to which standard concept_id the code ‘427.31’ is mapped to.
SELECT * FROM concept WHERE concept_code = '427.31'; >>> concept_id = 44821957 http://prntscr.com/101pnt2
SELECT * FROM concept_relationship WHERE concept_id_1 = 44821957; >>>>> Maps to 313217 http://prntscr.com/101pq0m
There’re no such option to choose, There is 443605 which is standard concept_id the code ‘290.4’ is mapped to, from the example.
@rookie_crewkie maybe you can direct to appropriate person for this question.
There are different types of relationships defined in the vocabulary. For example the ‘Maps to’ relationship defines to witch Standard Concept_id the codes maps to. You can explore all the relationships by running the following query:
SELECT * FROM relationship;
Let’s use this new insight to find to which standard concept_id the code ‘427.31’ is mapped to. You can do this for example by first finding the concept_id using:
SELECT * FROM concept WHERE concept_code = '290.4';
You can then use the concept_relationship table find its relationships.
SELECT * FROM concept_relationship WHERE concept_id_1 = ;
Check you understand what the Subsumes and Is a relationships are of this concept_id.
To which standard concept_id the code ‘427.31’ is mapped to?