Using Pubs (or Pubs2) sample tables to create SQL statements (1 per question) to accomplish the following
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Diagram of the pubs2 database This diagram shows the tables in the pubs2 database and some of the relationships among them. Figure A-1: Diagram of the pubs2 database TITLE AUTHOR au_ord royaltyper N au_id 1 au_id AUTHORS au_Iname au_fname phone address city state country postalcode 1 au_id 1 1 au_id AU PIX pic format_type bytesize title_id title_id N 1 BLURBS pixwidth_hor pixawidth_vert au_id au_id copy TITLES title type pubold price advance total_sales notes pubdate contract 1 N SALESDETAIL ord num qty discount N stor_id 1 DISCOUNTS discounttype stor_id sto: lowaty highqty discount title_id title_id title_id title_id 1 pub_id pub_id N N1 stor_id stor_id N stor_id stor_id lord_num ord_num 1 ROYSCHED lorange hirange royalty PUBLISHERS pub pub_name city state SALES stor id N and num date stor_id 1 STORES city state stor_id stor_name stor_address country postalcode payterms Diagram of the pubs2 database This diagram shows the tables in the pubs2 database and some of the relationships among them. Figure A-1: Diagram of the pubs2 database TITLE AUTHOR au_ord royaltyper N au_id 1 au_id AUTHORS au_Iname au_fname phone address city state country postalcode 1 au_id 1 1 au_id AU PIX pic format_type bytesize title_id title_id N 1 BLURBS pixwidth_hor pixawidth_vert au_id au_id copy TITLES title type pubold price advance total_sales notes pubdate contract 1 N SALESDETAIL ord num qty discount N stor_id 1 DISCOUNTS discounttype stor_id sto: lowaty highqty discount title_id title_id title_id title_id 1 pub_id pub_id N N1 stor_id stor_id N stor_id stor_id lord_num ord_num 1 ROYSCHED lorange hirange royalty PUBLISHERS pub pub_name city state SALES stor id N and num date stor_id 1 STORES city state stor_id stor_name stor_address country postalcode payterms
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Using Pubs (or Pubs2) sample tables to create SQL statements (1 per question) to accomplish the following (command and output required): List the first name, last name and author ID of the authors...
-
In the last chapter you added and modified some tables for Kelly's Boutique. She would now like you to create, run, and print some select, parameter, and action queries. Make the following changes...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1.1. Define a want and a need, and give an example of each. Then, explain how the relationship between wants and needs affects the way people spend money. (4 points) 2.. Identify and describe an...
-
You are to write a critically reflective paper entitled: My Role as a Decision Leader in the Global Marketplace. The purpose of this paper is for you to demonstrate your competency in discussing key...
-
Write a structural formula for the CH3NO isomer characterized by the structural unit indicated. None of the atoms in the final structure should have a formal charge. All the Diagrams are included in...
-
Suppose you raise this book (inertia \(m=3.4 \mathrm{~kg}\) ) from the floor to your desk, \(1.0 \mathrm{~m}\) above the floor. (a) Does the gravitational potential energy of the Earth-book system...
-
Cicek Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Cicek Manufacturings operations: Current Assets as of December 31 (prior...
-
Total Energy (a) Conserved 12. Which one of the following is true in the case of inelastic collisions? Kinetic Energy Conserved Momentum Conserved (b) Conserved Not Conserved Conserved (c) Conserved...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,000 Accounts receivable 20,000 Inventory 36,000...
-
JIT makes quality cheaper because O JIT adds more buffers to the system and JIT prevents long runs of defects the cost of low quality can be hidden as inventory cost, JIT adds more buffers to the...
-
Using the price data, estimate expected returns and standard deviation of returns of BOTH companies and SPY. Use the close prices to calculate returns. Return in any month for a security can be...
-
(AKS 2a) Five groups of four vectors are shown below. All magnitudes of individual vectors are equal. Please rank the groups based on the magnitude of the resultant vectors if the four vectors in...
-
James needs to mix a 30% saline solution with a 60% saline solution to create 200 millileters of a 55.5% solution. How many millileters of each solution must James use? Answer: James must mix...
-
Suppose the utility function of the consumer is u(x,x2)=min{x1,x2). Further, suppose p=$4, P2 $2 and 1=$18. Based on this information, answer the following questions (questions 16-25). Questions: 16....
-
When dealing with the classical Hall effect and the quantum Hall effect, the magnetic field B, is often pointed along the z direction perpendicular to the sample plane. Now consider that the magnetic...
-
A spring has a natural length of 1 meter. A force of 25Newtons stretches the spring by of a meter. How much work is done by stretching the spring from a length of 1.5 meters to 2.5 meters?
-
In Problems 1522, find the principal needed now to get each amount; that is, find the present value. To get $750 after 2 years at 2.5% compounded quarterly.
-
How is a user password assigned in Oracle 11g?
-
To perform these assignments, refer to the tables in the JustLee Books database. Generate and test two SQL queries for each of the following tasks: a) the SQL statement needed to perform the stated...
-
To perform these assignments, refer to the tables in the JustLee Books database. 1. Determine how many books are in the Cooking category. 2. Display the number of books with a retail price of more...
-
N = 230, n = 15, k = 200 Compute the mean and standard deviation of the hypergeometric random variable X.
-
N = 60, n = 8, k = 25 Compute the mean and standard deviation of the hypergeometric random variable X.
-
One study showed that in a certain year, airline fatalities occur at the rate of 0.011 deaths per 100 million miles. Find the probability that, during the next 100 million miles of flight, there will...
Study smarter with the SolutionInn App