One will not need all the FKs spider webbing the data model. The reference table may still exist ... Retaining an infinitude of Foreign Keys may cause future performance bottlenecks as transactional ...

Because of this, that final DDL script can be viewed as the actual physical model. Shortcomings are natural, as the diagram is called an “entity-relationship diagram,” not a “table-foreign key diagram ...