1. (Data Modeling and Logical DB Design) Consider the following form, obtained from the customer:

------------------------------------------------------------------

N. Gulf & Devour Investment Services (The FIRM) 1234 Parkside Drive Boston MA 021434 (800) 123-4567

Brokerage Account Summary Statement Client 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 Agent: Fred F. GrabAll

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

-----------------------------------------------------------------------------------

1. Create an E/R model for above information.(hint: this Firm has customers who have accounts of investment . An account may include multiple stocks , etc)

2. Transform the E/R model into database design model ( a set of tables)