INFO620 Enterprise Database Systems – Assignments
CH 16: RELATIONAL DATABASE DESIGN ALGORITHMS and FURTHER DEPENDENCIES
#16.20 - Show that the relation schemas produced by Algorithm 16.6 are in 3NF.
Figure 16.6 states: Templates for the constraint that an employee’s salary must be less than the supervisor’s salary
#16.21 - Specify a template dependency for join dependencies.
#16.22 - Specify all the inclusion dependencies for the relational schema of Figure 3.5.