A data model that consists of a single fact table linked to important concepts of the
business is a:
Examples of the ‘Who’ entity category include: employee; patient; player; and suspect.
In designing and building the database, the DBA should keep the following design principles in mind:
Snowflaking is the term given to normalizing the flat, single-table, dimensional structure in a star schema into the respective component hierarchical or network structures.
Decentralized informality can be made more formal through a documented series of connections and accountabilities via a RACI matrix.