Unit 2: Creating Systems to Manage Information
Design normalised databases, implement queries, and build data management solutions assessed through an external practical examination.
What is Unit 2 — Creating Systems to Manage Information?
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.
Core Strategic Value
- •Data Modelling: Produce ERDs, keys, and normalised relational schemas.
- •SQL Proficiency: Write SELECT, JOIN, aggregate, and data manipulation statements.
- •Quality Assurance: Validate data integrity, validation rules, and testing outcomes.
What You Will Study
This unit develops practical, industry-aligned competencies across 4 core learning modules:
1. Data Requirements & Conceptual Design
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
2. Database Implementation & Tools
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
3. Queries, Reports & Performance
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
4. External Practical Exam Tasks
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
Structure & Parameters
Assessment Policies & Logistics
Submission Windows
Internal and external assessment deadlines follow Pearson BTEC session calendars. Confirm key dates with ICT Business School at enrollment.
Academic Integrity
All coursework and exam submissions must meet Pearson authenticity standards. Plagiarism checks and verification apply to every unit.
Learner Support
Access tutor feedback, assignment briefings, and resubmission guidance through our structured BTEC support pathway at ICT Business School.
Need Assignment Briefs or Fee Information?
Our academic advisors can guide you through unit enrollment, portfolio requirements, and Pearson assessment preparation.