📌 Main Tables and Entities
• AHC (Academic Health Center): stores information about the academic and healthcare institutions involved.
• Patent: contains data on patents, including titles, inventors, and registration dates.
• Dataset: describes datasets used or produced in research, along with associated metadata.
• Grant: includes funding details such as granting bodies, amounts, and durations.
• Clinical_Trial: provides information on clinical studies, including phases, objectives, and results.
• Researcher: contains researcher profiles, affiliations, and areas of expertise.
• Article: archives scientific publications, including references and abstracts.
🔗 Relationships Between Entities
Relationships between entities are modeled using associative tables that implement foreign keys to preserve referential integrity. For example:
• ASSOCIATED_WITH: links AHCs with Patents, Datasets, and Grants.
• CONDUCTED_AT: connects Clinical_Trials with AHCs.
• WRITTEN_BY: associates Articles with Researchers.
• CITES: manages citation relationships between Articles.
• COLLABORATED_WITH: represents collaboration networks among Researchers.
These relationships are implemented through join tables that contain the primary keys of the involved entities, ensuring data consistency via referential constraints.
⚙️ Technical Characteristics
• Normalization: the tables are structured to minimize redundancy and improve query efficiency.
• Integrity Constraints: use of primary and foreign keys to enforce data consistency. • Data Types: strict definition of data types for each attribute (e.g., strings, integers, dates).
• Indexing: indexes are created on key attributes to optimize query performance.
This relational design enables SciK-Health to efficiently manage the complex and interconnected information typical of scientific research in the healthcare sector.