Suppose the identifiers of Division, Department, Employee, are division Name, department Name, employee No, respectively. Other attributes of interest are division Location, department Budget,...

Suppose the identifiers of Division, Department, Employee, are division Name, department Name, employee No, respectively. Other attributes of interest are division Location, department Budget, employee Name, and employee Salary. Assuming plausible enterprise rules, and ignoring possible complications (e.g. employees who work for divisions but not departments), draw a determinancy diagram and derive a set of fully-normalised tables. Compare your answer with the structure shown in Fig. 11.3a.