Oracle Database Design with Entity Relationship Diagram

In Visual Paradigm, create a new project by selecting File > New Project from the main menu. Name the project ComputerSales.
Create an ERD by selecting 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 diagram to create an entity. 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 pointer over the entity, press on the One-to-Many Relationship -> Entity relationship icon.
Drag out to an empty space to create an entity named Addresses.
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 > Database > 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
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 > Database > 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.