Question : Introduction In order for this question to be useful for future readers I will use the generic data […]
Tag: subtypes
Category entity relationship / subtype relationships design
Question : I am looking to implement a generic comment and file attachment facility within a web application which would […]
What is the correct way to enforce unique “IS-A” relationship?
Question : Let’s say we have a Person relation, and with that Employee which IS-A Person, Manager, which ISA Person […]
Inserting into subtype table values from supertype table in oracle
Question : I had created two object types and tables based on that types in oracle: create or replace type […]
Is my implementation of type/subtype design pattern (for mutually exclusive subclasses) correct?
Question : Introduction In order for this question to be useful for future readers I will use the generic data […]
How to enforce data consistency across one-to-one relationship in an inheritance hierarchy
Question : Consider this design for a typical school database: Person: —————– FirstName LastName SocialSecurityNumber Phone Email Student: —————– Grade […]
Is my implementation of type/subtype design pattern (for mutually exclusive subclasses) correct?
Question : Introduction In order for this question to be useful for future readers I will use the generic data […]
Some users can have a fixed amount of additional fields, EAV or not?
Question : Say I have to store data about two different types of person roles or occupations, i.e., Consumers and […]
Using the same table for entities that are almost alike when it breaks foreign key integrity?
Question : I’m designing a website with a database that should support events that a user can sign up for, […]
Insert into table with polymorphic association in database
Question : I want to design a database where some tables have multiple foreign keys. I am looking for the […]