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:
In the figure below, the database schema that was drew using "MySQL Workbench":
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):