how many metho

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 215 84 2002 215 HS 1991 215 JC 1994 216 B4 1989 216 CDP 2004 216 CNP 2002 216 HS 1985 217 HS 1992 217 JC 2000 218 B4 1990 218 CDP 2000 218 CNP 2005 218 HS 1984 218 M2 1995 TABLE EMPLOYEE EDUCATION Table name: EDUCATION EDU_CODE EDU_DESCRIPTION a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. EMP_EDUC 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma PRIMARY KEY(s) Junior College degree Master's degree FOREIGN KEY(s)

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree

Appendix EMPLOYEE Fnamo Minit Lname Ssn Bdato Addross Ser Salary Super ssn Dno 123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555 333445555 1955-12-08 638 Voss, Houston, TX John B Smith Franklin Wong 40000 888665555 25000 987654321 999887777 1968-01-10 3321 Castlo, Spring, TX Wallaco 987654321 1941-06-20 201 Borry, Bollaire, TX Alicia Zolaya 4. Jonnifor 43000 888665555 4. Narayan 666884444 1962-09-15 975 Fire Oak, Humblo, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX Ramosh K Joyce 25000 333445555 Ahmad V Jabbar 987987987 1969-03-20 980 Dalas, Houston, TX M 25000 087654321 4. James Borg 888665555 1937-11-10 450 Stono, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dnamo Dnumber Mgr ssn Mgr start date Dnumbor Dlocation Rosearch 333445555 1988-05-22 Houston Administration 4. 987654321 1995-01-01 Stafford Headquarters 1. 888665555 1981-06-19 5. Bellaire 5. Sugarland Houston WORKS ON PROJECT Essn Pno Hours Pname Prumber Plocation Dnum 123456789…

A range check can be used to make sure that values fall between a specified minimum and maximum value. O True False

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.…

Using SQL find the number of employees from the table:

List the top five computer parts.

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

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