2. Every manager must be also be an employee.
3. The total percentage of all appointments for an employee must be under 100%.
4. Whenever an employee is given a raise, the manager’s salary must be increased to be at least as much.
Problem 4.
Find all the candidate keys of the relation R.
(A,B) ;(B,C,H) ; (B,C,F)
Decompose the relation in the following normal forms (if it is not there already):
a) 3NF,
> Dependency preserving decomposition with lossless join.
\(F_{\min=}\left\{AB\rightarrow CH,A\rightarrow D,F\rightarrow G,BF\rightarrow H,BCH\rightarrow F,BCF\rightarrow AE\right\}\)