• Nick,

    You forget a key problem with the OTLT (One True Lookup Table), what dcpeterson calls a "MUCK" table -- It very clearly violates the First Normal Form, destroying all data integrity. RI is not the only means of enforcing integrity in an RDBMS. Domain integrity is just as important.

    --
    Adam Machanic
    whoisactive