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 comprehensive 34-page portfolio covers Parts A, B, C, and D in full detail, providing teachers with an authentic high-grade moderation reference and students with an exemplary model answer for RDBMS design and Microsoft Access implementation.
Resource Highlights & Content Breakdown:
• Part A (Purpose & Structure of Relational Database Management Systems):
- In-depth theoretical framework detailing RDBMS principles, purpose, data redundancy elimination, and integrity constraints.
- Analysis of relational structures, primary/foreign keys, entity relationships (1:1, 1:M, M:M), and relational algebra (Projection, Selection, Joins).
- Detailed normalization guide explaining Unnormalised Form (UNF), First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF) to resolve transitive and partial dependencies.
- Database administration, user access privileges, security, data integrity, and backup/recovery strategies.
• Part B (Database Design & Relational Modelling):
- Comprehensive database design for “Go Wild Wildlife Park” (Wollombi, NSW, Australia) managing endangered species, keeper ranks, diets, and enclosures.
- Detailed Data Dictionaries across 5 interconnected tables: Animals, AnimalSpecies, Animals Diet, Keepers, and Enclosures.
- Full Conceptual, Logical, and Physical database models alongside Entity Relationship Diagrams (ERDs).
• Part C & D (Implementation, Testing, Verification & Evaluation):
- Complete Microsoft Access build screenshots covering table designs, field sizes, data types, lookups, and validation rules.
- Interactive Data Entry Forms for all 5 entities with custom navigation and command buttons.
- Parameter, Crosstab/Aggregate, and Multi-table SELECT/JOIN Queries demonstrating advanced SQL/GUI filtering (e.g., critically endangered species, enclosure animal counts, keeper rank filters).
- Professional grouped summary reports generated using Report Wizard.
- Robust Test Plan with Normal, Extreme, and Erroneous test cases, actual results, and fix logs.
- Evaluative narrative assessing operational requirements, performance against flat-file legacy systems, scalability, and user interface usability.
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 360 GLH Starter Bundle
A complete 4-unit Distinction exemplar starter toolkit covering the full Pearson BTEC Level 3 IT (360 GLH) qualification pathway: Units 1, 2, 3, and 6. This starter bundle includes 1 verified Distinction-grade portfolio for every unit across the qualification, giving teachers an immediate moderation reference across all mandatory and coursework elements, and students a complete roadmap for top-tier execution. What's Included in This Bundle: • Unit 1 (Information Technology Systems): 1 Full Distinction Exam & Revision Portfolio covering Learning Outcomes A–F (hardware architecture, network protocols/topologies, cloud systems, cybersecurity threats, and data legislation). • Unit 2 (Creating Systems to Manage Information): 1 Full Distinction Database Project (Go Wild Wildlife Park Case Study) covering Parts A–D (relational theory, normalization, comprehensive Data Dictionaries, ERDs, and practical Microsoft Access implementation with queries, forms, reports, and validation). • Unit 3 (Using Social Media in Business): 1 Complete Distinction Coursework Portfolio covering Learning Aims A–C (business platform analysis, full social media marketing strategy with SMART targets, campaign asset rollout, and analytics/KPI evaluation). • Unit 6 (Website Development): 1 Complete Distinction Web Portfolio covering Learning Aims A–C (client brief analysis, responsive wireframes/storyboards, site architecture, HTML5/CSS3/JavaScript build evidence, accessibility reviews, and full client testing plans). Why Choose This Starter Toolkit? - Full 360 GLH Coverage: Get verified Distinction models for both external exam/task units (Units 1 & 2) and internal coursework units (Units 3 & 6). - Save 33%: Includes 4 individual £3 resources (£12 value) for just £8. - Immediate Standardisation: Perfect for first-time unit deliveries, standardising department marking, or providing students with clear structural exemplars. Disclaimer: Provided strictly as an educational and structural reference guide. Plagiarism is strictly prohibited.
£8.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