Background documentationDemo Database Locate this document in the navigation structure

 

DEMODB is a database developed for demonstration purposes. It is used in the documentation to illustrate procedures and commands using examples.

Main Properties of the Demo Database

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:

Process

You can use Database Studio, Database Manager CLI, or Installation Manager to create the DEMODB database and load all demo data.

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.

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 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.

End of the caution.