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 of the features provided. There are a variety of books available on the subject, which describe and define modeling best practice.
Feature overview
The Data Modeler supports a number of graphical models and a selection of text-based models. The graphical models are:
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....
