Consider the following monthly statement of a customer account from ABC Investment Service: ------------------------------------------------------------------ ABC Investment Services, LLC 1234 Parkside Drive Boston MA 021434 (800) 123-4567 Brokerage Account Summary Statement Customer Name: Joe J Sucker Customer Address : 19 Fish Rd, Boston, MA 02131 Date: 9/2/2006 Account Number: 32456783456 Period 8/1/2006-8/31/2006 Investment Advisor: Fred F. GrabAll Investment Advisor Phone: 212-00-1234 Symbol Type Description Shares Price Total T Stock ATT Common 1900 $20 $38,000 VZ Stock Verizon 2000 $40 $80,000 PG Stock Proctor and Gamble 10000 $90 $900,000 Portfolio Total: $1,018,000 ----------------------------------------------------------------------------------- Note, a customer can have several accounts of investment with ABC Investment Services. An account may include multiple stocks. A stock may be bought/sold at different time with different number of shares and share price. The ABC Investment Service also needs to keep track of all stock transactions happened in each account, including stock symbol, transaction type (buy/sell), number of shares bought/sold, share price at transaction, time/date of transaction, etc.. Each transaction is identified by a transaction. 

1. Create an ER- Diagram (not model) for above case. 

2 Convert your ER diagram into a set of tables (logical DB design