我如何规范化数据库表?

本文介绍了我如何规范化数据库表?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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