Question
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started