HOPEX Information Architecture > IA Physical Layer > Database and Physical Modeling
Database and Physical Modeling
 
Database
Creating Databases
Database Properties
Associating a Package with a Database
Importing a DBMS Version
Relational Diagram
Creating the Relational Diagram
Physical Modeling
Database Tables
Table Columns
Modifying Keys and Indexes
Creating a Key
Creating an Index
Adding a Column to a Key or Index
Specifying Primary and Foreign Keys
Specifying Primary Keys
Specifying Foreign Keys
Column Primary Key of Two Tables
Column Primary Key of Three Tables
Database Modeling Rules
The data model enables representation of the static structure of data at business level. A database is the object that enables storage and organization of data for use by programs corresponding to distinct applications, to facilitate the independent evolution of the data and the application programs.
You can connect a data model and associated diagram to a database. You can then create the corresponding relational diagram.