Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2. […]
Tag: integrity constraints.
Analyze and document the functional dependencies in each relation identified in 4-63 above. If any relation is not in 3NF, decompose it into 3NF, using the steps described in this chapter. Revise your relational schema accordingly.
Databases 4-63. Map the EER diagram you developed in Chapter 3, 3-44, to a relational schema using the techniques described […]