ER to Relational model mapping algorithm

relational model이란?
er = entitiy relation model이란?

goals

• 모든 정보 보존
• 제약조건 유지
• null 값 최소화

mapping하는법

• 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 relational types
• step 5 : mapping of binary M:N relational types
• step 6 : mapping of multivalued attributes
• step 7 : mapping of N-ary relational types