Data Modeling and Database Design

• Books:
  • Case*Method: Entity Relationship Modelling – Richard Barker
  • Data Model Patterns: Conventions of Thought – David Hay
  • Oracle SQL Developer Data Modeler for Database Design Mastery
  • Writing Effective Use Cases
  • Essential Systems Analysis
  • Dr. Peter Chen’s Site

• Papers and Writings:
  • Introduction to ER Modeling 
  • Dr. Peter Chen:
    • The ER Model – Basis for Enterprise Data
    • The ER Model – Toward a Unified View of Data
  • Comparison of Data Modeling Techniques – David Hay
  • Why We Model: Using MBD Effectively in Critical Domains
  • 8 reasons why Model-Driven Development is dangerous
  • Why the ER Model is Important
  • How to Beat the CAP Theorem
  • Primary Keys Should Be Immutable

•  Tools:
  • Oracle SQL Developer & Data Modeler (free)
    • Current Data Modeler Docs
  • Structure Charts

Cartoons

• Shadow slides:
  • Ents_Atts_Rels  and Advanced Modeling_Refined.pptx
  • Phases of Data Modeling &Implement Code