Chapter 2.2, Problem 4QC

Problem 1. Using the INVOICE table structure shown in table below do the following:   INVOICE Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2016 15-Jan-2016 15-Jan-2016 15-Jan-2016 16-Jan-2016 PROD_LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT_SOLD 1 8 1 2 1 PROD_PRICE $49.95 $3.45 $39.99 $49.95 $87.75 Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that an invoice number references more than one…

The following code would include: SELECT P.P_DESCRIPT, P.V_CODE, V.V_NAME FROM PRODUCT P RIGHT OUTER JOIN VENDOR V ON P.V_CODE=V.V_CODE Group of answer choices   A) all rows of the PRODUCT Table regardless of matches with the VENDOR Table. B) all rows of the VENDOR Table regardless of matches with the PRODUCT Table. C) only rows that match both PRODUCT and VENDOR Tables. D) only rows that don't match both PRODUCT and VENDOR Tables.

A boxplot shows the value 31 at the first quartile. What does this tell you?   Question 3 options:   31% of the data is less than 25.   75% of the data is less than 31.   25% of the data is greater than 31.   31% of the data is greater than 25.   25% of the data is less than 31.   Group A has a mean of 0 and a median of 15 What is most likely true?   Question 8 options:   Group A likely has a high outlier or right skew   Group A is likely roughly symmetric and unimodal   Group A likely has a low outlier or left skew   Group A likely has low and high outliers.   None of these

If you wish to run more than two conditions in a single Excel run, what filter will you use?

how do you use absolute value in excel?

Using the SELECT statement, query the invoice table to find the average total cost for all orders placed between 2011-01-01 and 2012-01-01.     0 5.7063106796116505 5.8095238095238095 5.7357723577235772

Write the Excel function to determine the number of salespersons who had a Sales Total above the given “Average Sales Total”?

When we choose to display only a partial set of the fields from a single table, we are using the relational operation known as a ________________ .   Question 47 options:   1)  join   2)  project (projection)   3)  product   4)  difference   5)  select (selection)

Display the salesperson name, product finish, and total quantity sold (label as TotSales) for each finish by each salesperson.