Sample data for the STOCK table: (Microsoft Access)

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
DIS	Disney Corp	NYSE
NGD	New Gold	AMEX
BAC	Bank of America	NYSE
JPM	JPMorgan and Chase	NYSE
PFE	Pfizer Inc	NYSE
C	Citigroup	NYSE
GRPN	Groupon Inc.	NASDAQ
WEN	Wendys Company	NASDAQ
NOK	Nokia, Inc	NYSE
GE	General Electric Co.	NYSE
BIDU	Baidu Inc	NASDAQ
PCLN	Priceline Inc	NASDAQ
HPQ	Hewlett-Packard Inc	NYSE

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
A231	AAPL	200	430	1/18/2013
A231	IBM	200	85	1/10/2019
A441	NOK	3000	2	1/12/2011
A441	LNG	1000	5	1/12/2008
A441	HPQ	300	22	3/12/2011
A441	OMC	100	45	2/12/2013
A451	PCLN	300	620	1/12/2015
B111	HPQ	1000	4	2/12/2013
B111	BAC	1000	6	8/12/2012
B111	C	5000	2	2/12/2018
B111	DIS	300	31	5/12/2012
B118	PCLN	1000	650	2/12/2019

PART A:

• Develop the tables in ACCESS database Systems
• Identify PK and FK of each table (can do in WORD)

Table 1 (identify PK and FK relationships)

Table Name	STOCK	PORTFOLIO
Primary Key (PK)
Foreign Key (FK)

Submit this table as Part A (section 2) requirement to be submitted see below

• 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