Task 3 - Specification (3 marks)
- Create a table with the following headings…
-
(M - 1 mark) Complete the ‘Specification point’ column. To do this…
- Type a list of everything you can think of that describes what the system needs to do or include.
- Things to think about when doing this: input, validation, processing and output.
-
(S - 1 mark) Complete the ‘Explanation’ column, saying why each specification point is needed.
-
(C - 1 mark) Complete the ‘Success criteria’ column. For each specification point, state and explain what it needs to do or be like to be successful.
Task 4 - Database design (1 mark)
-
(M) - Skip this section.
-
(S, C - 1 mark) Complete the following database design plan…
Task 5 - Systems design (1 mark)
-
(M, S) - Skip this section.
-
(C - 1 mark) Using section 34 of your Student Handbook to help, draw a system flowchart to show the following steps. To help you do this, use the symbols found by selecting Flowchart symbols from the Autoshapes menu (Found on the Drawing toolbar. If the toolbar is not displayed, click on View - Toolbars - Drawing and it should appear at the bottom of the screen.
- Enter product details into stock file (saved onto magentic disk) using a keyboard.
- Validate data.
- Sort into name order.
-
Search (query) for all names and prices of all products whose price is more than £2.00.
- Print report.
Task 6 - Implementation - Setting up the table (2 marks)
Create up the database in Access. You will need to set up the following…
- Field names
- Data types
- Primary key field
- Field lengths (for text)
- Validation rules
- Validation text
(M - 1 mark) Add a screen shot of your table in ‘Design view’ to your write up.
(S, C - 1 mark) Type detailed descriptions to say what you have set up.
Task 7 - Testing (1 mark)
(S, C - 1 mark)…
- Enter (input) the test data to see if the database will accept valid data and reject invalid data.
- Input at least 6 more typical records (Use GWL or CSO as supplier codes).
- Add screen shots to your write up to show that the validation settings work - eg: Validation messages when invalid data is entered.
Task 8 - Implementation - Processing & producing outputs (6 marks)
The supermarket has now asked you to set up the following queries and produce reports of each. Edit the last report you produce to improve the layout - Print a copy of this report.
(M - 2 marks)
(S - 2 marks)
(C - 2 marks)
Task 9 - Evaluation (3 marks)
(M - 1 mark) Copy and paste your specification. Make the final column ‘Evaluation’…
- Complete the ‘Evaluation’ column to say how well your system satisfies your each point of your specification.
(S - 1 mark) Copy and paste your specification, delete the ‘Explanation’ and move the ‘Success criteria’ to the left. Make the final column heading, ‘Evaluation’.
- Complete the ‘Evaluation’ column to say how well your system satisfies your success criteria.
(C - 1 mark) Suggest and justify possible future improvements to your system.
Extension (For all grades - completing this will add a grade to your final mark).
You have been asked to add a feature for ordering more stock. You have realised that you will need a database that consists of 3 linked tables.
-
What is this type of database called?
-
What are the links between the tables called?
-
What is the following diagram?
- Create the database using the following fields. You will need to decide how long the text fields need to be and include any validation that you think is needed. Enter some test data to try out your database.
STOCK (Stock ID, Barcode Number, Name, Price, Number in Stock, Minimum Order Quantity, Reorder Quantity, Supplier Code)
ORDER (Order ID, Order Date, Ordered by, Delivered)
STOCK ON ORDER (Order ID, Stock ID)
- Create a report to produce an order form containing details of the items in orders that have not yet been delivered. Include the Order ID, Order Date, who made the order, the stock ID, name and the reorder quantity). Print the report.
- Create a data entry form, which includes a subform.
-
(M, S, C) Evidence - Add screen shots of your table designs, relationships, report and data entry form into your write up.
Supermarket database task GCSE ICT
Self-assessement and Mark Sheet Name:
