BTEC Level 3 IT Unit 2 Distinction Exemplar

Complete Distinction-grade exemplar coursework for Pearson BTEC Level 3 Unit 2: Creating Systems to Manage Information (Go Wild Wildlife Park Case Study).

This 39-page comprehensive resource covers Learning Aims A, B, and C in depth. It serves as an ideal model answer for students and a complete grading reference for teachers delivering BTEC Level 3 IT.

Resource Highlights & Structure:

Learning Aim A (Relational Database Concepts & Structure):

• Comparison of desktop databases vs. server-based database systems.

• Theoretical breakdown of relational structures: relations, attributes, domains, tuples, cardinality, and relational algebra operations (union, intersect, join, select).

• Relational keys (super, candidate, primary, foreign) and integrity constraints (entity & referential integrity).

• Step-by-step normalisation walkthrough (UNF , 1NF, 2NF and 3NF) with anomaly explanations (update, insertion, deletion).

**** Learning Aim B (Database Design & Specification):****

• Data dictionaries for 5 normalized tables: Species, Animals, Keepers, Enclosures, and Diet.

• Detailed Entity Relationship Diagram (ERD) mapping all 1:M relationships.

• Pre-implementation test plan featuring normal, erroneous, and extreme test data.

**** Learning Aim C (Implementation, Testing & Evaluation):****

• Full Microsoft Access database construction screenshots across all tables.

• SQL & Access Queries implemented: alphabetical sorting, aggregate counting with Group By, parameter prompts, multi-table joins, and complex filtering.

• Professional grouped report creation using Report Wizard with aggregate =Count(*) functions.

• Fully executed test plan with actual results, remedial actions taken, and final evaluation.

**** Disclaimer: This resource is provided strictly as an educational and structural reference guide for teaching and learning purposes. Plagiarism is strictly prohibited.****