Sample Models and Scripts

Sample Models and Scripts

With SQL Developer Data Modeler, you don't need to be connected to a database to create a design. You can start creating a new design from scratch open an exisiting design or import a DDL script to create a new model. Below are a set of models and DDL scripts based on the Oracle Sample Schema. Use these to get to know the Data Modeler.

SQL Developer Data Modeler 3.1 - Sample Data Models
  • HR data model- Download zip and extract files, open hr.dmd
  • SH data model- Download zip and extract files, open sh.dmd
  • OE data model- Download zip and extract files, open oe.dmd
  • PM data model- Download zip and extract files, open pm.dmd
  • Full sample schema- Download zip and extract files, open all_schemas.dmd (this includes an ERD, Multi-dimensional, Datatypes and Relational model)
SQL Developer Data Modeler 2.0 - Sample Data Models
SQL Developer Data Modeler 3.1 - Sample DDL Scripts
  • HR DDLScript - Import the HR sample
  • OE DDLScript - Import the OE sample
  • PM DDLScript - Import the PM sample
  • SH DDLScript - Import the SH sample
SQL Developer Data Modeler 2.0 - Sample DDL Scripts