Draw an E-R diagram with at least four entities for any small organization. Draw the relations between entities with proper constraints. Include attributes for each entity with proper notations.
To get full credit, make sure that you include the following:
• Organization name (e.g., “small shoe store”)
• Organization description in a few sentences.
• Four entity types.
• Proper relations (lines) drawn between the related entities.
• All cardinality constraints.
• Relationship names (descriptive verbs).
• Attributes for each entity.
• Proper notation for each entity (e.g., identifier, required, derived, multivalued, and so forth).