S3 ComputingDatabases Assignment

Knox badge


Now that you have done your assessment and hopefully done very well in it (!), your next assessment comes in the form of an assignment.

This assignment is at designed to assess at Level 5.

Create the database

The World of PCs near Haddington that wishes to list all of it's products and recent sales using a database.

The tables for the database are shown below:


productID ProductName Price Picture QuantityInStock Reorder
1 Core i9 9900K £299.99 Picture 13 No
2 Core i5 10600K £109.99 Picture 99 No
3 AMD Ryzen 2700X £59.99 Picture 2 Yes
4 Corsair HX850i PSU £139.99 Picture 27 No
5 1x 8GB Corsair Dominator DDR4 RAM £39.99 Picture 1000 No

For the Products table, the following assumptions can be made:

  • There are more than 3 product records in this database - this is a snapshot of the whole database.
  • The Reorder field becomes Yes when the QuantityInStock field is 10 or less.


orderID productID QuantityPurchased
1 3 1
1 5 2
1 4 1
2 3 9

For the Orders table, the following assumptions can be made:

  • The orderID is not an auto incrementing (auto ID) value and just an assigned number.
  1. Create a database with both tables in it. Ensure you use suitable data types for each field, including calculations. 5 marks
  2. Create a relationship between the two tables. 1 mark
  3. Create form for the Products table. 2 marks
  4. Create and save a query that will find all information on all products that we ordered with the orderID of 1. 2 marks
Provide Feedback

What did you think of this document?

-- DragonDocs version 0.9 --


Started on DragonDocs
Created a YASS/PHP and HTML-based system for saving and retrieving data

Added CSS styles to page
Added JavaScript code to the page

Added the multipage option (used in my dissertation)
Added the XMLHttpRequest-based multipage requests

Added the Accessibility features
Filters added

Purple filter added

Added the Note class
Added the Did You Know class

-- DragonDocs version 1.0 (Yosemite) --

First trial of DragonDocs in teaching

Added the Task, Starter, Review your learning sections

Added the feedback feature
Added the Dark Mode toggle

Performance gains through the removal of unnecessary code
Added the Learning Intentions and Success Criteria features
Added the school badge

Changed the headings (h2) to be more consistent with my website
Added sections to the pages - sections must be preceded by a h2
Added the "I have read this section" buttons
Changed the main heading zone to gradient text like my website
Added the table of contents feature

Added the Print feature
Updated the footer to feature a new gradient
Added the Test It! class
Added the green flag
Automated the table of contents using JavaScript

Added the 'includes' feature to the document, allowing inclusion of other files easily
Removed the requirement that the IP address must be one of the schools I have taught at, opening these documents to the public

Once a section has been read or completed, the user can now hide that section

Added the Extension task class
Changed the scrollbar on Windows to match that of macOS

-- DragonDocs version 2.0 (Kilimanjaro) --

Added the Save button and the ability to save 'results' or answers to a Word document

Added the large numbers class
Removed the background of the page navigation

-- DragonDocs version 2.1 (Aurora) --

Added the active class to active links in the bottom section

Added the image upload feature

Added a fix that prevents the upload of non-image files into an image upload
Added pasting images to the upload feature

Added the ability to view the changelog from a document
Improved the feedback system by recording the DragonDocs User ID and the Document ID data
The feedback from DragonDocs can be accessed much easier

Added the new step_by_step_mode feature, allowing sections to be viewed individually

Added new checkboxes to each list item in a .task or .step
Added functionality to said checkboxes to add a strikeout to steps completed

Added the new 'step' class
Steps are now auto incremented in CSS so the name displays the step number
Activities are now also auto incremented to display the activity number

Added the 'matcher' feature to DragonDocs
Fixed an issue in which a closed section would retain it's original height within the document navigation
Added starters and the lesson review to the navigation on the side