BMGT 402 Lecture 13: BMGT402 Lecture 13 – Chapter 12

• School: University of Maryland
• Department: Business and Management
• Course: BMGT 402
• Professor: Woei- Jyh Lee

Document Summary

Bmgt402 lecture 13 chapter 12: entity relationship modeling cont: structural constraints, constraints placed on entity types that participate in relationships, multiplicity b. i. The number (or range) of possible occurrences of an entity type that may relate to a single occurrence of an associated entity type through a particular relationship b. ii. Represents business rules established by user or company b. iii. Specify two types of restrictions on relationships b. iii. 1. Maximum number of possible relationship occurrences for an entity participating in a given relationship type b. iii. 2. Determines whether all or only some entity occurrences participate in a relationship b. iii. 2. b. 0 1 zero or one entity occurrence b. iv. 2. 1 1 (or just 1) exactly one entity occurrence b. iv. 3. 0* (or just *) zero or many entity occurrences b. iv. 4. 1* one or many entity occurrences b. iv. 5. 5 10 min of 5 up to a max of 10 entity occurrences b. iv. 6. Zero or three or six, seven, or eight: multiplicity for complex relationships c. i.