en:database

Differences

This shows you the differences between two versions of the page.

en:database [2024/09/11 12:07] brahmantraen:database [2024/09/11 13:30] () brahmantra
 1:  1:
 ====== DATABASE ====== ====== DATABASE ======
  
-Entities and Attributes+  * DATABASE DIFFERENCES ON THE BASIS OF DATA STRUCTURE  
 +    * [[:en:treebase | tree base ]] 
 +    * [[:en:nestbase | nest base ]] 
 +    * [[:en:listbase | list base ]] 
 +  * DATABASE CONCERNED WITH THE SPECIFIC FIELDS  
 +    * [[:en:medical_database | Medical database ]]
  
-  * 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) 
- 
-===== DATA STRUCTURE  ===== 
- 
-  * Concept: Represents a medical concept (e.g., disease, procedure, anatomical site). Each concept has a unique identifier (concept ID) and a preferred term. 
-  * Description: Provides a textual representation of a concept (e.g., "heart attack"). A concept can have multiple descriptions in different languages and contexts. 
-  * Relationship: Defines the semantic relationship between two concepts (e.g., "is a part of," "is associated with"). Relationships have a type (e.g., "isa," "is_a_finding_of") and a direction. 
- 
-**ABSTRACT STRUCTURE ** 
-  * Create a root page: This page will represent the top-level of the SNOMED CT hierarchy. 
-  * Create child pages: For each concept, create a child page of the root page or another concept page. The page title can be the preferred term of the concept. 
-  * Use headings: Use headings (e.g., == Concept Name ==) to represent the concept name. 
-  * Add descriptions: Add the concept's descriptions below the heading. 
-  * Link concepts: Use internal links (e.g., [[Concept Name]]) to link related concepts. 
-  * Represent relationships: To represent relationships, you can use a table or a list format. For example: 
- 
-**Relationships** 
-* **Is a:** [[Parent Concept]] 
-* **Is a part of:** [[Parent Concept]] 
-* **Is associated with:** [[Related Concept]] 
- 
-===== SAMPLE ===== 
- 
-== Heart Attack == 
-* **Description:** A condition in which the blood supply to the heart is interrupted. 
- 
-=== Relationships === 
-* **Is a:** [[Acute Coronary Syndrome]] 
- 
- 
-* **Is associated with:** [[Chest Pain]] 
-* **Is associated with:** [[Shortness of Breath]] 
  

This topic does not exist yet

You've followed a link to a topic that doesn't exist yet. If permissions allow, you may create it by clicking on Create this page.

  • en/database.1726056471.txt.gz
  • 2024/09/11 12:07
  • brahmantra