New answers tagged referential-integrity
When implementing subtypes of an entity there are various solutions on Oracle: Create one wide table with the attributes of all subentities. Entity type stored in a field and used to enforce business rules ("You may only fill column A for entity type B"). Create one master table with the shared attributes and per subentity another table. And relations back ...
Top 50 recent answers are included