|
|
|
14.3 Key points/learning outcomes |
-
Explain the purpose of a
database management system (DBMS).
-
Explain the role of the
database administrator
-
Explain what is meant by
data consistency, data integrity, data redundancy and data
independence.
-
Explain the concept of
entity relationships and normalisation.
Important Note: The two
bullets below are part of 14.4 and NOT 14.3. I've included them (and a
couple of resources) on this page as well 'cos I think it kind of makes sense.
What do I know? I'm just a dog!
See the
books page for more
details about the titles listed below
McWeeney - A205 Pages 11 - 26
Mott & Leeming -
Chapter 17
Doyle - Chapter 5 & Pages 258-272
Heathcote - Chapters 55-57
AQA past papers
Past papers. Not as useful as the Psionica database AQA shamefully closed
but...
Practice questions
Past paper practice questions for 14.3 (.rtf file - opens in Word/Writer)
suitable for revision/homework etc. etc.
Past paper answers
Answers to the questions above. Password protected .doc file. Sorry but
the password is only available to teachers.
Older Exam Papers
Past papers (pre 2000) not included on the official AQA site from
Colchester VI Form College. These still contain some relevant questions
for this topic. Look for IT05/ICT5 papers.
|
Advertising
Feature |
|
It's not really
advertising as I don't actually get paid anything by the
author!!! Anyway this book on a CD, from acclaimed author Steve
McWeeney, is a "must have" resource for any IT department IMNSHO. |
|
If *you* would like to
advertise your tat here contact the fictitious sales department to be
put on hold...
|
Links to general online
resources for 14.3. I'd recommend right clicking links/icons and "Save
Target As..." for anything other than web pages (see key below)
 |
Database Management Concepts |
A very good set of revision notes from
Gerard Horsley at B&P College. Includes homework exercises and a VERY
nice glossary of key terms. There's a set of questions to go with the
handout here
|
 |
Understanding RDBMS |
Big fat 1MB+ download but well worth the
bandwidth in my big fat opinion! Make sure you check out the speaker
notes with each slide.
|
 |
DBMS Diagram |
One page diagram from Mortimer Wilson. It's
a *bit* fuzzy but sort of explains the concept of program/data
independence if you stare at it for long enough.
|
|
|
Normalisation |
Excellent PowerPoint presentation from
Napier University, Edinburgh. Neatly explains data integrity and data
redundancy. FatMax recommended.
|
|
|
Introduction to DBMS |
Short PowerPoint from Kesgrave. Well worth a
look 'cos it's nothing like all the other bloody PowerPoints you'll see
about DBMS!
|
 |
|
Some *very* good example exercises for you
to have a go at normalising. The answers to each exercise are provided
at the bottom of the page.
|
|
|
Role of
a Database Administrator |
Job description type thingy lifted from one
of those online employment agencies gives an overview of what a DBA does.
|
|
|
Local vs Client Server
Databases |
Short online PowerPoint presentation from
Colchester VI Form College. There's a pretty good set of notes to
accompany the presentation available
here
|
|
|
14.3 Database Management Concepts |
Summary notes and questions for 14.3
Database Management Concepts from North Chadderton High School. Great
for revision.
|
|
|
Databases |
From the very cool teach-ict website - an
introduction to database concepts.
|
|
|
Relational Databases |
Even more stuff from teach-ict. Debbie Jones
probably works too hard - you should send her some flowers or chocolates or something
to say thank you!
|
|
|
Distributed Databases |
Strictly speaking this is part of 14.4 (see the note on the left).
Anyway this is a pretty good factsheet from North Chadderton High.
|
|
|
Database Dictionary |
Online dictionary thingy from
GeekGirls
explains some database related terms in pretty plain English. Not to be
confused with Data Dictionary!
|
|
|
Revision Questions |
|
Handout containing a couple of older IT05
(ICT5) questions from NEAB.
Suitable for homework, revision, blah de blah de blah etc.. |
Key to resources:
|
