11.3 Organisation of Data
Specification Content/Learning Outcomes |
Organisation of data for effective retrieval looks at the uses of databases and they are used to store data so that it can be retrieved to produce meaningful information.
|
Resources - Organisation of Data
Key to resources: | PowerPoint presentation | Word file | Acrobat file | |||
Internet resource | Video |
Resource |
Type |
Size |
Notes |
Organisation | n/a | Alcester Grammar School links covering this topic | |
Tables, forms, queries | 397KB | PowerPoint presentation from The Billericay School. | |
Introduction to Databases | 85KB | PowerPoint presentation from Chris Brown. | |
Database index | n/a | Good introductory notes and examples. | |
Access Resources | n/a | Access resource page from David Yates |
Add/suggest new resources - Click here to suggest new resources relevant to this topic. Do NOT add attachments e.g. Word documents to your suggestions as these will be discarded.
Reading - Organisation of
Data
Texts other than Heathcote can be found in the ICT section of the Library
Resource Centre.
Key to reading: | Heathcote - Core Text | Internet resource | Other book | |||
Handout/worksheet |
Reading |
Type |
Size |
Notes |
Introduction to Databases | n/a | Heathcote Ch.16 Pages 91 - 96 | |
Relational Databases | n/a | Heathcote Ch.18 Pages 97 - 101 | |
Tables, Forms, Queries & reports | n/a | Heathcote Ch.19 Pages 102 - 108 | |
Relational Databases | n/a | Doyle Ch.5 Pages 77 - 85 | |
Introduction to Databases | n/a | Greenwood School's 'ICT2 Textbook' | |
Data Structures | n/a | Notes from Mark Hunter Computing |
Practice questions/homework - Organisation of Data
Key to questions: | Past exam question | Heathcote question | Other question | |||
FatMax assignment | Smokin' Dog assignment |
Reference |
Type |
Size |
Question | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1. Summer 2002 ICT2 Question 9 | n/a | A flat file system is used to
store orders taken by an electrical retailer. Examples of records from the
file are shown below.
(a). Referring to the examples above, describe the problems that have occurred by storing the data in a single file flat file. (6) (b). The flat file system is to be replaced
by a relational database. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2. Spring 2002 ICT2 Question 5 | n/a | A database has been used to
replace a flat file information storage and retrieval system. List four advantages of using a database. (4) (4 marks) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3. Summer 2001 ICT2 Question 7 | n/a | A company that organises music
festivals sells tickets via the Internet. An on-line booking form has to be
completed to reserve the tickets. (a). State three fields other than Name, Address and Postcode that you would expect to find on the booking form. (3) (b). Name and describe a different
validation check for each of the fields you have chosen. (6)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4. Spring 2001 ICT2 Question 5 | n/a | A company is experiencing
difficulties with its computerised flat file information storage and
retrieval system. Describe three benefits that the company would gain by
converting to a relational database system. (6 marks) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5. AEB 1997 Computing Question 2 | n/a | Name and describe two
validation checks that could be used when a product code number is input. (4 marks) |
AS Modules | ICT2 | Links | Top | Home | FatMax1 |
Copyright/Disclaimer - I think everyone whose work appears on this site has been properly credited. If not, get in touch and I'll make the necessary amendments. FatMax2 is not an official AQA site (in case you hadn't guessed!) For official AQA documents the only 'reliable' source is the Official AQA website FatMax 2002/2003.