This is a software development task and an implementation task.
A group of Sixth Form students have decided to run a press cutting service for the students in their school. They intend to identify and take cuttings of topics related to each examination subject taught at the school.
They propose to hold basic information about each cutting on a database. Students will be able to access this database.
The teacher responsible for IT services at the school has agreed to provide storage space on the system for the database, but there will not be sufficient room to allow cuttings to be scanned in for reading online.
Cuttings will therefore be filed as paper documents, available on request in the school library.
To begin with, and to limit the cost of the exercise, the group of Sixth Form students will take cuttings only from those newspapers and magazines already purchased by the school library and from those they are able to bring in from home.
The school has agreed to cover any other costs for a trial period and to handle any copyright issues that may arise.
A database is required to hold details of the cuttings available and the students who borrow them. It has already been decided to hold the data in the following tables:
Cutting This table holds the following details of each cutting:
Student This table holds the following details:
StudentCutting This table acts as a link between the Cutting and Student tables. It identifies who has accessed which cutting and when.
(a) Create a table called Cutting to hold the details of each cutting.
(b) Create a table called Student to hold the details of each student using the service.
(c) Create a table called StudentCutting to hold information about which students have accessed each cutting.
(d) Create suitable data for each of your tables.
(e) Create a report that lists all the cuttings available for a particular school subject.
(f) Create a report that lists all students who have accessed cuttings since a given date, together with the number of cuttings each student has accessed.
After the database has been in use for some time and has grown substantially in size, it becomes apparent that it would be helpful if students could search the database for articles that contain specific keywords.
It is decided that the keywords, and therefore the searches, will be restricted to single words and that no wild cards will be allowed in the searches.
In order to include this new requirement, a new table is needed.
CuttingKeyword This table consists of two columns:
(g) Develop your existing database to enable a user to undertake a keyword search.
This task was worth 40 Marks. It was a software development task and an implementation task that orginally appeared in OCR 2507 Task 1 Jun 2007. All rights and copyright to OCR. Please refer to the OCR Copyright Statement for further information.