Reference no: EM131447959
Question:
Devise relational algebra queries for the following schema of a database storing information about daily stock prices and basic transactions made by a trading rm. You should dene domains so as to make the schema complete.
STOCK (ticker, exchange) ticker: the stock's ticker symbol; e.g. GOOG, AAPL, GE exchange: the exchange where the ticker is listed; e.g. NYSE, NASDAQ PRICE (ticker, date, close) ticker: the stock's ticker symbol date: the date of the price information close: the closing price of the stock BUYnSELL (buy or sell,ticker, date, timestamp, value, num of shares) buy or sell: 'BUY' or 'SELL' ticker: the stock's ticker symbol date: the date of the price information timestamp: time of the transaction price: the price of a single share num of shares: number of shares (bought or sold)
Express the following except from (v) as relational algebra expressions.
i. Find the tickers and closing prices of all stocks exchanged in 2017 (careful with this question).
ii. Find the tickers whose closing price is both higher than 'IBM' on '3/20/2017' and no higher than 'GOOG' on the same date.
iii. Find the tickers of all stocks that closed at the highest price on '3/20/2017'. (we are asking for all stocks" since there may be more than one with the same highest price")
iv. Find the tickers of all stocks in 'NYSE' whose closing price on '3/20/2017' was either strictly below $20 or above $100
v. Find the tickers of the stocks whose closing price showed the highest increase between '3/20/2016' and '3/21/2016' in 'NYSE' and whose closing price was above $100 for the entire 2017 (we are asking for all stocks" since there may be more than one with the same increase)
|
Collective healthcare needs and capabilities
: How can the dimensions of diversity, such as age, race, ethnicity, gender, sexual orientation, and religion affect individual or collective healthcare needs and capabilities?
|
|
How are minerals extracted from the earth and processed
: How are minerals extracted from the Earth and processed? What are the different ways minerals can be mined? Provide a brief description of at least three types of mining. What effect does extracting minerals have on the environment
|
|
What were the effects on patients and on the community
: In the 1960s, mental health treatment shifted to a community-based orientation. Name two factors responsible for this shift? What were the effects on patients and on the community?
|
|
Create an awareness in employees
: Create an awareness in employees and their families of the impact of substance abuse and administer programs that consider employee rights, are positive in their intent and are within legal boundaries.
|
|
Schema of a database storing information
: Devise relational algebra queries for the following schema of a database storing information about daily stock prices and basic transactions made by a trading rm. You should dene domains so as to make the schema complete.
|
|
Briefly describe the negative impact
: Briefly describe the organization in which non-compliance with technology had a negative impact. Then describe the risk that was ignored, based on the standards (ITIL and COBIT5).
|
|
Explain why you think the interest in the person is greate
: More than ever before, celebrities and sports figures have become part of our daily existence. Magazines, television, and social media outlets highlight and describe their every move, and society still wants more.Provide an example of a celebrity..
|
|
Explain your approach in terms of word choice
: In a paragraph following the letter, explain your approach in terms of word choice, audience focus, addressing potential opposition to your product, and your appeals.
|
|
Fundamental building blocks of source programs
: Why are characters the fundamental building blocks of source programs? Provide an example to illustrate this concept.
|