Demo Database 
DEMODB is a database developed for demonstration purposes. It is used in the documentation to illustrate procedures and commands using examples.
Caution
This demo database was developed for practice and testing purposes and contains several predefined demo database users with standard passwords and demo data. Do not use the demo database in a production system.
Property |
Default Values |
|---|---|
Database name |
DEMODB |
Name/password of the database system administrator |
DBADMIN/SECRET |
Name/password of a database user (with the permissions of a database administrator) |
MONA/RED |
Schema |
HOTEL |
Tables |
CITY, CUSTOMER, HOTEL, ROOM, RESERVATION, EMPLOYEE More information: |
To use the demo database DEMODB, you first create a database and then load the demo data into it.
The demo data is used in the following tutorials:
Loader Tutorial (complete data record)
SQL Tutorial (simplified data record)
Process
You can use Database Studio, Database Manager CLI, or Installation Manager to create the DEMODB database and load the demo data.
More information:
Database Studio, Creating Databases
To load the demo data, select the Load tutorial data option.
Glossary, Installation Manager
You can also load the demo data into an existing database at a later stage using Database Studio or Database Manager CLI.
More information:
Database Studio, Loading Demo Data
Database Manager CLI, load_tutorial
The SQL Tutorial uses a simplified demo data set. If you want to work through the SQL Tutorial, do not load all the demo data, but follow the procedure described in SQL Tutorial, Demo Data for the SQL Tutorial.