Demo Database 
DEMODB is a database developed for demonstration purposes. It is used in the documentation to illustrate procedures, commands and the like 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 administator) |
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, you must first create the demo database and then load the demo data into it. We recommend that you use the Installation Manager for this.
Process
You can use the Installation Manager, the Database Studio, or the Database Manager to create the DEMODB database and load all demo data.
Installation Manual, Creating the Demo Database DEMODB
On the Database Configuration screen for the Installation Manager, select the Load Tutorial Data option to load the complete data for the demo.
Database Studio, Creating the Database
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).
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 the Database Studio or the Database Manager 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 instance in a production system.
Example
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)