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-:
- Disease_Id (Primary_Key)
2)Symtomps:- (Weak Entity: Symptoms may have different names but have same meaning)
- Doctor_Id (Primary_Key)
- Specialization_Id (Primary_Key)
- Query_Id (Primary_Key)
7)Symtomps_Wieghts:- (Weak Entity)
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 Here.
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.