Home > Data Modeler Tutorial: Mode... > Develop the Relational Model
The relational model for the library tutorial database consists of tables that reflect the entities of the logical model (Books, Patrons, and Transactions) and all attributes of each entity. In the simplified data model for this tutorial, a single relational model reflects the entire logical model; however, for other data models you can create one or more relational models, each reflecting all or a subset of the logical model. (To have a relational model reflect a subset of the logical model, use the "filter" feature in the dialog box for engineering a relational model.)
Develop the relational model as follows:
With the logical model selected, click Design, then Engineer to Relational Model. The Engineering dialog box is displayed.
Accept all defaults (do not filter), and click Engineer. This causes the Relational_1 model to be populated with tables and other objects that reflect the logical model.
Expand the Relational Models node in the object browser on the left side of the window, and expand Relational_1 and optionally nodes under it that contain any entries (such as Tables and Columns), to view the objects created.
Change the name of the relational model from Relational_1 to something more meaningful for diagram displays, such as Library (relational). Specifically, right-click Relational_1 in the hierarchy display, select Properties, in the General pane of the Model Properties - <name> (Relational) dialog box specify Name as Library (relational)
, and click OK.
Go to Generate DDL.
Related Topics