Relational Database Design A) Given the following business rules, identify entities and develop the corresponding Entity Relationship Diagram, indicating entity types, relationship types, attributes (including primary keys) and cardinality constraints. The following business rules are given: Each testing agent can submit any number of support tickets and each support ticket is sent by one testing agent. Each development team can work on one or more software; and each software is handled by at least one development team. Each testing agent tests only one software; and each software may be tested by one or more testing agents. B) Optimize the relationships using Associative Entity. C) Transform the ERD into Relations and apply referential integrity constraints.