Qt directly supports a local storage API which can be accessed via QtQuick.LocalStorage however we're going to construct our database functionality using C++ as that gives us more flexibility.
Database design
Before we start writing any code we need to consider what information should be in the database and