Devour investment services

Reference no: EM13207435

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

Reference no: EM13207435

Questions Cloud

When the united states entered the war in 1917 : When the United States entered the war in 1917, most Americans did not believe that

Founder of the united negro improvement association : Marcus Garvey, founder of the United Negro Improvement Association, is known for all of the following except

Purchase a large apartment complex : Williams has decided to purchase a large apartment complex. He pays $100,000 cash, obtains a loan on the property for $500,000, and assumes the fist mortgage balance of $250,000. H

Tangible and intangible forms of an organizational culture : Which form of organizational culture is the most powerful agent for influencing ethical behavior by employees in health care or human service organizations?

Devour investment services : N. Gulf & Devour Investment Services-Create an E/R model for above information. Develop a set of functional dependencies that describe the information in this form.

Discuss nature-strength of each of five competative forces : "Draw a five forces diagram for analysis of the retail car industry in the greater Johannesburg area and breifly discuss the nature and strength of each of the five competative forces."

Legal liability for serving alcohol : As a bartender how can you protect yourself from legal liability for serving alcohol?

Why do regulations on alcohol purchasing vary state to state : Why do regulations on alcohol purchasing vary state to state? And what are the consequences for not following the regulations?

Learning trip travel trends in the 21st century : Describe how evolving "learning trip" travel trends in the 21st century affect the strategies of tourism destinations to meet the new demands.

User Account

All Pages