Can you explain how you would build a data model or Entity Relationship Diagram to support a complex business requirement?
Use the provided relational model to demonstrate how requirements, entities, and relationships can be represented and validated. Include requirements without entities and entities without relationships in the result.
requirement_name, entity_name, relationship_count, and relationship_status.| Column | Type | Description |
|---|---|---|
| requirement_idPK | INT | Unique identifier for a business requirement |
| requirement_name | VARCHAR(150) | Name of the business requirement |
| owner_team | VARCHAR(100) | Team responsible for the requirement |
| status | VARCHAR(30) | Current lifecycle status |
| Column | Type | Description |
|---|---|---|
| entity_idPK | INT | Unique identifier for a data entity |
| requirement_id | INT | Requirement supported by the entity |
| entity_name | VARCHAR(100) | Name of the modeled entity |
| entity_type | VARCHAR(40) | Classification of the entity |
| Column | Type | Description |
|---|---|---|
| relationship_idPK | INT | Unique identifier for an entity relationship |
| requirement_id | INT | Requirement containing the relationship |
| source_entity_id | INT | Entity from which the relationship originates |
| target_entity_id | INT | Entity referenced by the relationship |
| relationship_type | VARCHAR(50) | Business meaning of the relationship |
| cardinality | VARCHAR(20) | Expected relationship cardinality |