Please help with this problem....

Draw an entity-relationship diagram (ERD) using a common diagramming tool such as MS Word or an image file (that I would be able to open) that properly represents the following system. Do not "normalize" or "simplify the diagram at this stage but draw it as described below. Our DBMS needs to track the following data in our Floral Garden Club. Accounts (AccountID, AccountName, DateCreated). These indicate the checking accounts that the floral garden maintains. FYI The accounts are: Employee Salaries, Garden Expenses, Growth Fund. Memberships (MembershipCode, MembershipDescription, Cost). FYI, there are 3 types of memberships: Single, Family, Lifetime. Customers (CustomerID, FirstName, LastName, Address). Background Information: When customers apply for memberships, they pay the appropriate cost which is distributed to multiple accounts. Draw the Entity-Relationship Diagram based on the information above. It should be a very simple diagram at this stage. Design a normalized E-R Diagram and draw it in the same diagramming tool you used for part 1. You need to "resolve" any many to-many relationships by adding new entities. You will need to start with the original diagram and add the following entities (you can go beyond that if you'd like): Distribution (Year, MembershipCode, AccountlD...) For example: In 2017 those earnings are distributed into accounts based on this formula. For Family and Life Time memberships 50% Employee Salaries, 40% Garden Expenses, 10% Growth Fund. For Single memberships the entire amount goes to Garden Expenses. CustomerMemberships (...) The CustomerMemberships table would track actual customer memberships. In other words, it Would need to have the CustomerID Membership Code, Year, etc. There may be others you might want to add but consider keeping the ERD simple for the purposes of this exercise. 5 tables (entities) would be sufficient. You will also need to review the existing fields and consider whether they are appropriate and revise/break them up if needed. You