Data modeling and Relational database design

Download the SQL data modeler, review the Oracle Technology Network license agreement, and launch the application to start modeling logical and relational structures for the Oracle database.

Understand why data modeling and database design are essential, with a clear plan that stakeholders can review and changes made at the planning stage to avoid costly post-implementation revisions.

Explore data modelling as a blueprint for application and database design, covering data objects, attributes, relationships, business constraints, data flow diagrams, ER diagrams, and the scripting to build the database.

Explore the Oracle SQL Data Modeler interface to build a data flow diagram and process model, then convert the logical model to a relational model and back for design flexibility.

Explore the data flow diagram as a process model that communicates complex processes to business users, documents project boundaries, and highlights missed functionality for validation and testing.

Create and analyze a data flow diagram showing an external agent, a process, information flow, and information stored to model payroll from time sheet to paycheck.

Explore how to define events tied to processes in both primitive and composite data flow diagrams, create time sheets, and navigate data modeling tools and preferences.

Learn to build a data flow diagram by decomposing a composite sales process into lower level data flows, identifying external agents and the information flow from order to shipment.

Map business requirements to a data flow diagram within a process model, identify external agents and data stores, and trace orders from entry to shipping toward a relational model.

Discover how a logical data model, via entity relationship diagrams, captures entities like customers and orders and defines one-to-many relationships.

Learn to map entities, attributes, and relationships in an entity relationship diagram, identify primary keys, and illustrate one-to-one, one-to-many, many-to-one, and many-to-many cardinalities with examples: customers, orders, and products.

Explore recursive relationships in a data model with ER diagrams, using employee and manager as an example, and learn to define entities, attributes, and key relationships in the logical model.

Build a logical model and ERD by creating customer and order entities, defining primary keys and attributes, and linking orders to customers through a relational key.

Demonstrates building a simple ERD for a customer and order in a 1-to-many relationship, wiring primary and foreign keys, and visualizing attributes and cardinalities.

Master modeling complex relational data with sub views in SQL modeler, organizing order, customer, and item across multiple tables into modular entities.

Explore relational database design by mapping entities to tables, converting attributes to columns, and using primary and foreign keys; learn normalization to minimize redundancy and avoid anomalies.

Explore the first, second, and third normal forms and how each form ensures attributes depend on the primary key, reducing repetition in relational design.

Explore the second normal form by ensuring all non-key columns depend on the primary key, avoiding partial dependencies, with a practical customer and order example.

Explore how the third normal form extends the second, ensuring every non-key attribute depends only on the primary key, illustrated by separating order headers and order lines.

Convert a normalized entity relationship diagram into a relational model using a SQL modeler, mapping entities to tables with primary and foreign keys, and generating creation scripts.

Learn how to derive a relational model from a logical model, generate DDL scripts for tables and constraints, and execute them in Oracle database or Oracle's cloud SQL playground.

Import a relational database model into the data modeler by connecting to a database, selecting schemas and tables, and generating creation scripts with relationship analysis.

Explore how business information drives data modeling by capturing notes and inputs from stakeholders, mapping to relational tables with keys and indexes, and connecting process, logical, and multidimensional models.

Validate the logical and relational data models by applying design rules for normalization and integrity. Identify entities, attributes, and relationships, and ensure every table has a primary key.

Discover two features in SQL data modeller: the mighty gemstone model for online analytical processing and data warehouses from ERP and transactional data, including fact tables and dimensions.

Explore cloud-based data modeling on Oracle Cloud Infrastructure, using the web-based data modeler to reverse engineer schemas and generate relational diagrams, reports, and DDL for autonomous databases.

Design a car rental database from an entity-relationship diagram to a model by generating and executing SQL scripts for cars, makes, models, options, insurance policies, insurance companies, customers, and transactions.

Create a logical data model with entities car and model, define primary keys and mandatory attributes, and establish a one-to-one relationship to prepare the entity relationship diagram for SQL.

Continue building the entity relationship diagram for a car case, forming a logical ER model with primary and foreign keys using Beckman notation, then generate the physical model.

Generate the relational model from a logical entity design, convert entities to tables, and use the DDL editor to generate and execute SQL scripts that create physical database and constraints.

Execute DDL SQL scripts to create tables, indexes, and constraints in a physical database. Use SQL developer or SQL plus to connect and run the scripts, producing a physical model.

Execute a full DDL script in Oracle SQL Developer to create physical tables, constraints, and relationships from an entity relationship diagram, then populate data and validate joins.

Model relational databases with primary and foreign keys across car, model, option, and insurance tables, and retrieve car registration, insurance company name, and policy through a three-table join.