Choose Oracle data types for the attributes in the normalized relations that you created in Problem and Exercise 19 in Chapter 4. Exercise 19 in Chapter 4 Figure 4-35 includes an EER diagram for a...

Choose Oracle data types for the attributes in the normalized relations that you created in Problem and Exercise 19 in Chapter 4.

Exercise 19 in Chapter 4

Figure 4-35 includes an EER diagram for a medium-size software vendor. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.