Non Determinate BK with Constant

• Remove the irrelevant constants

  • all combination of constants (element & int )appearing in the example
  • only the combinations included in MSH is necessary
  • Use the table representing modeb

SELECT T2.elem, T2.no,

COUNT(DISTINCT T1.drug)

FROM active T1, atm T2,

modeb_atm M

WHERE T1.drug = T2.drug

AND T1.class = ‘pos’

AND T2.elm = M.elm

AND T2.no = M.no

GROUP BY T2.elm, T2.no

前のｽﾗｲﾄﾞ

次のｽﾗｲﾄﾞ

最初のｽﾗｲﾄﾞに戻る

ｸﾞﾗﾌｨｯｸｽの表示