Provide the statement necessary to answer the given queries

Assignment Help Database Management System
Reference no: EM13839593

Question: Consider the following tables in a relational database. Provide the appropriate statement necessary to answer the queries that follow. Primary keys are underlined.

CUSTOMERS (CUSTNO, CNAME, CADDRESS, BALANCE)

SALESPERSONS (SPNO, SNAME, DATE_EMPLOYED, SALARY)

SALES (INVOICENO, DATE, CUSTNO, SPNO)

ITEMS-SOLD (INVOICENO, ITEMNO, QUANTITY, QUANTDISCOUNT)

(a) List all salesperson numbers, salesperson names, and their salaries.

(b) List the addresses, balances, and invoice numbers of those customers who were sold merchandises in the database

(c) List customer name, invoice number and date for items that were sold by the salesperson "Jane Doe", with sales unit more than 100 units, and quantity discount less than 5%.

Reference no: EM13839593

Previous Q& A

  What is a population? a group of organisms

What is a population? a group of organisms that occupy the same general area and all the abiotic factors that affect them a group of individuals of the same species that occupy the same general area a group of individuals of the same species that occ..

  Explain the most pertinent aspects of the message

Identify two to three conflicts that could potentially arise with any one of the constituents and the strategies you would employ to resolve the conflicts. Prioritize and explain the most pertinent aspects of the message to be conveyed to each grou..

  Discuss how you might be able to avoid the confounding

Propose a longitudinal study and a cross-sectional design being sure to identify the independent and dependent variables and discuss how you might be able to avoid the confounding that results from the presence of age in these quasi-experimental desi..

  Choose one of the phylogenetic schemes

Choose one of the phylogenetic schemes and explain why you feel this one is preferable to the others a) Eukaria, Bacteria , Archaea b) Animalia, Plantae, Fungi Protista, Prokaryota c) Bacteria, Archaea, Animalia, fungi, plantea d) Animalia, Plantae, ..

  Discuss the drug legalization debate

Discuss the drug legalization debate.  What are the arguments being presented for and against the legalization of drugs? What re some possible compromises? What do you think is the best option?

  Develop a detailed npv model in excel showing cash inflows

Develop a detailed NPV model in excel showing Cash Inflows, Cash Outflows and NPV of the project. What is the amount that you either expect to receive or are willing to pay the State Government to win this concession.

  Two angles whose sides are opposite rays are called _angle

Two angles whose sides are opposite rays are called _____ angles

  Draw the production possibilities frontier

Draw the production possibilities frontier based on the data in the above table. What is the opportunity cost of one pound of butter? How can you tell?

  What is an advantage to using abab over aba or ab designs

Give an example of an ABAB single-subject design. What is an advantage to using ABAB over ABA or AB designs?

  Demonstrate your understanding on project management

Demonstrate your understanding on project management by estimated total cost for project and corresponding costs of each task in MS project. You must arrange appropriate tools in MS Projects to answer question.

Reviews

Write a Review

 

Similar Q& A

  Find the single precision floating point representation

For each part of this problem, assume the Before values when the given Instruction is executed. Give the requested After values, Find the single precision floating point representation of the following numbers

  Explain what problems can occur in a distributed database

Explain what problems can occur in a distributed database that is partitioned but not replicated.

  Discuss the formula for computing entropy

The paper must discuss the relationship of Entropy to the likelihood that an attack can be successful, the formula for computing Entropy.

  What is the functionality of the tool

What is the functionality of the tool and what is the actual running environment (software and hardware) of the tool - how will you evaluate the tool based on your own experience?

  Relationship between the predictors and response variable

Does the overall regression show a significant relationship between the predictors and the response variable? Which predictor (s) significantly contribute(s) to the explanation

  Your lecturer will place several links in interact to a

your lecturer will place several links in interact to a number of relevant articles andor case studies. these will be

  How much total materials handling cost would be allocated

how much of the total materials handling cost would be allocated to the prefab barns and how much of the total materials handling cost would be allocated to the modular homes?

  Determine the relationship between those areas

For this question, need data mining analysis (using k-means clustering algorithm) shows the relationship between poverty area and violent crime rate (homicide) depending on any one of the datasets attached with this assignment.

  Create a new test02 class

Write a toString method that will return a String containing all the relevant data for each of your objects.

  Modify the no interest credit company application

Modify the No Interest Credit Company application so it executes continuously for any number of customers until a sentinel value is supplied for the account number.

  Identify the data types and sizes for all attributes

Select database management system (Oracle, SQL Server, MYSQL, etc) and identify the data types and sizes for all attributes

  Whose age is equal to their managers age first a nested

Consider two ways to compute the names of employees who earn more than $100,000 and whose age is equal to their manager’s age. First, a nested query:

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