Training activity information
Details
Design and describe a relational data model for genomics
Type
Developmental training activity (DTA)
Evidence requirements
Evidence the activity has been undertaken by the trainee​.
Reflection on the activity at one or more time points after the event including learning from the activity and/or areas of the trainees practice for development.
An action plan to implement learning and/or to address skills or knowledge gaps identified.
Considerations
- Database tables
- Primary and foreign keys
- Indexes
- Database schema
- Database normalisation
- Data integrity
- Data backup strategy
Reflective practice guidance
The guidance below is provided to support reflection at different time points, providing you with questions to aid you to reflect for this training activity. They are provided for guidance and should not be considered as a mandatory checklist. Trainees should not be expected to provide answers to each of the guidance questions listed.
Before action
- What knowledge of relational databases and data modelling principles is necessary?
- What principles of relational data model design do you hope to understand better? How will this activity enhance your understanding of storing genomics data? What are your current understanding of database structures?
- Will you research relational data models and their application in genomics? Have you discussed specific requirements for the data model with your training officer? What potential difficulties do you anticipate in designing a suitable model? What are your initial thoughts on how to approach this task?
In action
- What entities are you identifying within the genomics domain that need to be represented in your data model? How are you defining the relationships between these entities? What decisions are you making about primary and foreign keys?
- Are you able to logically structure the data model? Are you identifying potential ambiguities or areas for improvement in your design? Are you considering different ways to represent the relationships?
- If you encounter challenges in defining the relationships, are you revisiting the entities or considering different types of relationships (one-to-one, one-to-many, many-to-many)? Are you sketching out diagrams to help visualise the model?
On action
- Summarise the relational data model you designed for genomics. What key entities and relationships did you include?
- What principles of relational database design did you learn or reinforce? Did you encounter any challenges in determining the relationships between different genomics data elements? What did you learn from these challenges? How did your thinking during the design process (‘reflect-in-action’) shape the final data model? How does the ability to design relational data models relate to managing and analysing genomics data in your future practice?
- What aspects of relational data modelling do you want to explore further? How can you apply your understanding of relational models to interact with existing genomic databases? What specific actions will you take to further develop your data modelling skills? What resources or support would help you to improve your understanding of relational data models for genomics?
Beyond action
- Have you been involved in any projects that required database design since this training activity? How did your understanding of relational data models influence your approach?
- Can you see how a well-designed data model impacts the efficiency and integrity of genomic data analysis in the long term?
- How might your ability to design data models contribute to the development of new bioinformatics tools or databases in the future?
Relevant learning outcomes
| # | Outcome |
|---|---|
| # 1 |
Outcome
Arrange and store data for programmatic analysis. |