Agenda:
- Getting started with Oracle SQL developer Data modeler
- How to create relational data model
- How to add Sequence Generator to a table
- Handling M:N relationships
- How to create database view
- Export the data model to DDL
- Backup the modeling project
- Create New Data Dictionary
- Getting started with Oracle SQL developer Data modeler
- How to create relational data model
- How to add Sequence Generator to a table
- Handling M:N relationships
- How to create database view
- Export the data model to DDL
- Backup the modeling project
- Create New Data Dictionary
This tutorial shows how to create a relational data model by creating tables, adding columns to tables, defining relationships between tables, etc.
1. Create table.Make sure you are in relational tab > click table(