Data Interfacing
How the database was structured to efficiently manage and retrieve bioinformatics datasets.
Database Design: The schema was structured around a central 'Patients' table, linked to secondary tables through primary and foreign key relationships.
Normalisation: The database was normalised, ensuring each table corresponds to a separate entity, with columns and rows representing attributes and data.
Data retrieval: This entails constructing dynamic SQL queries that accommodate various search criteria and apply logic to ensure precise matching.