Certificate of Achievement
has completed the following course:
Bespoke Inventory Systems: Design & Build for Small Businesses
This online course explored how an inventory can be organised in a way that it can grow with a business. It introduced data as a concept and explored how it can be managed by a computer, with a focus on finding and visualising the relationships between data in an inventory. The course culminated in building a database using SQL.
4 weeks, 4 hours per week
Dr Tomos Fearn
Lecturer in Computer Science
Aberystwyth University
Transcript
Learning outcomes
- Identify advantages and disadvantages of software driven inventory management systems.
- Explain the different types of relational and non-relational databases and the types of data that can be stored and queried within them.
- Identify redundant data within databases and remodel the structure to conform with 1st, 2nd and 3rd Normal Forms.
- Identify relationships between data within our database to present them as Entity Relationship (ER) diagrams.
- Explain what the Structured Query Language is and generate code to create tables, insert and update records, and generate queries from existing data.
Syllabus
*What is data and how should it be recorded *How to find relationships between data *Visualising relationships between data (creating Entity Relationship Diagrams) *Relational Data Management – building blocks *Relational Data Management – querying data.
In association with
Issued on 6th October 2026
The person named on this certificate has completed the activities in the transcript above. For more information about Certificates of Achievement and the effort required to become eligible, visit futurelearn.com/proof-of-learning/certificate-of-achievement.
This certificate represents proof of learning. It is not a formal qualification, degree, or part of a degree.