Database  Design

-Arpit Goyal

Well Till now most of our entities are clear and their relationship with each other are almost done.

Well i came up with 7 tables that we will be needing for our database structure-:

1)Diseases :-

• Disease_Name

• Disease_Id (Primary_Key)

• Prevention_Wave_File_Link

• Area_Of_Disease

2)Symtomps:- (Weak Entity:  Symptoms may have different names but have same meaning)

• Symptom_Name

• Symptom_Id

3)Doctor:-

• Doctor_Name

• Doctor_Id (Primary_Key)

• Area_Of_Specialization

4)Specializations

• Specialization_Name

• Specialization_Id (Primary_Key)

5)Query_Log:-

• Query_Id (Primary_Key)

• Date_Time

• Caller_Number

• Recording_Wave_File_Link

• Disease_Predicted

6)Error_Log:-

• Query_Id

• Date_Time_Updated

• Disease_corrected

• Doctor_Id

7)Symtomps_Wieghts:- (Weak Entity)

• Symptom_Id

• Symptom_Weight

• Disease_Id

Well This gives a fair idea but it will be more clear with E-R Diagram and Schemas Diagram.

You can follow the  E-R Diagram .

You can Follow Schema Diagram Here. 

Apart From this I am also planning, not get biased to a single database but for all  MySql  , MsSql ,Oracle Databases. I am working on it's Interface too.