Reference no: EM13764661
Instructions: Write the SQL code to perform the tasks requested in each problem. Note that Problem 10 requires you to answer a question.
1) Define a view containing products from supplier number S3399214. Include all product columns in the view.
2) Define a view containing the details of orders placed in January 2010. Include all OrderTbl columns, OrdLine.Qty, and the products name in the view.
3) Define a new containing the product number, name, price, and quantity on hand along with the number of orders in which the product appears.
4) Using the view define in problem 1, write a query to list the products with a price greater than $300. Include all view columns in the result.
5) Using the view defined in problem 2, write a query to list the rows containing the words "Ink Jet" in the product name. Include all view columns in the result.
6) Using the view defined in problem 3, write a query to list the products in which more than five orders have been placed. Include the product name and the number of orders in the result.
7) For the query in problem 4, modify the query so that it uses base tables only.
8) For the query in problem 5, modify the query so that it uses base tables only.
9) For the query in problem 6, modify the query so that it uses base tables only.
10) Is the view in problem 1 updatable? Explain why or why not.
|
Performing all the bookkeeping functions for the business
: Develop a hypothetical business you would consider starting with a friend or relative. Imagine also that you will be performing all the bookkeeping functions for the business
|
|
Write the sql code to perform the tasks
: Write the SQL code to perform the tasks requested in each problem. Define a new containing the product number, name, price, and quantity on hand along with the number of orders in which the product appears.
|
|
Growth of hospitals and health care systems
: Predict the type of long-term care needed as the 21st Century America advances in age. Defend or critique the type of care patients obtain in private nursing homes as compared to public institutions or in-home care. Provide a rationale for your re..
|
|
Review reading in qualitative research and evaluation method
: Review the reading in Qualitative Research and Evaluation Methods and the video segment "Doctoral Research: Ensuring Quality in Doctoral Research."
|
|
Write the sql code to perform the tasks
: Write the SQL code to perform the tasks requested in each problem. Define a new containing the product number, name, price, and quantity on hand along with the number of orders in which the product appears.
|
|
Review reading in qualitative research and evaluation method
: Review the reading in Qualitative Research and Evaluation Methods and the video segment "Doctoral Research: Ensuring Quality in Doctoral Research."
|
|
Principles and theory of security management
: think of some intrusions - the disgruntled mailman flying onto the Capitol lawn on his gyrocopter and remember the couple who crashed a White House function a few years ago?
|
|
Provide details of how the mobile self-service
: Prototyping, Write a proposal to the University including the following. The prototypes that could be created.The type of usability testing to use in determining the design that will provide the best user experience.
|
|
Data and process modeling
: The next phase in the project development cycle is to develop a logical model of the system based on the system requirements. The first step is about the "what" step. We need to show what the system will do, without worrying about how it will do..
|