Oracle SQL Developer Data Modeler

SQL Developer Data Modeler provides users with a lightweight tool, which provides application and database developers a quick and easy way of diagrammatically displaying their data structures, making changes, and submitting the new changes to update a schema. In this chapter, we will not attempt to teach data modeling except to provide some generally accepted definitions. Instead, we will discuss how the product supports data modeling and a few features that are provided. There are a variety of books available on this subject that describe and define best practice in data modeling.

Feature overview

Data Modeler supports a number of graphical models and a selection of text-based models. The graphical models are as follows:

• Logical: This is the entity relationship model or Entity Relationship Diagram (ERD) and comprises entities, attributes, and relationships.
• Relational: This is the schema or database model and is comprised of tables, columns, views, and constraints...