Part A Exams Practice

Part A Exams Practice
1 / 16
next
Slide 1: Slide
Ilearningdeal@gmail.comPrimary EducationLower Secondary (Key Stage 3)Upper Secondary (Key Stage 4)Further Education (Key Stage 5)Higher Education (degree)Higher Education (non-degree)Special Education

This lesson contains 16 slides, with interactive quizzes and text slides.

Items in this lesson

Part A Exams Practice

Slide 1 - Slide

Data Set
The Next  slide shows the data set 

Slide 2 - Slide

Slide 3 - Link

Slide 4 - Link

Slide 5 - Slide

Please  see the solution 
Next slide see the solution.
1. ERD
2. Fill in tables
3. Query 

Slide 6 - Slide

Slide 7 - Link

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

Slide 8 - Slide

From your ERD Diagram- Describe the relationships

Slide 9 - Open question

Query Design 

Slide 10 - Slide

Slide 11 - Slide

Tutor to lead
Tutor will go through queries 
and student to follow and do their own one on the link provided

Slide 12 - Slide

Slide 13 - Drag question

Here is the Data Set 
Jan 2022

Slide 14 - Slide

The End

Slide 15 - Slide

Slide 16 - Slide

More lessons like this