Training activity information
Details
Create a relational database from available departmental data sources
OR
Modify an offline copy of an existing database incorporating new data tables
Develop data input forms or methods to populate tables, queries to extract subsets of the data, and reports to output data in a readable/viewable form
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
- Organisational or departmental data sources
- User consultation
- Database purpose and design
- Importation of existing datasets from a spreadsheet
- Grouping of data entities into tables
- The relationships between data entities using a mapping tool
- Database validation
- Security and governance standards
Relevant learning outcomes
| # | Outcome |
|---|---|
| # 1 |
Outcome
Explore and explain relationships between elements in a system. |
| # 2 |
Outcome
Select, perform and critique statistical analyses and interpretations on clinical and operational datasets. |