70.2K

Verified Solution

Link Copied!

Portfolio Database You have been hired by INT.com to keeps track of clients portfolio. INT.com is a brokerage which keeps clients stocks, bonds etc. and generates their portfolios. Assume a person cannot buy the same stock same day. I Smith cannot buy APPL twice in the same day. Following information on two tables (STOCK & PORTFOLIO) is available: STOCK (Stock_symbol, company_name, exchange_Name) Where Stock_symbol is the symbol of stock as traded on an exchange (PK) Company_name is the name of the company Exchange_name is the name of exchange (NYSE, AMEX, NASDAQ) And PORTFOLIO (owner_ID, Stock_symbol, number_bought, PRICE_PAID, Date_bought) (assume an owner can not buy the same stock twice) Where: Owner_ID is the id of INT.coms client (PK) Stock_symbol is the symbol of stock as traded on an exchange (PK) Number_bought is the number of total share bought Price_paid_per_share is the price paid/share Date_bought is the date when the stock was bought

Sample data for STOCK table:

PORTFOLIO (owner_ID, Stock_symbol, number_bought, PRICE_PAID_per_share, Date_bought)

Owner_ID	Stock_symbol	Number_bought	PRICE_PAID/share	Date_bought
A112	AAPL	10	450	4/12/2018
A112	PFE	3000	25	1/5/2018
A123	C	50	4	1/18/2018
A123	AAPL	50	425	1/12/2018
A123	PCLN	150	650	1/18/2012
A123	GOOG	50	430	3/18/2012
A123	GE	1000	16	1/18/2018

PART A:

• Develop the tables in ACCESS database Systems
• Identify PK and FK of each table (can do in WORD)
• Show the relationship (1:1 or 1:m or m:n) between the following:

• STOCK and PORTFOLIO in ACCESS and include a print screen copy from ACCESS

  Justify why it is 1:1 or 1:m or m:n

Table 1 (identify PK and FK relationships)

Stock_symbol	Company_name	Exchange_name
OMC	Omnicon Group	NYSE
AAPL	Apple	NASDAQ
IBM	IBM Corp	NYSE
GOOG	Google Corp	NASDAQ
BBY	Best Buy	NYSE
LNG	Cheniere Energy, Inc.	AMEX
CSCO	CISCO	NASDAQ
GE	General Electric Co.	NYSE
BIDU	Baidu Inc	NASDAQ
PCLN	PriceLine Inc	NASDAQ
HPQ	Hewlett-Packard Inc	NYSE

Answer & Explanation Solved by verified expert

See Answer