Answers

Hire Dedicated Virtual Team / Business Solution for SMEs.

About ComputerScienceExpert

Education

Experience

Problems 1-3 are based on the following query

Attachments

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Applied Sciences,Calculus See all

Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all

Teaching Since:	Apr 2017
Last Sign in:	103 Weeks Ago, 3 Days Ago
Questions Answered:	4870
Tutorials Posted:	4863

MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000

Professor
Devry University
Mar-2010 - Oct-2016

Category > Programming Posted 02 Jun 2017 My Price 9.00

Problems 1-3 are based on the following query:

SELECT V_CODE, V_NAME, V_CONTACT, V_STATE

FROM VENDOR

WHERE V_STATE =’TN’

ORDER BY V_NAME;

1. What indexes should you create and why? Write the SQL command to create the indexes.

2. 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 Distribution of Vendors by State

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

3. What type of I/O database operations would be most likely to be used to execute that query?

4 Using Table 11.4 as an example and the information from problems 1-3, create two alternative access plans.

Table 11.4

ComputerScienceExpert

(11)

Status NEW Posted 02 Jun 2017 01:06 AM My Price 9.00

-----------

file 1496368333-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

Buy Answer

I/O

Operations

Resulting Set Rows

Total I/O

Cost