BTEC Level 3 IT Unit 2 Distinction Pack 3

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.