Design normalised databases, implement queries, and build data management solutions assessed through an external practical examination.
The Creating Systems to Manage Information (Unit 2) unit develops database design and SQL skills essential for data-driven organisations, assessed via an external practical exam.
Learners model entities, relationships, and normalised structures before implementing functional databases with queries, forms, and integrity controls.
This unit is foundational for careers in data analysis, software development, and enterprise information management.
This unit develops practical, industry-aligned competencies across 4 core learning modules:
Gather user requirements and define entities with attributes
Draw entity-relationship diagrams and resolve many-to-many links
Apply first, second, and third normal form principles
Document data dictionaries and business rules
Create tables, primary keys, foreign keys, and referential integrity
Import and validate datasets from external sources
Build user-friendly interfaces for data entry and reporting
Compare Access, MySQL, and other platform capabilities
Construct simple and complex queries with criteria and joins
Generate management reports and calculated fields
Optimise performance with indexing and efficient design
Test outputs against expected results and user acceptance
Complete timed database build tasks to Pearson specifications
Demonstrate troubleshooting and amendment under exam conditions
Export evidence of queries, results, and design documentation
Reflect on design choices in professional technical language
Internal and external assessment deadlines follow Pearson BTEC session calendars. Confirm key dates with ICT Business School at enrollment.
All coursework and exam submissions must meet Pearson authenticity standards. Plagiarism checks and verification apply to every unit.
Access tutor feedback, assignment briefings, and resubmission guidance through our structured BTEC support pathway at ICT Business School.
Our academic advisors can guide you through unit enrollment, portfolio requirements, and Pearson assessment preparation.