Introduction to Databases

This excellent PPT provides a clear and easy to teach overview of databases and makes a clear comparison between flat file and relational dbs.

Kkindly contributed by FatMax

RDBMS

This presentation should be used over an entire unit to introduce all the facets involved in conceptualising, designing and implementing a relational databse.

Although it gives a very clear introduction to difficult concepts such as normalisation, other resources should be used in conjunction with this resource to give students as much practical experience as possible.

If and when students are producing a solution to a database problem in a piece of coursework, this presentation along with the ones on the Systems Life Cycle and DFD's work very well with each other to give the students all the tools they need to document a project correctly and ensure that they have included all that is expected of them.

Many thanks to Ritchie King for kindly donating this resource. If you would like to see more examples of Ricthie's work, please click here

Database Management System Concepts - North Chadderton

A comprehensive set of notes written specifically for the AQA syllabus. However, they are just as relevant for the OCR spec.

Source: http://www.nchadderton.zen.co.uk

Databases - Powerpoint

This Powerpoint provides a brief introduction to Database Standards. It could be used as an aid to prompt a discussion with students.

Relational Databases - Powerpoint

This Powerpoint focuses on Relational Databases. It could be used as an aid to prompt a discussion with students.

Flatfile Vs Relational Databases

This document aims to explain the differences between the two types of database.

http://bgs.eriding.net

RDBMS: organisation for effective retrieval - North Chadderton

A comprehensive set of notes written specifically for the AQA syllabus. However, they are just as relevant for the OCR spec.

Source: http://www.nchadderton.zen.co.uk

RDBMS

This presentation starts off by explaining the reasons why a relational database is preferable over a flat-file database.

The presentation then moves on to a look at entities and relationships. It walks you through creating a basic ER diagram.

It is probably the clearest explanation about this topic that I have come across to date.

Kindly contributed by FatMax

Distributed Databases - North Chadderton

A comprehensive set of notes written specifically for the AQA syllabus. However, they are just as relevant for the OCR spec.

Source: http://www.nchadderton.zen.co.uk

Entity relationship modelling and normalisation - S. Mckearny

This website gives students the opportunity to have a go at many practice examples in order to understand the concepts.

Entity Identity

This activity provides a very gentle introduction to entities and ERD.

Kindly contributed by Julia Stevens

Real Relationships

An activity to encourage students to think about the different types of database relationships.

Kindly contributed by Julia Stevens

Resolving Relationships

This activity provides students with a set of example relationships which are set up as 'many to many'.

Their task is to try to resolve the relationships correctly and in so doing, gain a better understanding of this skill.

Kindly contributed by Julia Stevens

PPP Pick a Primary Key

An activity which can be given to students to make them think carefully about what would be a suitable primary key for a database.

Cleverly illustrated.

Kindly contributed by Julia Stevens