That Blue Square Thing

WJEC Applied ICT A Level Unit 1 - eBusiness

Note: this page applies to the legacy WJEC Applied ICT A level specification which has now been withdrawn (last resit opportunity in 2019). A new syllabus is available to schools in Wales that seems similar.
I no longer teach A Level Applied ICT but I'll leave these pages up as an archive which might still be helpful for someone, somewhere.

Block four - Databases

Databases can be the tricky part of this course. They will always appear on exams and in Unit 2 portfolio pieces, so you have to be good at working through them quickly and efficiently.

This block gives you a start on databases and, hopefully, reminds you of some of the key ideas you dealt with at GCSE. It will develop a bit more as I work through the teaching of the key ideas.

Introduction to databases

Let's start with the simple stuff...

PDF iconIntroduction to databases - there's a lot of theory you need to try to get your head around. Trust me, knowing the theoretical side of this will make like a lot easier when you get into an exam room!

PDF iconDatabase tables - how data is stored in tables in a database

MS Word iconData types table - to complete

Now try some exercises to check you understand what's going on.

PDF iconDatabase example exercise - to check key understanding of vocab

PDF iconBird Species exercise - to work through

PDF iconTutors and courses exercise - to work through as well

It's really important to name things in databases just right. Essentially this means using the Leszynski naming convention. Really.

PDF iconNaming conventions for databases

Moving to Relational Databases

Simple isn't always best. In fact, simple can get too complex...

PDF iconTutors and courses example - a database to start to build

PDF iconAdding to the tutors and courses database - some data to add to the database

MS Access icondbTutorCourse database - the first design of this database

So, that doesn't work very well. Let's solve the problem with a relational database...

PDF iconRelational databases - a start to an introduction