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.
![INFO620 Enterprise Database Systems Assignments Image 1 INFO620 Enterprise Database Systems Assignments Image 1](https://www.assignmenthelp.net/webimg/yah/images/questions/info620-enterprise-database-systems-assignments-image-1.jpg)
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.
![INFO620 Enterprise Database Systems Assignments Image 2 INFO620 Enterprise Database Systems Assignments Image 2](https://www.assignmenthelp.net/webimg/yah/images/questions/info620-enterprise-database-systems-assignments-image-2.jpg)