Model-Driven Data Design - Part 1 (e31 Updated)

In this session we are going to replace Building a Data Model in Sparx EA Part 1 and fix some mistakes I made in drawing connector directions between tables. We will build a Data Model in Sparx Enterprise Architect (EA). We start to do this at the beginning of any project, especially when engineering scope and requirements. We will step through creating a Data Base (tables) from scratch and then actually building the SQL that can be executed in the SQL Studio of choice. Chapters 0:00 - Intro 0:42 - Choosing Diagram Type 1:01 - Adding Tables 1:40 - Add source tables 2:13 - Add Columns to Tables 4:48 - Adding Connections 8:27 - Automation in building SQL 9:36 - Further Defining our Table Design 12:38 - Generate the DDL file 15:03 - Deploying our Tables 15:26 - Outro =-=-=-= UMLO Website =-=-=-= https://www.trackotc.com/ =-=-=-= UMLO Blog =-=-=-= https://umloperator.blogspot.com/ #umloperator