Part A Exams Practice

• [e-mail]
• Primary Education
• Lower Secondary (Key Stage 3)
• Upper Secondary (Key Stage 4)
• Further Education (Key Stage 5)
• Higher Education (degree)
• Higher Education (non-degree)
• Special Education

Part A Exams Practice

Data Set

The Next  slide shows the data set 

ucguk-my.sharepoint.com

ucguk-my.sharepoint.com

Please  see the solution 

Next slide see the solution.

1. ERD

2. Fill in tables

3. Query 

ucguk-my.sharepoint.com

Using the slide above 

1. Produce Print screen for ERD

2. Print screens for all your tables  and Validation in Design View

3. Print Screen of your Filled in tables

From your ERD Diagram- Describe the relationships

Query Design 

Tutor to lead

Tutor will go through queries 

and student to follow and do their own one on the link provided

Here is the Data Set 

Jan 2022

The End