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

1. Start DB Visual ARCHITECT by selecting Start > Visual Paradigm > DB Visual ARCHITECT from the start menu.
   
2. Select the workspace and press OK.
   
3. To create an ERD, select File > New Diagram > Database Modeling > Entity Relationship Diagram from the main menu.
   
4. Enter Physical Database Design as the name of diagram.
   
5. Select entity from the toolbar to create an entity.
   
6. Drag to draw entity with specific size.
   
7. Enter Customer as the name of entity.
8. To add column to the entity, right click on the entity and select New Column from the pop-up menu.
   
9. Enter customer_id as the name of column.
10. To specify the column as primary key, right click on the column and select Include in primary key from the pop-up menu.
    
11. Move the mouse cursor over the entity, press on the One-to-Many Relationship -> Entity relationship icon.
    
12. Drag out to an empty space to create an entity.
    
13. 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.
    
14. Select the Columns tab, and click Add....
    
15. Enter the column information and click OK to confirm.
    
16. You also can specify the column as primary key by selecting the Primary Key property.
    
17. Click OK.
    
18. Column is added.
    
19. Let's repeat the previous steps to complete the ERD.
    
20. Let's configure the database configuration. Select Tools > Object-Relational Mapping (ORM) > Database Configuration... from the main menu.
    
21. Select Oracle from the database list.
    
22. Click ... to specify the Oracle JDBC jar file location.
    
23. 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)
24. Fill in the information of the database to reverse, and click Test Connection to verify the connection. Click Next.
    
25. Now it's time to generate database. Select Tools > Object-Relational Mapping (ORM) > Generate Database... from the main menu.
    
26. In the Database Code Generation dialog box, customize the database generation .
    
27. By default, Export to database is unchecked, check it to export the entities to the database.
    
28. Press OK to start the generate process.
    
29. 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