|
|
|
11.3 Key points/learning outcomes |
-
Describe the nature and
purpose of a database and how they work.
-
Understand that data needs to
be organised in a database to allow for effective updating and
retrieval.
-
Understand how data can be retrieved to produce meaningful
information.
-
Recall the relevant
advantages of databases over flat file information storage and retrieval
systems.
-
Select and justify
appropriate file and database structures for particular applications
See the
books page for more
details about the titles listed below
Mott & Leeming
Heathcote
Doyle - Pages 77 - 85
McWeeney
AQA past papers
Past papers. Not as useful as the Psionica database AQA shamefully closed
but...
Practice questions
More practice questions for 11.3 (.rtf file - opens in Word/Writer)
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 the IT02/ICT2 papers.
|
Links to general online
resources for 11.3. I'd recommend right clicking links/icons and "Save
Target As..." for anything other than web pages (see key below)
 |
Flash Notes |
Steve Longley's excellent online flash
notes for 11.3 - Organisation of Data.
|
 |
Flash Notes |
Offline version of the above. Right
click link and Save Target As...
|
 |
Databases - Revision |
Short handout covers advantages and
disadvantages of databases concisely. Good for revision.
|
 |
Introduction to Databases |
Slideshow notes from North Carolina
University. Gets a *bit* hairy in places but a pretty good resource
overall.
|
 |
Databases |
Introduction to databases. Very good
PowerPoint from Teach-ICT.
|
|
|
Relational Databases |
Continuation of the above PowerPoint tackles
relational databases.
|
|
|
Interactive
Diagram |
"Flashy" interactive mind-mappy type diagram
thingy to help with your revision.
|
|
|
Database index |
Good introductory notes, examples and
downloads from Andrew Virnul's excellent ICT Topics in a Nutshell site
|
|
|
Introduction to 11.3 |
Introduction to organisation of data for
effective retrieval
from Kesgrave High School.
|
|
|
Revision Questions |
Handout containing a couple of questions.
Suitable for homework, revision, blah de blah de blah.
|
|
|
Tables, forms, queries |
Simple introduction to the basic elements of
database design from Billericay School.
|
|
|
11.3 Organisation of Data |
Summary notes and questions from North
Chadderton High School.
|
|
|
RDBMS FAQs |
Fairly easy to follow online notes covering
a range of database concepts.
|
|
|
RDBMS |
Brief online
PowerPoint presentation from
OCRICT
is relevant to AQA 11.3.
|
|
|
RDBMS |
The same
PowerPoint available for download as a self-extracting zip file.
|
Key to resources:
|
|
PowerPoint
presentation |
|
|
Word file |
|
|
Web page |
|
|
Macromedia Flash |
|
|
