
Qualification 3 (restricting the foreign key reference to female patients) can be
implemented by using the Database Properties dialog to add appropriate triggers to the
Patient and PapSmear tables.
Mapping Subtypes to Separate Tables
To summarize our earlier discussion, the ORM schema in Figure 7–31 maps to the log-
ical schema shown in Figure 7–34, if we use the default mapping procedure, where sub-
types roles that are functional (with a simple uniqueness constraint) are effectively
absorbed back to the supertype before mapping. The prostate and pregnancy fact types
are functionally dependent on their subtype, so are absorbed into the supertype table ...