Physical Data Modelling (PDM)
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What does Physical Data Modelling define?
2. How does the physical model differ in nature from conceptual and logical models?
3. In the physical loan model, which column type is suggested for financial amounts?
4. Why are decision status and repayment status defined as enumerated types in the physical model?
5. How is the one-to-one relationship between a loan and its approval decision enforced at the physical layer?
6. Which partitioning strategy is given as an example for the loan and repayment tables?
7. What is the purpose of a partial index in the physical model example?
8. Which of the following is NOT named as an operational consideration in Physical Data Modelling?
9. Which three questions do the Conceptual, Logical and Physical layers respectively answer?
10. What is described as the essential bridge to understand before moving from core to specialised modelling techniques?