In the Microsoft SQL Server AdventureWorks sample database, the business object Employee is represented by seven individual tables: Employee, Employee Address, Employee Department History, Employee Pay History, Sales Person, Sales Person Quota History and Sales Territory History.

With no human input, Sentences has detected the common primary keys, automatically built the associative schema seen on the left and aggregated the seven tables into a single business object.

 

It has automatically built the dataform which allows all of an employee's data to be accessed in a single form, with tabs for each of the subordinate tables.

Also, all of the Employee's inward associations - the customers and staff for whom they are responsible, the orders they have taken and so on - are immediately visible in the Sentences Explorer data pane.

 

 
           
 
 
  Copyright © 2011 - 2015 Lazysoft Ltd.  All Rights Reserved.