Splitting the database is good even if it is a single user system. The
backend usually sits on a server type machine and the frontend sits on the
user's machine. This is the model you want to implement if your database
becomes shared between two or more people. It also speeds up access to the
data.
If you are the only one using the database, then keeping it as one db is
okay for now.