有关Doctors决策支持软件的帮助 [英] Help on Doctors decision support software

问题描述

HI:我是一所大学的学生，我想在DSS(医生决策支持软件)上做我的最后一个项目(毕业项目)，因为我没有关于DSS的完整信息，我收集了来自医院的信息，并将其总结为我的项目的分析阶段
1.新系统接受患者的症状
并显示已经进入的疾病
症状作为百分比示例(如果有的话)
数据库疾病a，b，c中有3种疾病是
30％的
b的46％
c..etc的76％
2. ...以及医院的其他功能.
->>当我尝试执行项目时，对我来说很难做到
1.如何通过检查输入症状从数据库访问疾病?如果您有任何算法，使用的SQL查询或您可以提供的任何支持信息都可以.
2.如果我愿意，我在数据库中使用多少张表及其属性或关系?您可以提供的任何支持性信息对我来说都是可以的.
"谢谢您的建议""

HI: I am student of a university and i want to do my final project (gratuation project) on DSS (decision support software for doctors)since i have no full information about DSS, I collect information from hospitals and summurizes this as analysis phase of my project
1. the new system accepts symptoms of the patient
and displays diseases that have entered
symptoms as a percentage example, if there
are 3 diseases in the data base disease a,b,c the out put is
30% of a
46% of b
76% of c ..etc
2. ...and other functionality for the hospitals.
-->>when I trying to do my project the following is hard to me
1.how can i access the disiases from the data base by checking the input symptoms? if u have any algorithm , sql query used , or any supportive information u can give is ok.
2.how many tables i use in my database and its attributes or its relation if neaded? any supportive information u can give is ok for me.
"""thank u for u''r advice"""

推荐答案

为什么不为您的项目选择这个主题?如果我们为您做到这一点，那意味着您应该通过?

1-您要检查列表中有多少种症状与每种疾病列出的症状相匹配，并考虑其中不存在的症状以及有多少种不匹配的症状

2-您应该使用所需的尽可能多的表，而不再使用.这是一个愚蠢的问题.

Why did you choose this subject for your project, if you have no idea how to do it ? If we do it for you, how does that mean you deserve to pass ?

1 - You would check how many symptoms on your list match the symptoms listed for each disease, factoring in how many are not there, and how many symptoms you have that do not match

2 - You should use as many tables as you need to, and no more. This is a dumb question.

我会为1个有以下列的表定居:
疾病
症状1
百分比1
症状2
百分比2
症状3
百分比3
症状4
百分比4
症状5
百分比5

那是可怕的建议.您需要一个症状表，一个疾病表以及一个将它们链接起来的表，并且具有多对多关系.

i would settle for 1 table with columns:
disease
symptom 1
percentage1
symptom 2
percentage 2
symptom 3
percentage 3
symptom 4
percentage 4
symptom 5
percentage 5

That is HORRIBLE advice. You need a table of symptoms, a table of diseases, and a table to link them, in a many to many relationship.

我认为这是个好主意

我会为1列的表格定居:
疾病
症状1
百分比1
症状2
百分比2
症状3
百分比3
症状4
百分比4
症状5
百分比5

或两张桌子，一张带有病情
和所有症状之一

那么您只需在表之间创建一个关系
但是这样一来，您将在desease表中拥有更多记录
因为您要记录每种疾病的症状

请告诉我这是否有帮助，如果您需要任何编码帮助，请告诉我

是的，第一个答案说的是真的:D

hi well i think is a great idea

i would settle for 1 table with columns:
disease
symptom 1
percentage1
symptom 2
percentage 2
symptom 3
percentage 3
symptom 4
percentage 4
symptom 5
percentage 5

or two tables one with the desease
and one with all the symptoms

then you just create a relationsship between the tables
but this way your going to have more records in the desease table
because your going to have a record for each symptom of a disease

please let me know if this helps and if you need any coding help please let me know

and yeah what the first answer said is true :D

这篇关于有关Doctors决策支持软件的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！