Schema of a database storing information

Assignment Help Business Management
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)

Reference no: EM131447959

Questions Cloud

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.

Reviews

Write a Review

 

Business Management Questions & Answers

  Build a successful marketing division

Explore the Marketplace Live simulation. Discuss any previous experience you have had with strategic planning. How will your experience help you in working with your team to build a successful marketing division?

  Cost benefit analysis of cash management city farm insurance

Cost benefit examine of cash management City Farm Insurance has collection centers across the nation to speed up collections. The firm also makes its disbursements from remote disbursement centers

  Program design reduces cost and satisfies learners

Question: Identify the design elements whish help ensure that participants learned and put it into practice. Explain how these design elements encourage learning and transfer.

  Explaining autocratic decision-style methods

Research and discuss a leader, executive, or manager who is famous for theory X, autocratic decision-style methods.

  Discuss three products that seem to have declined

Discuss three products  or services  that seem to have declined  in consumer demand.

  Conduct of the salesperson constitute fraud

When Lester learned the truth, he sued Mackintosh Motors and the salesperson for damages for fraud. They raised the defense that the salesperson did not know the statement was false and had not intended to decide Lester. Did the conduct of the sal..

  What is a trade clinic

What is a trade clinic? Do you realise that these clinics are a positive development for American medical care? Why, or why not?

  Multiple ospf areas have to connect to area 0

1. Name one troubleshooting command you would use when troubleshooting an OSPF network. Explain what the command does and what field in particular you would look at to find out what is going on. 2. What is Area 0 and do multiple OSPF areas have to..

  Customer and various stakeholders

The previous project manager has left the company and the new project manager is upset that the change reports are streaming in from numerous sources including his boss, the customer and various stakeholders. The project manager is not even aware ..

  National organizations-measuring quality

Based on the national quality management organization you were assigned in Unit 1, consider the types of measures that your organization is involved in on the national and local health care scene.

  Illustrating how you might use motivational concepts

Develop a scenario illustrating how you, in your role as a manager, might use motivational concepts to create an environment where your employees are motivated and satisfied with their jobs.

  Which of the following is true about secondary data

Joe Kerry, owner of a small bakery, wants to obtain marketing insights to improve his business. Joe has a limited budget and would like to gather free secondary data. What is the best option for Joe?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd