Introduction

QuizFaber uses the relational database in order to store all the text of questions and answers of the quiz in a central repository that can be accessed from many places and from many people that have the credentials.
 
At the moment, the relational databases supported by QuizFaber are:

·     MySQL
·     MariaDB
·     Microsoft Access
·     Microsoft SQL Server
·     Oracle

The first difference is between "local database" and "remote database". Microsoft Access is an example of first case; all other databases are remote because they can accessed only with a internet address (that could be the address of the same machine).

The first step is install a instance (or "schema") of the QuizFaber database. This operation should be done manually, because it is quite technical. The SQL scripts that create all the QuizFaber tables database, are distribuited with this software, one for each type of database, and they are:

            DB_QF_CreateTables.MySQL.sql                  for MySQL / MariaDB 
          DB_QF_CreateTables.SqlServer.sql ,         for Microsoft SQL Server
          DB_QF_CreateTables.Oracle.sql ,             for Oracle

In the figure below, the database schema that was drew using "MySQL Workbench":

graphic

In the case of Microsoft Access database, there is only the MDB file, in QuizFaber called "QuizFaberDatabase.mdb" (placed into the installation folder), that contains the structure of all the tables.
Below the relationships diagram as you can see opening the MDB file with Microsoft Access (a software that belong to the Microsoft Office suite):

graphic