RAD Studio 10.4.1 is now available! Learn more. Looking for discounts? Visit our Special Offers page!
News

Logical to Physical Data Modeling

Author: Cosmin G6814

In the last article we learned how to create a data model from scratch using ER/Studio Data Architect. In part II we will explore about how to convert a Logical Data Model into a Physical Data Model.

 

Section 1: Generating a Physical Data Model

Task 1

1) Launch ER/Studio Data Architect

2) Open the last created model

3) We shall now be generating a Physical Model to an actual Database Schema to 
InterBase – An Award winning Embedded Database Solution from Embarcadero Technologies

For more details visit: http://www.embarcadero.com/products/interbase

Section 2: Generating the Database Platform SQL — Interbase

1) Click on the Model Menu — Choose Generate Physical Data Model

3e61b31-3771204

 2) You will get a warning now asking if you would like to proceed, Click Yes

1eea330-6501215

3) You will now be presented with the Physical Data Model Generation Screen

274f824-5653312

 In the above screen, you can give your Physical Data Model a name, The type of model, Relational in this case. When it comes to the Target Database Platform, we will be choosing InterBase XE3 as an example. We can leave the other settings as a default.In the next screen, you are presented with a list of options, that indicate which entities will be generated. Leave the defaults and just click Finish to generate the Physical Data Model

062be11-7117105

Final Section: Viewing the Physical Data Model SQL

In this final section, we view the generated SQL for our InterBase Database

Now as you can see on the left hand side a green icon — IBPDM (InterBase Physical Data Model) — This indicates that it is a Physical Data model

  • Expand the Tables Section and double click on the Dept table
  • You should be able to see the SQL Generated for our InterBase Database

    2b7b6c6-6699754

  • You may now connect to your InterBase Database and run this SQL in the IBConsole SQL Editor

 

283f208-7057453

Finally, Congratulations! You have successfully converted a Logical Data Model to a Physical Data Model in ER/Studio Data Architect.

Stay tuned for more topics in the series.

Please feel free to reach out to me for any questions or visit our website for more information at:

Contact Us Today for a 1 on 1 Personalized Demo!

You may contact us here


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

Related posts
C++

What's New in the GetIt Package Manager - June 2020

C++

RAD Studio 10.4 Now Available, Learn More

C++NewsRAD Studio

Open for Business with 10.4! - May 2020 GM Update

C++DelphiNews

Embarcadero Open Source Project Sponsorship

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES