The following table shows the student grades for Q1 and Q2 assessment activities. Calculate the mean and mode for Q1 and Q2 grades Calculate the range and standard deviation for Q1 grades and Q2 grades Student Number Q1 Grade Q2 Grade Total student Grade 1 85 79 164 2 96 85 181 3 84 76 160 4 75 76 151 5 64 94 158 6 83 83 166 7 92 92 184 8 74 71 145 9 67 81 148 10 81 93 174 11 93 72 165

move data to 1st 2nd and 3rd normal form

LUNCH SALES Days of Week Lunch Sold Qty Unit Price Total Sold Monday Chicken 25 15.00  $      375.00 Monday Pork 15 20.00  $      300.00 Monday Fish 20 25.00  $      500.00 Tuesday Mutton 15 23.00  $      345.00 Tuesday Fish 30 25.00  $      750.00 Wednesday Chicken 55 15.00  $      825.00 Thursday Turkey 45 18.00  $      810.00 Friday Turkey 60 18.00  $   1,080.00 Saturday Chicken 15 15.00  $      225.00 Saturday Mutton 45 23.00  $   1,035.00 Saturday Fish 55 25.00  $   1,375.00 Saturday Turkey 50 18.00  $      900.00 Saturday Pork 20 20.00  $      400.00 Sunday Fish 55 25.00  $   1,375.00 Sunday Mutton 35 23.00  $      805.00 Sunday Chicken 30 15.00  $      450.00               #NAME?           Fruit # of Days Sold Total Sold Sum of Total Sold       Chicken             Mutton             Fish             Turkey             Pork                           Instructions: (Fill in the columns of the "Calculations Table")       1.…

In cell C16, create a formula that adds 1 to the growth rate (cell C14) and multiplies the result by the estimated profit from 2021 (cell C15). Use an absolute row reference to cell C14.

Is the following table in First Normal Form? If so, how would you get it into first normal form.         SalesPerson/Product table         Order Number Product  Number Salesperson ID SalesPerson Name Commission Percentage Year of Hire Department Number Department                 Name Product Name Unit Price Quantity 137 19440 15 Baker 10 1995 73 Commercial Sales Hammer 17.50 473   24013             Saw 26.25 170   26722             Pliers 11.50 688 186 16386 7 Adams 15 2001 59 Home Sales Wrench 12.95 1745   19440             Hammer 17.50 2529

Use the given data to classify the record below using the k-NN algorithm for k = 1 to 5. Loan Purpose Checking Repairs Savings Months Customer Employed Months 0 900 25 4 Click the icon to view the table of classified records. D Complete the table below for the nearest neighbors and for the classification of the new record for each value of k. k Distance Classification 1 2 3 4 5 (Round to four decimal places as needed.)

Attribute Name Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 PROD NUM SALE DATE PROD LABEL VEND_CODE VEND_NAME QUANT SOLD PROD_PRICE AA-E3422QW 15-Jan-2018 Rotary sander 211 QD-300932X 15-Jan-2018 0.25-in. drill Band saw 211 309 NeverFail, Inc. NeverFail, Inc. BeGood, Inc. 1 $49.95 8 RU-995748G 15-Jan-2018 $3.45 1 $39.99 Sample Value Sample Value 211348 211349 AA-E3422QW 15-Jan-2018 Rotary sander 211 Power drill 157 NeverFail, Inc. ToughGo, Inc. 2 GH-778345P 16-Jan-2018 $49.95 1 $87.75 c) Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created.

For questions 6-9, create a truth table for each statement. 6. A ⋀ ~B 7. ~(~A ⋁ B) 8. (A ⋀ B) → C 9. (A ⋁ B) → ~C

Answer the following questions by referring to the tables below. COURSE Course_name Course_number Credit_hours Department Intro to Computer Science CS1310 4 CS Data Structures CS3320 4 CS Discrete Mathematics MATH2410 3 MATH Database CS3380 3 CS   SECTION Section_ID Course_number Semester Year Instructor 85 MATH2410 Fall 07 King 92 CS1310 Fall 07 Anderson 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fall 08 Anderson 135 CS3380 Fall 08 Stone Retrieve a list of all the courses under the "CS" department, listed alphabetically by course name. Retrieve the section ID, course name, course number, semester, year, and Instructor of the courses taught by Instructor "Anderson". Insert a tuple for a new COURSE with the following information: 4.The course name is Computer networks, and the course number is CS3480. It belongs to the CS…