Based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM VENDOR WHERE V_STATE = TN ORDER

Question:

Based on the following query:

SELECT V_CODE, V_NAME, V_CONTACT, V_STATE

FROM VENDOR

WHERE V_STATE = ‘TN’

ORDER BY V_NAME;

Assume that 10,000 vendors are distributed as shown in Table P11.18. What percentage of rows will be returned by the query?

Table P11.18:

State	Number of Vendors	State	Number of Vendors
AK	15	MS	47
AL	55	NC	358
AZ	100	NH	25
CA	3244	NJ	645
CO	345	NV	16
FL	995	OH	821
GA	75	OK	62
HI	68	PA	425
IL	89	RI	12
IN	12	SC	65
KS	19	SD	74
KY	45	TN	113
LA	29	TX	589
MD	208	UT	36
MI	745	VA	375
MO	35	WA	258

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database Systems Design Implementation and Management

ISBN: 978-1337627900

13th edition

Authors: Carlos Coronel, Steven Morris

See More Books

Question Posted: Dec 19, 2018 09:53 AM

See More Questions

Based on the following query: SELECT P_CODE, SUM(LINE_UNITS) FROM LINE GROUP BY P_CODE HAVING SUM(LINE_UNITS) > (SELECT MAX(LINE_UNITS) FROM LINE); Write the command to create statistics for this...
Based on the following query: SELECT P_CODE, P_QOH*P_PRICE FROM PRODUCT WHERE P_QOH*P_PRICE > (SELECT AVG(P_QOH*P_PRICE) FROM PRODUCT) What is the likely data sparsity of the P_QOH and P_PRICE...
Based on the following query: SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATE FROM PRODUCT P, VENDOR V WHERE P.V_CODE = V.V_CODE AND V_STATE = NY AND V_AREACODE = 212; ORDER BY P_PRICE;...
What are conjugate faults, and what stress information do they give?
Due to rapid employee turnover in the accounting department, the following transactions involving intangible assets were recorded in a questionable way by Hahn Company in the year ended August 31,...
During its first year of operations,Nile.comreported an operating loss of $15 million for financial reporting and tax purposes. The enacted tax rate is 40%. Prepare the journal entry to recognize the...
P6-2 Upstream and downstream sale of depreciable asset Jenna OYJ was a 90 percent-owned subsidiary of Mikko OYJ and was acquired in 2012. At the acquisition date, any fair value/book value...
In the engine system shown l = 10 in. and b = 4 in. The connecting rod BD is assumed to be a 3-lb uniform slender rod and is attached to the 4.5-lb piston P. During a test of the system, crank AB is...
Match the letter to the given scenario, which one makes sense? I am having trouble trying to figure this out. ( Auditing ) Requirement c. For each control, identify an audit procedure that could be...
Complete the entire pay cycle process by calculating gross to net pay, employer premium amounts and complete required accounting entries. Sandra works in British Columbia and is paid on a...
Based on the following query: SELECT P_CODE, SUM(LINE_UNITS) FROM LINE GROUP BY P_CODE HAVING SUM(LINE_UNITS) > (SELECT MAX(LINE_UNITS) FROM LINE); Should you create an index? If so, what would the...
Using Table 11.4 as an example, create two alternative access plans.
Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system....
1. Do you think that the NFL and franchise owners are meeting their obligations to employee health and safety? 2. Do you think that the NFL's and owners' responsibilities in terms of player safety...
Explain the term \'management\'. Also, explain briefly mission functions of management. ( b ) What are the different types of plant layout? Explain any two with neat sketches.
Suppose that you are considering an investment product that promises to pay $ 2 , 0 0 0 at the end of each year for the next five years. Assume that a discount rate of 1 2 % is applicable to similar...
Leadership Philosophy: Democratic and Transformational leadership In 700+ words ,explain how the leadership philosophy might impact an organization and how it would be beneficial.Identify what are...
performance and participation. The employee requirement that is met is status and recognition. The performance result is awakened drives. This model is dependent on leadership strive. It gives a...
Describe the elements of a waiting line system.
Using thermodynamic data from Appendix 4, calculate G at 258C for the process: 2SO 2 (g) + O 2 (g) 88n 2SO 3 (g) where all gases are at 1.00 atm pressure. Also calculate DG8 at 258C for this same...
The table structure shown in Table P6.6 contains many unsatisfactory components and characteristics. For example, there are several multivalued attributes, naming conventions are violated, and some...
Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club's members, to...
Use the dependency diagram shown in Figure 6.8 to work the following problems. a. Break up the dependency diagram in Figure 6.8 to create two new dependency diagrams, one in 3NF and one in 2NF. b....
Deacon Company is a merchandising company that is preparing a budget for the three - month period ended June 3 0 th . The following information is available Deacon Company Balance Sheet March 3 1...
Mango Company applies overhead based on direct labor costs. For the current year, Mango Company estimated total overhead costs to be $460,000, and direct labor costs to be $230,000. Actual overhead...
Which of the following do we expect to be the horizon growth rate for a company (long term growth rate- say 30-50 years)? A) Inflation B) Industry Average C) Zero D) Market Beta

Based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM VENDOR WHERE V_STATE = TN ORDER

Question:

Step by Step Answer:

Given the distribution o...View the full answer

Database Systems Design Implementation and Management

Students also viewed these Computer science questions