我如何规范化数据库表? [英] how can i normalize database tables?

问题描述

hi:
请帮助:
我有以下表格

hi:
please help:
i have the following tables

desease_name=a,b,c,.....
symptom_list=a1,s2,d1......

然后我想对表进行规范化，并且我想使用sql查询命令来检索特定症状输入的疾病名称
"""对我的问题有用的任何信息都可以！"""
<<<<<<<<<<<<<" for =" u''r =" advisor =">>>>>>>>>>

then i want to normalize the tables and i want sql query command used to retrive the disease name for specific symptom input
""""""any information that is usefull for my question is ok!"""""
<<<<<<<thank u="" for="" u''r="" advice="">>>>>

推荐答案

此处 [

Here[^] is an article on the basics of database normalisation.

请购买一本好书，以了解数据库.它将帮助您设计数据库，编写查询等.

对于您发布的查询，这是您可以采取的第一步:
MstDisease
Column1 Column2
1疾病-A
2疾病-B
3疾病-C

MstSymptom
Column1 Column2
1个a1
2个a2
3 b1
4 b2
5 c1
6 c2
TrnDiseaseSymptom
Column1 Column2
(MstDisease ID)(MstSymptom ID)
1 1
1 4
2 2
2 4
2 6
3 1
3 3

Please buy a good book to learn about databases. It will help you in Designing databases, writing queries, etc.

For the query you posted, here is one of the start that you can take:
MstDisease
Column1 Column2
1 Disease-A
2 Disease-B
3 Disease-C

MstSymptom
Column1 Column2
1 a1
2 a2
3 b1
4 b2
5 c1
6 c2
TrnDiseaseSymptom
Column1 Column2
(MstDisease ID) (MstSymptom ID)
1 1
1 4
2 2
2 4
2 6
3 1
3 3

这篇关于我如何规范化数据库表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！