Adjective Phrasing Dialog Box

Use this dialog box to specify adjective phrasing for a relationship.

When a relationship between entities is expressed with an adjective, use adjective phrasing to define the relationship. The adjective can be:

• A single word not represented by a field.
  
  
• Part of a database object that represents an entity.
  
  
• A measurement.

Options

Subject

Select an entity that represents the subject of the relationship.

Adjective type

Select the adjective type.

Single adjective

Select if the adjective is a word not represented by an entity. Then enter the word in the Adjective that describes subject box.

Entity contains adjectives

Select if the adjective is contained in a field. Then enter the entity in the Entity that contains adjective box.

Measurement

Select if the adjective is a measurement of some kind, such as tall, fast, or heavy. Then enter the entity that contains it in the Entity that contains the measurement box.

Adjective that describes subject

Enter an adjective that describes the subject entity in the relationship. This word or words is not represented by an entity. Available only if you click Single Adjective. Entity that contains adjectives

Select an entity, which represents a table or field, containing the adjectives in the relationship.

Available only if you click Entity contains Adjectives.

Associate English Values

Display the English Data Values dialog box, where you specify English data values.

Available only if you click Entity contains adjectives.

Entity that contains the measurement

Select an entity containing the measurement for the relationship.

Available only when you click Measurement.

Adjectives associated with higher values (Use root form)

Enter adjectives that describe the high value ranges in their root form. For example, in the question, "List the old salespeople," old is the adjective associated with a higher value.

Numeric threshold for high values

Specify the highest value to use when users ask questions involving absolute, but subjective, measurements. For example, the question, "List the old salespeople," requires specifying what age is considered old. Only numeric values can be specified. If a threshold is not specified, English Query prompts the user for the information when the question is asked.

Use lower value words as the default

Select to define the lower values as the default in the restatement of the question.

For example, identify whether the lower value (for example, young) should be seen as the top, or higher value. The use of the lower value in this example allows questions such as "Show the people and their ages" to be restated as "Show the people and how young they are." This restatement is not as likely as the idiom, "how old they are."

Adjectives associated with lower values (Use root form)

Enter adjectives that describe the lower values in their root form, for example, young.

Numeric threshold for low values

Specify the lowest value to use when users ask questions involving absolute, but subjective, measurements. For example, the question "List the young salespeople" requires you to specify what age is considered young. Only numeric values can be specified. If a threshold is not specified, English Query prompts the user for the information when the question is asked.

Add prepositional phrase

Enter the preposition and select an object from the Object of preposition list to further describe the relationship.

See Also

Adjective Phrasings in Relationships