User Account

All Pages

Relational algebra using given relations

Assignment Help Business Management
Reference no: EM131512796

Given a set of relations

Customer (custId, fname, lname, address, city, state, zip, phone)

Dealership (dealerId, dealerName, address, city, state, zip, phone)

SalesTeam (salesId, dealerId, fname, lname)

Inventory (VIN, dealerId, Make, Model, color, modelYear, invoice_price, net_cost, msrp)

Transactions (custId, salesId, VIN, date, salePrice)

Please answer following in Relational Algebra using given relations. Please list all possible combinations if apply

  1. List all pairs of salesperson and vehicles which sale prices are below costs?
  2. List all customers and their sales people whom bought three or more vehicles?
  3. List all vehicles sold from dealerships locate in Riverside county since beginning of 2015?
  4. Please find the top sale dealerships in past 2 years?
  5. Find total number in stock at each dealership on Honda Civic?
  6. Find net revenue for each dealership on sales in year 2016?
  7. List all customers who bought cars outside their local dearships?

Reference no: EM131512796

Questions Cloud

Determine the cross price elasticity of demand : Determine the price elasticity of demand. Determine the cross price elasticity of demand. How would you characterize the demand for haddock?
Simple database for keeping track of venues : You have been given the following specifications of a simple database for keeping track of venues and events at the Olympics (note that primary keys are shown.
Athlete competes for a particular country : A database records information about athletes competing at the Olympics. An athlete competes for a particular country in one or more events.
Calculate the value of the bond : What is the relationship between the value of the bond today and the Yield to Maturity - what is the value of the growth (subtract a from b)?
Relational algebra using given relations : Please answer following in Relational Algebra using given relations. Please list all possible combinations if apply
Trend in the area of telecommunications : Research and select a current trend in the area of telecommunications. Prepare a 10-15 page paper in Microsoft Word AMU approved APA format
What do you think he would suggest as an economic plan : Have they helped or hurt our economy? If they were alive today, what do you think he would suggest as an economic plan for our economy?
Under continuous assault from hackers : Networks and personal computers are under continuous assault from hackers. The types of attacks vary widely in complexity and severity
Research paper topic - corporate or organisational culture : HI 6005: Management and Organisations in a Global Environment Research Paper Assignment. You will deliver your research topic findings in a presentation

Reviews

Write a Review

Business Management Questions & Answers

  How turbulence increases the need for organic networking

Review this week's resources. Select an organization and consider how turbulence can impact the organization.

  Describe the best possible merger or agreement to grow

With the same small business from the first discussion in mind, describe the best possible merger or agreement to grow your corporation and maximize profits.

  State children health insurance program

From the first e-Activity, specify whether your state follows the private insurance model or the Medicaid model for its CHIP. Analyze the impact that the choice of model has on the fiscal health of your state. Provide two (2) examples of this impa..

  Determining the shares of deltona

Theres a owns 500 shares of Deltona and wants to use homemade leverage to offset the leverage used by Deltona. Theresa should buy/ sell how many shares

  Estimated sg&a costs this year

Last year, Jen and Berry Inc. had sales of $50,000, cost of goods sold (COGS) of 12,000, depreciation charge of $3,000 and selling, general and administrative (SG&A) cost of $10,000. The interest costs were $2,500. Tewnty-five percent of SG&A cost..

  Illustrate what would the probability of general beauregard

. In the Third Battle of Bull Run, for which a CPM/PERT network was developed, General Beauregard would have won if his preparations had been completed in 15 days. Illustrate what would the probability of General Beauregard's winning the battle ha..

  Critiques of the wto

Briefly (in about 2-3 paragraphs)describe two (2) of the critiques of the WTO addressed in the course materials. In your answer, please make sure to respond to each of these critiques by indicating whether you agree or disagree and why.

  Main components of it infrastructure

In looking over the seven main components of IT infrastructure, List specific infrastructure (names of technologies and systems) you would incorporate into a new online bookstore.Make any assumptions you need to in order to carry out this assignme..

  What are advantages and disadvantages of decentralization

What are the advantages and disadvantages of decentralization? Does a company getting so large that it has to decentralize play a part in the gap between financial goals and actual ones?

  Problem regarding the labor relations

This assignment is intended to enable you to make a personal connection to our study of labor history.  Each of us adults has an employment history.  In addition, our family's employment history can personalize and enrich class discussion of the e..

  Case study effectively managing maternity leavethe case

case study effectively managing maternity leavethe case study scenariofour out of seven team members became pregnant

  The Pantheon is the most beautiful temple in Rome

There are many Roman temples in Europe - in Britain, France and Italy. The Pantheon is the most beautiful temple in Rome (in Rome = locative case).

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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