User Account

All Pages

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

Questions Cloud

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, ..

Reviews

Write a Review

 

Database Management System Questions & Answers

  Create an arff file with the data types

Create an arff file with the following data types, flags, unit_id, names must be nominal and timestamps (ts) must be date

  What is the oldest log record we need to retain

If a bounded amount of stable storage is used for the log, how can we always ensure enough stable storage to hold all log recordswritten during restart?

  Convert data model to a set of virtual windows

You are to design a prototype for a hospital management system. Design a data model for this system, Convert the data model to a set of virtual windows.

  Planning the implementation of a database application

Discuss the importance of planning the implementation of a database application. What are some of the pitfalls of not planning for the implementation of a database application

  Create a new table in which to store publisher information

In the following project, you will open a database containing the inventory of a bookstore, create a new table in which to store publisher information, add records, and then sort the table

  Principles of data management and relational databases

Develop a time sheet entry/customer account management software system using relational database software and prepare an associated report detailing the technical and learning issues encountered.

  Explain the architecture of a system for serving up

Draw a diagram of, and explain the architecture of a system for serving up dynamic pages from a database. Show the protocols involved, the flow of messages and what types of information the messages contain.

  The strayer oracle server may be used to test and compile

the strayer oracle server may be used to test and compile the sql queries developed for this assignment. your

  Create script file to list file in directory in sorted order

Create a script file to list the files in a directory in sorted order, showingonlythe file name, file size, and modification date.Each file's attributes must be on one line per file, in any order.

  Query using a literal character string

query specifying specific columns query using a column alias query using the concatenation operator query using a literal character string

  Create a decision table that describes movement of inventory

Name four attributes that you can use to define a data flow in the grocery inventory information system.

  Draw an entity relationship diagram for the system

Draw an Entity Relationship diagram for the system and Identify the table design for the database displaying all the fields/attributes. Ensure that all tables are in 3NF. You also need to identify the primary keys and foreign keys, where applicable..

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