Select Perspective

A logical data model is designed as part of the Data Architecture Delivery Phase of the Supply Workflow of the Select Perspective.  This model is derived from the Business Component Information Model (BCIM) as described in the Business-Data cell.  Additional detail is added to the UML Business Class attributes and the model is checked for 3rd normal form.

Select Business Solutions recommend that the BCIM created for projects be copied, collated and rationalized in the Enterprise model.

If project BCIM do not exist or are considered to be out-of-date, then it is recommended that one be created in the Enterprise.

Whichever way the Enterprise BCIM is created, the normalised E/R-type model may be created from it.

Select Solution Factory

If project logical data models exist in Select Architect (logical Table Relationship Diagrams) they may be copied into the Enterprise model using Select Model Copy then collated and rationalized.

If projects are using an ODBC compliant database, the data schema may be imported into SCA using the Select Database Schema Reverser (this may fulfil the requirements of the Technolgy-Data cell); the resulting model should then be normalised.

If required, the model resulting from either of the two techniques above may be converted to a BCIM with the aid of the  Select ORSync tool.

If BCIM exist for projects, use Select Model Copy to copy them to the Enterprise model then collate and rationalize them and, if required, produce the logical data model using Select ORSync.

If none of the above data model sources exist, Select Business Solutions recommends that the BCIM created for the Business-Data cell be enhanced and, if required, produce the logical data model using Select ORSync.

The following is an example of the E/R notation used in SCA Table Relationship diagrams: