Second complete Distinction-grade exemplar coursework portfolio for Pearson BTEC Level 3 Unit 2: Creating Systems to Manage Information (Go Wild Wildlife Park Case Study).
This additional Distinction sample gives teachers a second high-grade moderation reference and offers students a full alternative model answer covering Learning Aims A, B, and C.
Resource Highlights & Content Breakdown:
• Learning Aim A (Purpose, Benefits & Structure of Relational Databases):
- In-depth Distinction evaluation of Relational Database Management Systems (RDBMS) vs. flat-file systems.
- Analysis of data redundancy, integrity constraints, primary/foreign keys, cardinality, and referential integrity.
- Detailed breakdown of data anomalies (insertion, update, deletion) and relational algebra operations (SELECT, JOIN, UNION, INTERSECT).
- Database administration, user access security, recovery protocols, and full explanation of 1NF, 2NF, and 3NF normalisation.
• Learning Aim B (Database Design & Specification):
- Complete Entity Relationship Diagram (ERD) created in SmartDraw showing 1:M relationships across 5 core tables.
- Data Dictionary specifications for tblAnimal, tblKeeper, tblSpecies, tblEnclosure, and tblDiet.
- Comprehensive pre-implementation test plan covering data types, range checks, format validation, and presence checks.
• Learning Aim C (Microsoft Access Implementation, Queries, Forms & Evaluation):
- Live implementation in Microsoft Access with populated dataset tables.
- Development of advanced SQL queries (parameter queries, cross-table joins, criteria filtering, and calculated aggregate fields like =Count(*)).
- Professional custom user forms with UI color coding and drop-down navigation.
- Custom grouped report generation (“Dave and Temi Report”).
- Post-implementation testing log analysis and final system evaluation against user requirements.
Disclaimer: This resource is provided strictly as an educational and structural reference guide for teaching and learning purposes. Plagiarism is strictly prohibited.
Get this resource as part of a bundle and save up to 58%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Bundle
BTEC Level 3 IT 360 GLH Master Bundle
The ultimate 12-portfolio Distinction exemplar master library for the Pearson BTEC Level 3 IT (360 GLH) Extended Certificate, covering Units 1, 2, 3, and 6 in comprehensive detail. This master bundle includes 3 complete, verified Distinction-grade student portfolios for every unit across the qualification. It provides teachers with an exhaustive, multi-perspective moderation reference to accurately calibrate grade boundaries and offers students multiple high-scoring models to analyze database implementation, web design, social media strategy, and IT theory. What's Included in This Bundle: • Unit 1 (Information Technology Systems): 3 Complete Distinction Exam & Revision Portfolios (all Learning Outcomes A–F). Compare three different analytical approaches to digital hardware, network transmission, cloud infrastructure, security models, and legislative impacts. • Unit 2 (Creating Systems to Manage Information): 3 Complete Distinction Database Projects (Go Wild Wildlife Park Case Study). Study three unique relational architectures, normalization workflows, complete Data Dictionaries, ERDs, and functional Microsoft Access builds (validation, queries, forms, reports). • Unit 3 (Using Social Media in Business): 3 Complete Distinction Coursework Portfolios (Learning Aims A–C). Check three different campaign strategies, content schedules, target audience engagement models, live asset implementations, and analytical KPI evaluations. • Unit 6 (Website Development): 3 Complete Distinction Web Portfolios (Learning Aims A–C). Compare three distinct responsive wireframe sets, site maps, full HTML5/CSS3/JavaScript codebases, testing plans, and post-implementation client evaluation reviews. Why Choose This Master Library? - Multi-Student Perspective: Evaluate 3 distinct peer approaches per unit to confidently standardise marking and identify varying pathways to a Distinction. - Save Nearly 60%: Access 12 individual £3 resources (£36 total value) in one definitive collection for just £15. - Complete 2-Year Curriculum Support: Secure the ultimate teaching, marking, and revision framework for the entire qualification. Disclaimer: Provided strictly as an educational and structural reference guide. Plagiarism is strictly prohibited.
£15.00
Bundle
BTEC Level 3 IT Unit 2 Distinction Bundle
A complete 3-student Distinction exemplar bundle for Pearson BTEC Level 3 Unit 2: Creating Systems to Manage Information (Go Wild Wildlife Park Case Study). This bundle contains 3 complete Distinction-grade student portfolios covering Parts A, B, C, and D in full detail, providing teachers with a comprehensive moderation reference and students with exemplary model answers for database design and Microsoft Access implementation. What's Included in This Bundle: • 3 Complete Student Portfolios covering Parts A, B, C, and D (100+ total pages of verified exemplar content). • Part A (Database Theory & Architecture): RDBMS principles, data redundancy elimination, relational algebra (Projection, Selection, Joins), entity relationships (1:1, 1:M, M:M), and normalization step-by-step (UNF, 1NF, 2NF, 3NF). • Part B (Database Design & Data Dictionaries): Conceptual, logical, and physical models, full Data Dictionaries across 5 interconnected tables (Animals, AnimalSpecies, Animals Diet, Keepers, Enclosures), and Entity Relationship Diagrams (ERDs). • Part C & D (Implementation, Testing & Evaluation): Complete Microsoft Access build screenshots (Tables, Data Types, Validation Rules, Lookups), interactive Data Entry Forms with navigation/action buttons, complex Parameter & Aggregate Queries, grouped summary Reports, comprehensive Test Plans (Normal, Extreme, Erroneous), and post-implementation evaluation logs. Why Choose This Bundle? - Multi-Student Perspective: Compare 3 distinct student database designs and implementation styles to calibrate grading boundaries accurately. - Save Over 33%: Includes all 3 individual £3 resources for just £6. - Complete Technical Reference: Ideal for guiding students through normalisation, ERDs, SQL/Access queries, and test plans. Disclaimer: Provided strictly as an educational and structural reference guide. Plagiarism is strictly prohibited.
£6.00
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.00