Analyze the following Workload for 4 Business Functions (BF1-4) to determine which cohamns are worth indexing....

Transcribed Image Text:

Analyze the following Workload for 4 Business Functions (BF1-4) to determine which cohamns are worth indexing. The workload consists of a set of SQL statements and direction froncies and estimated performance goals. Complete the column Fraction and answer the question Q1. Q1. What is the value for the cell 1 in percent? BFI BF2 BF 3 BF 4 SQL Query SELECT O.pid, O.order Date FROM Department DJOIN Order O ON (D.did=O.did) WHERE DAName Database Management' AND O.orderDate> '2021-08-19; SELECT O.did FROM Supplier S JOIN Order O ON (S.sid - Osid) JOIN Part PON (P.pid=O.pid) WHERE S.Name = 'A' AND P.pName "Laptop' AND O.orderDate < 2020-01-01; SELECT D.dName, O.pid, O.order Date FROM Department D JOIN Order O ON (D.did=O.did); SELECT D.AID, D.dName, D.phone FROM Department D WHERE address "Greensboro NC; Frequency Fraction 160 280 240 120 <1> <2> <3> <4> Estimated Performance <0.0001 Sec. <0.0001 Sec. <0.0001 Sec. <0.0001 Sec. Complete the following tables, Table 1 and Table 2, based on the above workload statements. Then, answer the questions listed under each table. If the answer contains more than one value, add a comma to separate the values. Business Function BF1 BF 2 BF 3 BF4 Access Table A Output Column <5> <6> <7> Join Condition Column <9> <10 <11> Search Condition Column <13> <14> <15>> <16> <12> Table 1 is used to identify involved tables and attributes for each SQL statement. Q2. Enter the information for the cell <5> in Table 1? Q3. Enter the information for the cell <10> in Table 1? Q4. Enter the information for the cell <14> in Table 1? Table Department Part Chosen Indes Justification Type <i]> <il> <38> <12> <12> <39> <13> <13> <13> <25> <37> <34> <26> phone <3> <15> <27> address <4> <16> <28> <40> <H4> <i4> Pid 6 <17> <29> <41> <15> <i5> Name <B> <38> <30> <42> <16> <16> Did A <18> <31> <43> <17> <17> Order Attribute Did dName HEI BF2 BF3 B14 <D> <i> <li> <i> Total <il> <2> <3> <4> <5> <j6> <7> <18> <19> <19> pid 8 <20> <32> <44> Sid <9> <21> <33 <45> orderDate <1> <22 334> <46> <11> <23> <35> <47> <12> <24> <36> <48> <110> <10> <111> <i11> Supplier Sid Name Table 2 is used to summarize the expected frequency of the tables and attributes. <112> <12> <j8> <19> <10> <11> <12> Q5. Enter the information for the cell <i> in Table 2? Q6. Enter the information for the cell <40> in Table 2? Q7. Enter the information for the cell <14> in Table 2? Q8. Enter the information for the cell <12> in Table 27 Q9. Enter the information for the cell <12> in Table 2? Q10. Writing a SQL statement to create an appropriate index likely to speed up queries in the business functions, BF1 and 8F2. Analyze the following Workload for 4 Business Functions (BF1-4) to determine which cohamns are worth indexing. The workload consists of a set of SQL statements and direction froncies and estimated performance goals. Complete the column Fraction and answer the question Q1. Q1. What is the value for the cell 1 in percent? BFI BF2 BF 3 BF 4 SQL Query SELECT O.pid, O.order Date FROM Department DJOIN Order O ON (D.did=O.did) WHERE DAName Database Management' AND O.orderDate> '2021-08-19; SELECT O.did FROM Supplier S JOIN Order O ON (S.sid - Osid) JOIN Part PON (P.pid=O.pid) WHERE S.Name = 'A' AND P.pName "Laptop' AND O.orderDate < 2020-01-01; SELECT D.dName, O.pid, O.order Date FROM Department D JOIN Order O ON (D.did=O.did); SELECT D.AID, D.dName, D.phone FROM Department D WHERE address "Greensboro NC; Frequency Fraction 160 280 240 120 <1> <2> <3> <4> Estimated Performance <0.0001 Sec. <0.0001 Sec. <0.0001 Sec. <0.0001 Sec. Complete the following tables, Table 1 and Table 2, based on the above workload statements. Then, answer the questions listed under each table. If the answer contains more than one value, add a comma to separate the values. Business Function BF1 BF 2 BF 3 BF4 Access Table A Output Column <5> <6> <7> Join Condition Column <9> <10 <11> Search Condition Column <13> <14> <15>> <16> <12> Table 1 is used to identify involved tables and attributes for each SQL statement. Q2. Enter the information for the cell <5> in Table 1? Q3. Enter the information for the cell <10> in Table 1? Q4. Enter the information for the cell <14> in Table 1? Table Department Part Chosen Indes Justification Type <i]> <il> <38> <12> <12> <39> <13> <13> <13> <25> <37> <34> <26> phone <3> <15> <27> address <4> <16> <28> <40> <H4> <i4> Pid 6 <17> <29> <41> <15> <i5> Name <B> <38> <30> <42> <16> <16> Did A <18> <31> <43> <17> <17> Order Attribute Did dName HEI BF2 BF3 B14 <D> <i> <li> <i> Total <il> <2> <3> <4> <5> <j6> <7> <18> <19> <19> pid 8 <20> <32> <44> Sid <9> <21> <33 <45> orderDate <1> <22 334> <46> <11> <23> <35> <47> <12> <24> <36> <48> <110> <10> <111> <i11> Supplier Sid Name Table 2 is used to summarize the expected frequency of the tables and attributes. <112> <12> <j8> <19> <10> <11> <12> Q5. Enter the information for the cell <i> in Table 2? Q6. Enter the information for the cell <40> in Table 2? Q7. Enter the information for the cell <14> in Table 2? Q8. Enter the information for the cell <12> in Table 27 Q9. Enter the information for the cell <12> in Table 2? Q10. Writing a SQL statement to create an appropriate index likely to speed up queries in the business functions, BF1 and 8F2.

Answer rating: 100% (QA)

From the images you provided it looks like you want help with filling out tables that identify elements of SQL queries including business functions BF accessed tables output columns join conditions an... View the full answer