Unit 2 Creating Systems to Manage Information

January 2020 Exam Paper and Notes

Exam Papers and Associated Files (link to Pearson: https://qualifications.pearson.com/content/dam/secure/silver/all-uk-and-international/btec-nationals/information-technology/2016/external-assessments/BTEC-Nationals-L3-IT-Unit-2-Jan-2020_@_zip)

Part A

Activity 1 - Entity Relationship Diagram (ERD)

Normalisation Slideshow

Activity 2 - Data Types and Validation

Validation

Activity 3 - Queries and Report

Query 3a - Create a query to display an alphabetically sorted list of regular and new customers. It must show the customer name and telephone number only.

Query 3b - Create a query that would allow a user to enter the parameter value for the ticket type when run...

Report 3c - Create a report that shows the effect of having a 3% discount on the ticket price for tickets that have been sold.

Part B

Form 6a(i) - New Staff Record

Form 6a(ii) - Staff Availability Checker