Physical Data Model
The Physical data model, is a low level data model, which provides all details about the entities (Tables), their attributes/properties (Columns), the size and type of each of the attributes (Data Types / Length of the Columns)
The Conceptual and Logical data models are fixed irrespective of
the database used, since they define entities/attributes at a high level,
however when it comes to the physical data model, it will vary based on the
target database since the data types are not consistent across all the
databases.
This model is built at the later stages of the design phase where
all details with respect to the entities and attributes are clear, this will be
the final data model based on which the development phase will progress.
No comments:
Post a Comment