Ashley has a data set of sales transactions in the following format Cust Gender Clothing Tech 1 Female 246 64 2 Male 171 345 130 41 Male I 52 58 Which of the following functions will return the average sales for the technology department for females in R? Multiple Choice AVERAGEIF(82.8131, "Female", D2:D131) AVERAGEIF(D2D131, "Female", B2D131) tapply(myDeta$Gender, myDataSTech, mean) tapply(myDataSTech, myData Gender, mean)

Ashley has a data set of sales transactions in the following format Cust Gender Clothing Tech 1 Female 246 64 2 Male 171 345 130 41 Male I 52 58 Which of the following functions will return the average sales for the technology department for females in R? Multiple Choice AVERAGEIF(82.8131, "Female", D2:D131) AVERAGEIF(D2D131, "Female", B2D131) tapply(myDeta$Gender, myDataSTech, mean) tapply(myDataSTech, myData Gender, mean)

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter6: Updating Data

Section: Chapter Questions

Problem 4SCG

See similar textbooks

Similar questions

Please convert the following ERD to RDM The following ERD shows the following information: Some College employees are information technology (IT) staff. Some IT staff are professors who teach IT courses. IT personnel are required to take periodic training to retain their technical expertise. EMPLOYEE EMP NUM EMP LNAME EMP FNAME EMP HIREDATE EMP STAFF EMP ADMIN EMP PROF {optonal, or Teet IT STAFF ADMIN PROFESSOR EMP NUM EMP NUM EMP NUM STAFF LEVEL ADMIN POSITION PRO SPECIALTY PRO RANK has TRAINING TRAINING ID TRAINING CATEGORY
Write a PL/SQL Function that accepts 4 integers, 2 representing the homeTeamID and visitorTeamID, and the other 2 representing the score for each team during a game : htscore and vtscore The function will determine which team won the match and return the teamID of the winning team. You can achive this by comparing htscore > or < then vtscore.. if htscore is bigger then return hteamID or else return vteamID. If the game was a tie (the 2 scores are the same value) return a 0.
SeriResort has four type of room packages, The rate for each package is shown in the following table: Type of Package Code Rate Per Day (RM) Premium 1 300 Family 2 200 Deluxe 3 150 Standard 4 100 Each guest has to pay 10% SST. The information needed to make a reservation at the resort are the guest’s name, type of package, number of days and type of booking (o – online, M – Manual). A discount of 10% will be given for online booking For each reservation, a receipt must be printed as shown below: SERI RESORT Guest Name xxxxxxxxxxxxxxx Type of Package xxxxxxxxxxxxx Number of Days xx Total Charges (RM) : xxx.xx SST 10% (RM) : xxx.xx Total Payment : xxxxx.xx Draw a flowchart to solve the given.
From the sale records of XYZ Groceries, Mr. Francis wants to find out the most frequent items, and multiple item-sets. The sales-data is given below. T1 "Mushroom","Aloo Bhujia" T2 "Mushroom","Pineapple Juice","rasgulla", "Apple" T3 "Aloo Bhujia","Pineapple Juice","rasgulla","Almond" T4 "Mushroom","Aloo Bhujia","Pineapple Juice","rasgulla". T5 "Mushroom","Aloo Bhujia","Pineapple Juice", "Almond" T6 "Mushroom","Pineapple Juice","Apple", "rasgulla" i. Mr. Francis plans to use a minimum support of 50 percent and minimum confidence of 80 percent. a. Build item-set combinations (of size 2) at XYZ Groceries. b. Build item-set combinations (of size 3) at XYZ Groceries. You must use the lift ratio, in case of a match.
Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr start date M EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Dno M WORKS ON Essn Pno Hours M PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints Q2// Write SQL statements that carry out the following tasks: 1-alter the employee table to add column city of 20 characters. 2- alter the employee table to apply the following business rule The minimum salary is 3000 and maximum salary is 10000 3- insert sample data in each table. 4- display a list of each employee SSN , Name and Salary. 5- display a list of each employee SSN, Name and Salary for employees working in department no 2.
Homework2 (1 solution Using Python A database has 5 transactions. Let min_sup = 60 % and min_conf = 80 % . TID T100 T200 T300 T400 T500 (a) Find all frequent itemsets using Apriori items_bought {M, O, N, K, E, Y} { D, O, N, K, E, Y} { M, A, K, E }{M,U,C,K,Y}{C,0,0,K, 1, E}(b) List all of the strong association rules (with supports and confidence c) matching the following metarule , where X is a variable representing customers , and item , denotes variables representing items ( eg,"A","B", etc. ) : Va e transaction , buys ( X , item, ) A buys (X, item, ) → buys ( X , item3 ) ) [s,c] II
What are the different types of the aggregate functions?
Normalize the following table up to 3NF. Show output and dependencies at each step. ClientRental clientNo cName propertyNo pAddress rentStart rentFinish rent ownerNo oName CR76 PG4 Tina Murphy John Кay 6 Lawrence St, 1-Jul-03 Glasgow 31-Aug-04 350 CO40 5 Novar Dr, Glasgow PG16 1-Sep-04 1-Sep-05 450 CO93 Tony Shaw 6 Lawrence St, 1-Sep-02 Glasgow Tina Murphy Aline Stewart CR56 PG4 10-June-03 350 CO40 PG36 2 Manor Rd, 10-Oct-03 1-Dec-04 375 CO93 Tony Shaw Glasgow 5 Novar Dr, Glasgow PG16 1-Nov-05 10-Aug-06 450 CO93 Tony Shaw
There are three tables in this database (see image). Write MYSQL code for: (1) Create a trigger “insert_inventory” on table “Inventory”. The trigger is fired after a row is inserted in table “Inventory”. After a row is inserted in table “inventory”, the “itemid”, the insertion time, and the action is inserted in table “Inventory_history”. The action is set to ‘add an item’. The oldprice is set to null. Test your trigger by inserting a row into Inventory and displaying the contents of Inventory_history. (2) Create a trigger “change_quantity” on table “Transaction”. The trigger is fired after a row is inserted in table “Transaction”. After a row is inserted in table “Transaction”, update the “quantity” in table “Inventory”. For example, if 3 iWatch are sold, then the quantity of iWatch in table “Inventory” is decreased by 3. Test your trigger by inserting a row into Transaction and displaying the contents of the relevant row in Inventory. (3) Create a trigger “change_price” on table…
Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date M EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Dno WORKS ON Essn Pno Hours M PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints Q2// Write SQL statements that carry out the following tasks: 1-alter the employee table to add column city of 20 characters. 2- alter the employee table to apply the following business rule The minimum salary is 3000 and maximum salary is 10000 3- insert sample data in each table . 4- display a list of each employee SSN, Name and Salary. 5- display a list of each employee SSN , Name and Salary for employees working in department no 2.
A better design would be one with the following tables: Patient : | pid | name | dob | addr | tel | Exam : | acc | pid | eid | result | date | ExamDictionary : | eid | name | normal | Questions: Create SQL queries (select statements) that accomplish the following. 1. List all of the Exams for Ms. Jones (pid=12). 2. List all of the Patients that hail from jolly old London. 3. List all of the Exams with results that exceed their normal. 4. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal. 5. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal, but list names only once and in alphabetical order.
Oracle PL/SQL Implement a trigger to the following constraints: Meter readers can only read a maximum of 5 meters in any given calendar month. Customers who do not pay their bill within 60 days will their water supply cut off. Once a customer has had their supply cut off, the person or business responsible for the bill will not be able to create a new account at a different service address until such time as their arrears have been cleared.