Chapter 4: Mapping Object-Oriented Conceptual Models
to the Relational Data Model
Hollywood Enterprise
The EER and UML diagrams for the Hollywood Enterprise are introduced in Chapter 1 (Figure 1.16) and Chapter 2 (Figure 2.28), respectively. This curriculum example illustrates the relational representation of the Hollywood Enterprise. The relational mapping demonstrates the mapping approach that uses a separate table for each class in a class hierarchy. The application is implemented in Oracle and demonstrates basic schema definition, the use of views and stored procedures to check constraint violations, and the use of triggers to maintain constraints when data is updated in the database.