Entities and Attributes

• 1. Disease
  • DiseaseID (Primary Key)
  • DiseaseName
  • Description
  • Symptoms
  • Causes
  • TreatmentMethods
  • Prognosis
• 2. Anatomy
  • AnatomyID (Primary Key)
  • AnatomyName
  • Description
  • Location
  • Function
  • RelatedDiseases
• 3. Investigation
  • InvestigationID (Primary Key)
  • InvestigationName
  • Description
  • Purpose
  • Procedure
  • ResultsInterpretation
  • RelatedDiseases
  • RelatedAnatomy
• 4. Drug
  • DrugID (Primary Key)
  • DrugName
  • GenericName
  • ChemicalFormula
  • Dosage
  • SideEffects
  • Indications
  • Contraindications
  • RelatedDiseases
• 5. Technique
  • TechniqueID (Primary Key)
  • TechniqueName
  • Description
  • Purpose
  • Procedure
  • RelatedDiseases
  • RelatedAnatomy

Relationships Between Entities:

• Disease-Anatomy: Many-to-Many (A disease can affect multiple anatomies, and an anatomy can be affected by multiple diseases)
• Disease-Investigation: Many-to-Many (A disease can have multiple investigations, and an investigation can be used for multiple diseases)
• Disease-Drug: Many-to-Many (A disease can be treated by multiple drugs, and a drug can treat multiple diseases)
• Disease-Technique: Many-to-Many (A disease can be diagnosed or treated using multiple techniques, and a technique can be used for multiple diseases)
• Investigation-Anatomy: Many-to-Many (An investigation can be performed on multiple anatomies, and an anatomy can be the subject of multiple investigations)
• Drug-Anatomy: Many-to-Many (A drug can affect multiple anatomies, and an anatomy can be affected by multiple drugs)
• Technique-Anatomy: Many-to-Many (A technique can be performed on multiple anatomies, and an anatomy can be the subject of multiple techniques)