GReat Learning
276 Followers
Dunfermline, Fife, United Kingdom
About the store
I have been teaching in Scottish Secondary schools since 1994.
Since 1999 I have been a department head.
I am an author of two text books, dozens of free/paid resources and have been downloaded over a million times all over the world.
In addition to school work I have been employed by Scotland's Exam Board (Scottish Qualifications Authority) to write national exams and coursework tasks. I was part of the working group that implemented Scotland's new National 5 Computing Science course.
Read moreBack
Database SQL
Filters
Grade
Resource type
Audience
Database SQL Questions (Beginner)
This unit was written to provide homework, class assessments or additional tasks to complement your own database teaching. The theme of the two table database provided is Scottish golf club members and their competition results. There are five task sheets included as MS Word files: Task 1 – Analysis & Design – students must identify the information to be stored and then construct an entity relationship diagram and a data dictionary.Task 2 – SQL - 8 questions of varying difficulty based on SELECT
8th - 12th, Adult Education, Higher Education
Database SQL Questions (Intermediate)
This unit was written to provide homework, class assessments or additional tasks to complement your own database teaching. The theme of the five table relational database provided is Scottish golf club members and their competition results. There are eight task sheets included as MS Word files: Task 1 – Analysis & Design – students must identify how problems identified from the beginner design can be solved through the introduction of more tables.Tasks 2,3 – Query design questions where the colu
10th - 12th, Adult Education, Higher Education
Computer Science - Technology
Showing 1-2 of 2 results
About the store
Experience
I have been teaching in Scottish Secondary schools since 1994.
Since 1999 I have been a department head.
I am an author of two text books, dozens of free/paid resources and have been downloaded over a million times all over the world.
In addition to school work I have been employed by Scotland's Exam Board (Scottish Qualifications Authority) to write national exams and coursework tasks. I was part of the working group that implemented Scotland's new National 5 Computing Science course.
Teaching style
I am an imaginative, highly creative teacher who loves to try new approaches in my classroom.
Awards & shining teacher moments
Many of my resources have been tagged as excellent by the Resources team on TES Resources. They have featured often in their quarterly newsletters and regularly appear in the top 10 downloads for Computing (out of 10,000 resources).
My own education history
BSc in Science (Chemistry & Computing)
Post Graduate Diploma in Systems Integration
PCGE in Secondary Education
Additional biographical information
I have a love of competitive sport, music, walking my Labradoodle and have a season ticket (along with my son) for Dunfermline Athletic Football (Soccer) Club.
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands