Tuesday, June 11, 2013

How to create relational data model with Oracle SQL Developer Data Modeler


This tutorial shows how to create a relational data model by creating tables, adding columns to tables, defining relationships between tables, etc. 

Pre-requisite
1. JRE is installed.
2. Oracle SQL Developer Data Modeler is installed.

1. Create table.
    Make sure you are in relational tab > click table() icon > move the pointer to the white empty space.
data modeler relational tab

2. Enter table name in the General node
general table properties

3. Click the Columns node to add column.
    a) Click on the  button to add 1 column.
    b) then enter the column name.
    c) Click on the Logical radio button.
    d) Choose data type in the Type dropdown.
    d) If this column is a Primary Key, then check the PK checkbox.
    e) If this column is mandatory, then check the Mandatory checkbox.
table properties - columns node

repeat 1 - 3 to add more tables. 

4. Click on the Foreign Keys node to add foreign key
    a) Click on the  button to add 1 Foreign Key.
    b) Select referenced table from the Referenced Table dropdown.
    c) Select referenced column from the Column field.
table properties - foreign keys node

repeat step 4 to add more Foreign Keys or Foreign Key for other tables.

5. Click on the Unique Constraints node to add unique constraint
    a) Click on the  button to add 1 Unique Constraint.
    b) Choose any column at the Columns panel.
    c) select any move action with the arrows.
table properties - unique constraints node

repeat step 5 to add more Unique Constraints or Unique Constraints for other tables.

6. Click OK.


Done!!

23 comments:

  1. There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.


    Oracle Training Institutes in Chennai
    Oracle Training Chennai

    ReplyDelete
  2. It likewise helps gives you a comprehension of the utilization of the particular toolbox. ExcelR Data Science Courses

    ReplyDelete
  3. Flutter Programming is one of the most popular in the cross platforms industry. Offshore Flutter Development Service We build excellent flutter mobile app and also learn how to overcome performance issues. is the best choice for all startups to discuss and get their project quotation. We also enable many startups to do Proof of concept and help them to learn about business decisions.

    ReplyDelete
  4. Protection offices are using prescient information examination to gather this information and research it on a huge scale so they can even more constantly predict risk and make techniques that give property holders adequate inclusion with premiums that record for a wide range of perils. Data Analytics Courses

    ReplyDelete
  5. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.

    data science course

    ReplyDelete
  6. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data Science Course

    ReplyDelete
  7. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.

    Correlation vs Covariance

    ReplyDelete
  8. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  9. Actually I read it yesterday but I had some thoughts about it and today I wanted to read it again because it is very well written. off plan slough

    ReplyDelete
  10. It has fully emerged to crown Singapore's southern shores and undoubtedly placed her on the global map of residential landmarks. I still scored the more points than I ever have in a season for GS. I think you would be hard pressed to find somebody with the same consistency I have had over the years so I am happy with that. best places to invest in property

    ReplyDelete
  11. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  12. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression
    data science interview questions

    ReplyDelete
  13. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.

    Simple Linear Regression

    Correlation vs covariance

    KNN Algorithm

    Logistic Regression explained

    ReplyDelete
  14. Very nice blogs!!! i have to learning for lot of information for this sites…Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, data sciecne course in hyderabad

    ReplyDelete
  15. Python is an open source programming language, which is widely used in a number of application domains. unindent does not match any outer indentation level python

    ReplyDelete
  16. Very nice blogs!!! i have to learning for lot of information for this sites…Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, data scientist courses

    ReplyDelete
  17. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  18. I am looking for and I love to post a comment that "The content of your post is awesome" Great work! data science courses

    ReplyDelete
  19. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  20. very well explained .I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Simple Linear Regression
    Correlation vs covariance
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  21. very well explained. I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Logistic Regression explained
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm

    ReplyDelete

LinkWithin

Related Posts Plugin for WordPress, Blogger...