Physical data design
The physical design translate the logical data model for
target Relational Database Management System (RDBMS) to produce a relational
database. After selecting the RDBMS on which the relational database will be
implemented, the main step in logical design is the definition of different
relations using the Data Base Definition Language (DBDL). A relational database
is principally the collections of tables, each of which has a primary key, and
in which the tables are related to each other by the placement of the primary
key from one table into the related table as a foreign key. (Dennis et al.,
2012). As the DBDL is more related to the implementation of database relations
in the RDMS, we will not illustrate the Structured Query Language (SQL)
definition of each relation in PostgreSQL since the main objective of the DBML
is to implement the entity in the RDMS.
| 
