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.