A retail company has decided to organize information about its sales representatives and customers in a database. The company has enlisted you as the database designer. Develop an ERD diagram for this company based on the following detailed description: The company employs a dynamic team of sales representatives, each having a unique RepresentativeID, Birth Date, Gender, and Name represented as FirstName and LastName. Additionally, each sales representative has a specific SalesRegion designation. The company's branches, identified by BranchID (unique), have attributes such as BranchName, Location, and an additional attribute, FloorSpace, indicating the physical size of the branch. Sales representatives handle various sales deals; each deal is uniquely identified by DealID and includes information about DealName, DealNumber, Location, and a Timestamp capturing when the deal was initiated. Each sales representative may have a set of assistants; each assistant has a unique AssistantName, Gender, Birth Date, and a specialized skill set, denoted as AssistantSkill. If a sales representative leaves the company, there is no need to store information about their assistants. However, a DepartureDate is recorded for historical tracking. For each branch, there is always one sales representative assigned to manage that branch. In addition to HiringDate, the manager's performance is tracked through a ManagerRating attribute. A branch may have multiple sales representatives, but each sales representative works in only one branch. The sales representatives are categorized into different roles such as SeniorSales, JuniorSales, and TraineeSales, each denoted by a RoleID. Each branch may have a set of deals, and each deal must be assigned to one branch. Additionally, the DealStatus attribute indicates whether a deal is ongoing, completed, or pending closure. Sales representatives work on various deals, and each deal involves multiple sales representatives. Each sales representative reports the number of hours worked on each deal, and the DealProgress attribute indicates the current status of their contribution to the deal. Each sales representative has a supervisor, denoted by a SupervisorID, and the SupervisionStartDate indicates when the supervisory relationship began. The supervisor's name and contact information are also stored for reference.