Using the VRG database as an example, briefly describe what a ...

[shofmannx20]

Using the VRG database as an example, briefly describe what a final database design consists of.
 
  What will be an ideal response?

Question 2

MySQL supports BEFORE triggers.
 
  Indicate whether the statement is true or false

[1_Step_At_ATime]

Answer to Question 1

The obvious part of the database design is the ER drawing itself, for example as shown for VRG in Figure 6-39. However, this needs to be accompanied by a summary of the database design relationships as shown in Figure 6-40. This document summarizes the cardinalities of relationships. For each relationship, we need a set of actions to enforce the minimum cardinalities. These can be based on Figures 6-28(a) and 6-28(b), the examples for VRG are shown in Figures 6-41 and 6-42. Finally, we need a set of column characteristics for each table, as shown in Figure 6-43 for VRG.

Answer to Question 2

TRUE