Demo Database 
DEMODB is a database developed for demonstration purposes. It is used in the documentation to illustrate procedures and commands using examples.
Property |
Default Values |
|---|---|
Database name |
DEMODB |
Name or password of the database system administrator |
DBADMIN/SECRET |
Name or password of a database user (with the rights of a database administrator) |
MONA/RED |
Schema |
HOTEL |
Tables |
CITY, CUSTOMER, HOTEL, ROOM, RESERVATION, EMPLOYEE More information: |
If you want to use the demo database DEMODB to work through examples yourself, first create a demo database and then load the demo data into it.
The demo data is used in the following tutorials:
Database Manager CLI Tutorial (complete data record)
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 all demo data.
Database Studio, Creating Databases
Specify the database property Load tutorial data to load all the demo data.
Database Manager CLI Tutorial, Creating/Configuring a Database
You then load the demo data into the new database (see Loading Demo Data in a Database).
Installation Manual, For more information, see Glossary, Installation Manager
You can also load all demo data into an existing database at a later stage if you do not load all data when you create the database. You can use Database Studio or Database Manager CLI to load all demo data.
Database Studio, Loading Demo Data
Database Manager CLI, load_tutorial
A simplified demo data set is enough to work through the examples in the SQL Tutorial. For this reason, do not load all the demo data, but follow the procedure described in SQL Tutorial, Demo Data for the SQL Tutorial.
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.