4-28. For each of the following E-R diagrams from Chapter 2:
Transform the diagr
4-28. For each of the following E-R diagrams from Chapter 2:
Transform the diagram to a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).
For each relation, diagram the functional dependencies (see Figure 4-23 for an example).
If any of the relations are not in 3NF, transform them to 3NF.
Figure 2-8
Figure 2-9b
Figure 2-11a
Figure 2-11b
Figure 2-15a (relationship version)
Figure 2-15b (attribute version)
Figure 2-16b
Figure 2-19
4-29. For each of the following EER diagrams from Chapter 3:
Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).
For each relation, diagram the functional dependencies (see Figure 4-23 for an example).
If any of the relations are not in 3NF, transform them to 3NF.
Figure 3-6b
Figure 3-7a
Figure 3-9
Figure 3-10
Figure 3-11
Leave a Reply