Multiple choice technology enterprise content management

What question should a data modeler answer before accepting this proposed operational data structure?

  1. Should all three tables be consolidated into one?

  2. Should the cardinalities between the tables be reversed?

  3. Are Branch and Employee dimension tables or fact tables?

  4. Is there a direct relationship between Branch and Employee?
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Before accepting a proposed operational data structure with transitive paths, a modeler must determine whether a direct relationship exists between the tables (such as Branch and Employee), as this determines whether the intermediate join paths accurately represent real-world associations.

Keep practicing — related questions