Any resources for common data model design patterns? -

Any resources for common data model design patterns? -

i'm looking resource shows mutual design patterns or best practices info models. instance, [very simplified] course of study model might have:

student has many enrollments

course has many sections

sections has many enrollments

there seem many approaches setting info models , relationships, , more obvious others. often, find myself thinking 1 way , finding out much later there quirk or complication missed.

for more complex systems, erp, reservations, ecommerce, etc., there must standards , best practices can't find them anywhere. resource suggestions welcome. i've googled around quite bit, didn't see made sense.

data modeling can done in varied different ways , selection of modeling technique dictate best practices want follow. 2 mutual modeling techniques -

entity-relationship modeling, , dimensional info modeling

the scenario mentioned above can modeled er model or dimensional model. when think best practices, boils downwards fact whether or not understand principle tenets behind modeling technique.

for example, long model info in normalized (3nf etc.) form , able avoid update/delete anomaly, cut down info redundancy etc. can pretty sure have followed best practices required er modeling.

similarly, if have modeled in dimensional modeling, want ensure maintain proper balance between speed of info extraction versus speed or info insertion / update etc.

as resources on design pattern, may check few of these articles:

common mistakes in info modeling other data modeling articles

hope helps.

database-design model data-modeling