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%.
|
Find a journal article of a longitudinal study
: Find a journal article of a longitudinal study and outline the abstract. How could you change this study to a cross-sectional one?
|
|
What you know of the use of age as an independent variable
: Here’s a statement of the results of an experiment. “As the sample got older, from 50 to 70 years, lung volume decreased.” Although this statement might be true, what might be one interpretation, given what you know of the use of age as an independen..
|
|
Which of the following best describes william penns vision
: Which of the following best describes William Penn's vision for living in America?
|
|
Regression that specifies natural log of cars
: Using the data file (LightUpTempF2015Short2.syz or the Excel equivalent)run a regression that specifies Natural Log of Cars= f(Natural Log of Price). Extract and specify the equation.
|
|
Provide the statement necessary to answer the given queries
: List all salesperson numbers, salesperson names, and their salaries - List the addresses, balances, and invoice numbers of those customers who were sold merchandises in the database
|
|
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, ..
|