Oracle database design with Entity Relationship Diagram

This tutorial shows you how to design Oracle database with Database Visual ARCHITECT. We will use ERD (entity relationship diagram) to design database and then generate database initialization script directly to Oracle database.
Topics
1.Create physical database design ERD
2.Draw entities and connecting relationships
3.Create columns and primary keys
4.Connect to oracle database through JDBC
5.Export database schema to Oracle database

September 1, 2009
User Rating: / 7
Views: 8098
PDF Link Link:	Add comments
Edition: All (Edition comparison)
Share \|

Start DB Visual ARCHITECT by selecting Start > Visual Paradigm > DB Visual ARCHITECT from the start menu.
Select the workspace and press OK.
To create an ERD, select File > New Diagram > Database Modeling > Entity Relationship Diagram from the main menu.
Enter Physical Database Design as the name of diagram.
Select entity from the toolbar to create an entity.
Drag to draw entity with specific size.
Enter Customer as the name of entity.
To add column to the entity, right click on the entity and select New Column from the pop-up menu.
Enter customer_id as the name of column.
To specify the column as primary key, right click on the column and select Include in primary key from the pop-up menu.
Move the mouse cursor over the entity, press on the One-to-Many Relationship -> Entity relationship icon.
Drag out to an empty space to create an entity.
You can also create column through the specification dialog. To open the specification dialog, right click the entity and select Open Specification... from the pop-up menu.
Select the Columns tab, and click Add....
Enter the column information and click OK to confirm.
You also can specify the column as primary key by selecting the Primary Key property.
Click OK.
Column is added.
Let's repeat the previous steps to complete the ERD.
Let's configure the database configuration. Select Tools > Object-Relational Mapping (ORM) > Database Configuration... from the main menu.
Select Oracle from the database list.
Click ... to specify the Oracle JDBC jar file location.
Select the Oracle JDBC driver file.

(PS. The JDBC driver file can be found at ${oracle_server_dir}\jdbc\lib, or downloaded from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html)
Fill in the information of the database to reverse, and click Test Connection to verify the connection. Click Next.
Now it's time to generate database. Select Tools > Object-Relational Mapping (ORM) > Generate Database... from the main menu.
In the Database Code Generation dialog box, customize the database generation .
By default, Export to database is unchecked, check it to export the entities to the database.
Press OK to start the generate process.
Let's check with the Oracle Web Object Browser to verify the generation.

Download full functions 30 days FREE trial of DB Visual ARCHITECT

Windows
Linux
Mac OSX

Notes:
1. Select DB Visual ARCHITECT when installing the VP Suite.
2. Click "Try without Evaluation Key" button to get 30 minutes per session evaluation.
3. Click "Request Key" to get a 30-day evaluation key by email (Your email will only be used for sending evaluation key and follow up your evaluation. We will NEVER share your email to third party without your approval).

Oracle is U.S. registered trademark of Oracle Corporation

Rate this article:

Comments (9)

thank you

written by osama sharaf on October 10, 2009

thank you for this effor but t want the soft ware of orecal to treaning on it
thank,s alot

Miss Samira Ragab Ali

written by samira on October 20, 2009

It is wonderful to find such program ...........thanks

Thank you

written by Angus on October 20, 2009

Thank you for your encouraging comment. We will keep hard working to enhance the DB-VA.

this is very interesting

written by moath on October 22, 2009

I want new viosion from this datatbase

Excellent Quick Tutorial

written by Eric O. Flores on March 01, 2010

I'm a student of Information Technology with CTU, I found this tutorial to be extremely quick and very accurate. I was able to create a database in a matter of minutes.

DETERMINISTIC SYSTEM

written by Amos on April 14, 2010

thank for your tuorial want oracle software please to train on it

Positive comment

written by ? on April 15, 2010

Thank you for all of your's positive comment. We will try our best to deliver better tool and tutorial.

Ms.

written by Sanja Zore' on July 14, 2010

This is a good tutorial.
I used the Oracle Designer 2000 tool to model a complex, normalized, relational DB, and I was very suttisfied with. Is it possible to download Oracle Designer for free?

good introduction

written by wyn on August 24, 2010

i would like to have more tutorial like this in the future. More samples will good. Step by step procedure helps beginners like me to cope up with the process.

Write comment