The logical information model builds on the conceptual records model. Normalization strategies which includes 3NF (the 0.33 normal shape) are applied. We ensure all relationships among entities are represented in our data version. This step is the important thing difference among the conceptual and the logical records models.
The physical information version is the final and the maximum distinct version of our statistics version.
https://app.erdlab.io In this step, we define all the tables in our software. We additionally define the relationships among tables, set their cardinality, transform entity attributes into columns, and pick out or define records kinds for every column. We ensure to set default values or constraints on column values, constraints between tables, and set collations.