Creating a Database in the Model

You can create a database from the General tab of the model property sheet or, if your DBMS supports multiple databases in a single model, from the list of databases in the Model menu.

Context

Creating a database in your model allows you to specify physical options for it and to reference the database in the physical options of other objects. For example, you can specify that a table is created in a particular tablespace with the in [<db>.<tablespace>] physical option:

1. Select  Model  Model Properties  or right-click the diagram background and select Properties.
2. Click the Create tool to the right of the Database field and click Yes in the confirmation dialog to open the database property sheet.
3. Enter the following properties for the database as appropriate:

   Property	Description
   Name/Code/Comment	Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.
   Stereotype	Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file.
   DBMS	DBMS for the database
   Keywords	Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.

   The following tabs are also available:

   • Physical Options/Physical Options (Common) - Specifies the physical options associated with the database (see Physical Options (PDM)).
   • Script - Specifies begin and end scripts to bookend the database creation script (see Customizing Creation Statements).
   • Rules - Specifies the business rules associated with the database (see Business Rules (CDM/LDM/PDM)).
   • Dependencies - Lists the objects that reference the database in their physical options.