QuizFaber Database - Introduction
It is known that a database can contain a large amount of information that can be centralized or resident in one place (instead of many copies on each PC, perhaps not identical to each other) and accessible to all persons authorized to access it.
For this purpose, QuizFaber has provided access to the most common relational databases, so that their quizzes can be stored in a single and centralized environment and, if necessary, downloaded and copied to QuizFaber for editing or creating the quiz. in HTML.
The currently supported relational databases are:
- MySQL
- MariaDB
- PostgresSQL
- Microsoft SQL Server
- Oracle
A database instance, named "quizfaber" must be created in the database that has a table structure (schema) designed for QuizFaber.
The schema (designed for MySQL using the MySQL Workbench tool) is the following:
Here the link of QuizFaber database schema : DB_QF_Schema.MySQL.mwb
To create a new database instance, you must of course be the administrator of that database (in MySQL, have the "root" user)
and then launch the SQL script for create the tables used by QuizFaber.
These scripts are supplied with the program, one for each type of database. They are:
- DB_QF_CreateTables.MySQL.sql, for MySQL / MariaDB
- DB_QF_CreateTables.PostgreSQL.sql, for PostgresSQL
- DB_QF_CreateTables.SqlServer.sql, for Microsoft SQL Server
- DB_QF_CreateTables.Oracle.sql, for Oracle