Chapter 3 Building Conceptual Data Models

Setting standard parameters for objects in a CDM

Standard parameters indicate common data constraints. The following table lists standard parameters:

Parameter Description
Minimum Lowest acceptable numeric value
Maximum Highest acceptable numeric value
Default Value assigned in absence of an expressly entered value
Unit Standard measure
Format Data format (for example, 9999.99)
Lowercase Forces all alphabetical characters to lowercase
Uppercase Forces all alphabetical characters to uppercase
Cannot Modify Protects from changes, results in a non-modifiable column in the physical data table
List of Values Authorized values
Label String that identifies an authorized value in the list

Steps To set standard parameters for objects in a CDM:

  1. Open the property sheet of a domain or entity attribute, and click the Standard Checks tab:
  2. Enter the appropriate standard parameters, and then click OK.

 

Copyright (C) 2007. Sybase Inc. All rights reserved.