Computer-Science

Relational Database Design by ER- and EER-to-Relational Mapping

• ER-to-Relational Mapping Algorithm
  • Step 1: Mapping of Regular Entity Types
  • Step 2: Mapping of Weak Entity Types
  • Step 3: Mapping of Binary 1:1 Relation Types (외래키 접근방식)
  • Step 4: Mapping of Binary 1:N Relationship Types
  • Step 5: Mapping of Binary M:N Relationship Types
  • Step 6: Mapping of Multivalued attributes
  • Step 7: Mapping of N-ary Relationship Types
• Mapping EER Model Constructs to Relations
  • Step 8: Options for Mapping Specialization or Generalization
  • Step 9: Mapping of Union Types (Categories)

---

Source

1. Fundamentals of Database Systems 7th Edition by Ramez Elmasri, Shamkant B. Navathe.

This site is open source. Improve this page.