BF1 BF 2 BF 3 BF4 SQL Query SELECT O.pid, O.orderDate FROM Department D JOIN Order...

Transcribed Image Text:

BF1 BF 2 BF 3 BF4 SQL Query SELECT O.pid, O.orderDate FROM Department D JOIN Order O ON (D.did=O.did) WHERE D.dName = 'Database Management' AND O.orderDate> '2021-08-19; SELECT O.did FROM Supplier S JOIN Order O ON (S.sid = O.sid) JOIN Part P ON (P.pid=O.pid) WHERE S.sName = 'A+' AND P.pName = 'Laptop' AND O.orderDate < 2020-01-01: SELECT D.dName, O.pid, O.orderDate FROM Department D JOIN Order O ON (D.did=O.did); SELECT D.dID, D.dName, D.phone FROM Department D WHERE address='Greensboro NC; Frequency Fraction 160 280 240 120 <1> <3> <4> Laated Performance <0.0001 Sec. <0.0001 Sec. <0.0001 Sec. <0.0001 Sec. Chosen Index Justification Type <12> <12> <13> <13> <40> <16> 6 <17 <29> <41>> <15> <18> <30> <42> <16> <18> <31> <43> <17> <17> 8 <20> <32> <44> <18> <18> <9> <21> <33> <45> <19 <19> <10> <22> 34> <46> <11> <23> <35> <47> <110> <110> <111> Supplier <12> <24> <36> <48> <12> <12> Name Table 2 is used to summarize the expected frequency of the tables and attributes Table Department Part Onder HFI pid Sid orderDate Sid Attribute Did <13> <25> <37> dName <2> <34> <26> <38> phone 43 <15> <27 <39> address <4> <16> <28> Pid Name Did BF2 BF3 114 Total <1> <2> <3> <7> <9> <10> <11> <12> Q5. Enter the information for the cell in Table 2? Q7. Enter the information for the cell <14> in Table 2? Q8. Enter the information for the cell <12> in Table 2? 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 BF2. BF1 BF 2 BF 3 BF4 SQL Query SELECT O.pid, O.orderDate FROM Department D JOIN Order O ON (D.did=O.did) WHERE D.dName = 'Database Management' AND O.orderDate> '2021-08-19; SELECT O.did FROM Supplier S JOIN Order O ON (S.sid = O.sid) JOIN Part P ON (P.pid=O.pid) WHERE S.sName = 'A+' AND P.pName = 'Laptop' AND O.orderDate < 2020-01-01: SELECT D.dName, O.pid, O.orderDate FROM Department D JOIN Order O ON (D.did=O.did); SELECT D.dID, D.dName, D.phone FROM Department D WHERE address='Greensboro NC; Frequency Fraction 160 280 240 120 <1> <3> <4> Laated Performance <0.0001 Sec. <0.0001 Sec. <0.0001 Sec. <0.0001 Sec. Chosen Index Justification Type <12> <12> <13> <13> <40> <16> 6 <17 <29> <41>> <15> <18> <30> <42> <16> <18> <31> <43> <17> <17> 8 <20> <32> <44> <18> <18> <9> <21> <33> <45> <19 <19> <10> <22> 34> <46> <11> <23> <35> <47> <110> <110> <111> Supplier <12> <24> <36> <48> <12> <12> Name Table 2 is used to summarize the expected frequency of the tables and attributes Table Department Part Onder HFI pid Sid orderDate Sid Attribute Did <13> <25> <37> dName <2> <34> <26> <38> phone 43 <15> <27 <39> address <4> <16> <28> Pid Name Did BF2 BF3 114 Total <1> <2> <3> <7> <9> <10> <11> <12> Q5. Enter the information for the cell in Table 2? Q7. Enter the information for the cell <14> in Table 2? Q8. Enter the information for the cell <12> in Table 2? 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 BF2.

Answer rating: 100% (QA)

BF1 To speed up the query you can create an index on the Department table for the DAName and Frequen... View the full answer