Consider the following form, obtained from the customer:
------------------------------------------------------------------
N. Gulf & Devour Investment Services
1234 Parkside Drive
Boston MA 021434
(800) 123-4567
Brokerage Account Summary Statement Client Name: Joe J Sucker
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
-----------------------------------------------------------------------------------
a. Create an E/R model for above information.
b. Develop a set of functional dependencies that describe the information in this form.
c. Develop a set of third normal form (3NF) relations from these functional dependencies. Justify that your set of relations are actually in third normal form