Need help producing an ER diagram.

ntroductory Relational Database Design for Business, with Microsof es and rtfolios for a small stockbroker's office. For each broker in the ofo you want to store a first name, middle name/initial, last name, phone extension number, cell phone number, e-mail address, and date hired For each of the firm's clients, you want to store a first name, middle name/initial, last name, address information, home phone number, work phone number, cell phone number, and e-mail address. Each client is assigned to a single stockbroker, and the database should remember which one. You also have a master list of securities which your firm is licensed to trade. For each security, you want to store a ticker symbol and a description. No two securities may have the same ticker symbol. Finaly, you want to keep track of each client's transactions. For each transaction Stockbroker's office: You are setting up a system to track trades as po Sell: "Dividend," etc.), which security was involved, the net n shares, want to store the date/time it occurred, a transaction type ("Buy umber o buying type of 100 shares of IBM at $98.55 per share would mean a transacuo,ile sell and the net cash. For example, (ignoring commissions) net number of shares- +100, and net cash -$9,855.00; while would mean a transaction type of "Sell" net number of shares net cash- +$272.10. ing 10 shares of Cisco Systems (ticker symbol CSCO) at $272P1. and per share A Design a database to hold all this information. You can create sine and keys as necessary or convenient. Create a database de an ER diagram. B In Access, create all tho ign outline and this database ond