Export (0) Print
Expand All

How to create relationships from the Model Test Window

SQL Server 2000

When testing a model if a question cannot be understood or is answered incorrectly, English Query can suggest and create possible relationships.

To create relationships from the Model Test window

  1. Create a model and double-click it in the Project Explorer window.

  2. From the Debug menu, click Start.

  3. Enter a question and click .

  4. When there is a question cannot be understood or is answered incorrectly, click .

  5. Select the entities and identifying information, and the relationships that create the appropriate phrasing for the question.

  6. Click OK.

  7. Retest the question.

  8. If the question continues to be answered incorrectly or cannot be understood, repeat Steps 4 through 7.

  9. If the question continues to be answered incorrectly or cannot be understood, create a relationship using one of the other methods, or modify an existing relationship.

  10. Repeat Steps 3 through 9 as needed until the model answers the question appropriately.

See Also

How to add a relationship

How to add a relationship using the Canvas pane

How to create relationships using the Create Relationships command

How to modify a relationship

How to test a model

Model Test Window

Show:
© 2014 Microsoft