Filters

Other

S3 ComputingDatabases Assignment

Knox badge

Abstract

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:

Products

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.

Orders

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 --

20.08.2017

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

21.08.2017
Added CSS styles to page
Added JavaScript code to the page

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

08.02.2018
Added the Accessibility features
Filters added

10.02.2018
Purple filter added

17.03.2018
Added the Note class
Added the Did You Know class

-- DragonDocs version 1.0 (Yosemite) --

02.10.2019
First trial of DragonDocs in teaching

04.10.2019
Added the Task, Starter, Review your learning sections

07.10.2019
Added the feedback feature
Added the Dark Mode toggle

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

31.09.2021
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

02.02.2022
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

06.02.2022
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

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

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

-- DragonDocs version 2.0 (Kilimanjaro) --

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

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

-- DragonDocs version 2.1 (Aurora) --

08.02.2024
Added the active class to active links in the bottom section

09.02.2024
Added the image upload feature

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

11.02.2024
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

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

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

23.02.2024
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

25.02.2024
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