Creating an SQL logical model

Introduction

The logical model (or table model) is a relational model of SQL tables.

Since the SQL Designer module supports four variations of SQL grammar (SQL92, ORACLE11G, MYSQL, SQLServer 2008 and Firebird), there are therefore four types of logical model, one per type of grammar supported.

Creating an SQL logical model

The SQL Designer module provides a set of commands used to create a model of SQL tables in preparation for the generation of SQL script files.

Command Available on Result
Database SQL92
DataBase ORACLE11G
DataBase MYSQL
DataBase SQLServer
DataBase Firebird
UML package Creates the root of the SQL table model.
Table DataBase Creates a table.
Field primary key Table Creates a primary key for a table.
Field Table Creates an attribute for a table.
Field foreign key Table Creates a foreign key by specifying a primary key of another table.
Field foreign primary key Table Creates an attribute which is the primary key of a table and the foreign key of another.
Foreign key Table Creates a foreign key directed to another table.
Foreign key primary key Table Creates a foreign key directed to another table. However, this attribute is also the primary key of the table.