3NF DATA MODELLING(BILL INMON)
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 Bill Inmon's 3NF Data Modelling approach build?
2. Which four characteristics describe the Inmon Enterprise Data Warehouse?
3. What does a 3NF Enterprise Data Warehouse prioritise over direct query performance?
4. How is Customer data from a CRM system and from a Core Banking system handled in an Inmon-style EDW?
5. How are business intelligence queries typically served in the Inmon architecture?
6. What metaphor describes the relationship between the Inmon EDW and downstream data marts?
7. In the Inmon-style loan approval EDW, which table has OfficerID and BranchID where BranchID is a foreign key?
8. In the 3NF loan approval EDW, what does one row of the Approval table represent?
9. Which of the following is NOT listed as a trade-off of 3NF Data Modelling in an EDW?
10. How does Inmon's philosophy contrast with Kimball's approach?