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.