What question should a data modeler answer before accepting this proposed operational data structure?
Should all three tables be consolidated into one?
Should the cardinalities between the tables be reversed?
Are Branch and Employee dimension tables or fact tables?
Is there a direct relationship between Branch and Employee?