Implementing Your Design with SQL

You can choose to implement your design using SQL statements.

SQL terminology

The following table relates the terms used during the physical design process with those used in an SQL implementation.

Logical/Physical Design Term	SQL Implementation Term
Entity	Table
Entity occurrence	Row
Data element	Column
CALC location mode	CALC
Clustered location mode	Clustered constraint
Relationship	Constraint
Index	Index
Unique	Unique
Parent	Referenced table
Child	Referencing table