A large retail company keeps sales data local to the individual branches where sales transactions were performed. To compute overall sales statistics, the company wants to avoid sending the full sales data set to a central server. Instead, only aggregated sales information (sum, average, minimum, variance, median, maximum) is sent from each branch to the central site. Which of the following statements are correct? a) The overall sum can be derived from the sums per branch. b) The overall average can be derived from the averages per branch. c) The overall minimum can be derived from the minimums per branch.

A large retail company keeps sales data local to the individual branches where sales transactions were performed. To compute overall sales statistics, the company wants to avoid sending the full sales data set to a central server. Instead, only aggregated sales information (sum, average, minimum, variance, median, maximum) is sent from each branch to the central site. Which of the following statements are correct? a) The overall sum can be derived from the sums per branch. b) The overall average can be derived from the averages per branch. c) The overall minimum can be derived from the minimums per branch.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 2.9CP

See similar textbooks

Similar questions

Database systems In SQL MurachCollege database. Provide a list of all of the students, the number of courses they are taking, and the number of different instructors they have across all of their courses. The first column should provide the last name of each student (column titled Student Last Name). The second column should provide the number of courses that each student is taking (column titled Number of Courses). The third column should provide the number of different instructors that each student has for all of the courses they are taking (column titled Number of Different Instructors). No other columns should be provided in the result. Organize the result by student last name in alphabetical order.
The table below lists customer/car hire data. Each customer may hire cars from various outlets. A car is registered at a particular outlet and can be hired out to a customer on a given date. carReg make model custNo custName hireDate outletNo outletLoc M565 OGD Ford Escort C100 Smith, J 14/5/98 01 Bearsden M565 0GD Ford Escort C201 Hen, P 15/5/98 01 Bearsden N734 TPR Nissan Sunny C100 Smith, J 16/5/98 01 Bearsden M134 BRP Ford Escort C313 Blatt, O 14/5/98 02 Kelvinbridge M134 BRP Ford Escort C100 Smith, J 20/5/98 02 Kelvinbridge M611 OPQ Nissan Sunny C295 Pen, T 20/5/98 02 Kelvinbridge The table shown above is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.
An insurance company needs to store their salespeople’s information who are selling their insurance policies. They already have a database with multiple tables, one of the tables (Salesperson) stores information about each salesperson along with the bonus percent they receive, based on the city where the insurance is sold. The table has the following fields: Salesperson(spID, spName, spBirthDate,spCitySelling, bonusPercent) spID: Unique identification number of the salesperson. spName: Full name of the salesperson. spBirthDate: Birthdate of the salesperson. spCitySelling: The city in which the salesperson is selling the insurance. bonusPercent: The bonus percent received by the salesperson based on the city in which he/she sells the insurance. Each salesperson can sell the insurance in just one city. However, for a city, there can be more than one salesperson appointed. Also, the bonus percent is fixed for each city. For example, all of the salespeople who sells insurance in…
The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100
I got a question on number 1 through 3 from MySQL. these are the steps: Write the SQL code that will list all of the drivers in the database that have been issued tickets. Write the SQL code that will list all of the drivers in the database that have not been issued tickets. Write the SQL code that will list all of the drivers in the database that have been issued tickets, along with the total number of tickets that they have been issued and the total amount of fines that they have been charged. Do you guys know how to do these steps?
Your university runs many hundreds of courses each semester and needs to keep track of key information on each one. Among the data needed for each course would be the following: - University course identification number - Department course ID and section number (for multiple sections of the same course) - Number of credits for the course Days and times the course meets - Room in which the course meets (building ID and room number) Maximum course enrollment Campus on which the course is held - Name of the course instructor - Number of students currently enrolled and the student ID of each such student - Course status: open (for additional enrollment), closed, or canceled You must be able to change the value of each of these ten data items and, upon request, display all of this information. Initially, the values of the first seven items are known–the last three aren't. Design and implement an abstract data type that can be used to model this university course entity.
The production manager at PVFC is concerned about support for purchased parts in products owned by customers. A simple analysis he wants done is to determine for each customer how many vendors are in the same state as that customer. Develop a list of all the PVFC customers by name with the number of vendors in the same state as that customer. (Label this computed result NumVendors.)
USE this part to write SQL statements Branch(branch_id:integer, branch_name:varchar(50), branch_location:varchar(40), money_on_hand:numeric(15,2) create table Branch (branch_id integer, branch_name varchar(50), branch_location varchar(40), money_on_hand numeric(15,2), primary key (branch_id)); Loan(loan_number:integer, branch_id:integer, amount:numeric(8,2)) foreign key branch_id references Branch(branch_id) create table Loan (loan_number integer, branch_id integer, amount numeric(8,2), primary key (loan_number), foreign key (branch_id) references Branch (branch_id)); Customer(customer_id:integer, customer_last_name:varchar(35),customer_first_name:varchar(25), customer_street:varchar(30), customer_zip:integer) create table…
There are thousands of customers in an ABC Bank who use ATM services. The ABC Bank stores its ATM users’ data in a database table where records are sorted based on Account Numbers as below: ATM Card # Account # PIN Name Balance (Rs.) 11122230 Ac321 999 Ali 5,000 11122231 AC431 888 Hina 3,000 11122232 AC453 777 Saad 8,000 11122233 AC534 666 Fahad 9,000 when Fahad inserts his ATM card, he enters PIN and the main screen appears which shows his Name and other details. The authentication system searches the provided ATM Card # in database table. If ATM Card # is found, the system authenticates the user by matching the input PIN with stored PIN and returns Fahad’s profile data. So, From the given array of ATM Card numbers i.e. to find Fahad’s ATM Card # a) Which searching technique is suitable (linear search, binary search) [1] b) Justify your answer [1] c) Write the code for your chosen…
Task 2: The Driver Relationship team wants to arrange workshops and education materials to the drivers. However, the team wants to create clusters of the drivers based on their experience in InstantStay. To collect these detail, you will need to create a SQL function called DRIVER_STATUS to determine the level of the driver as follows: MASTER: more than 4 travels PRO: more than 2 travels ROOKIE: 2 or less travels In addition, run the function to verify it works as expected and send them back the driver levels. Task: Create the DRIVER_STATUS function to create clusters of drivers based on experience. THIS CODE YOU SEE HERE IS WRONG. THERE IS AN ERROR AT LINE 2 DELIMITER < CREATE FUNCTION DRIVER_STATUS(int DRIVERID) RETURNS VARCHAR BEGIN DECLARE //to store number of travels Count int; //to store level Level VARCHAR; //Selects according to passed value SELECT COUNT(*) INTO Level FROM TRAVEL WHERE DRIVER_ID = DRIVERID; //returns level IF( Count > 4) THEN RETURN…
Write SQL or PL/SQL scripts for the following: 1) write an anonymous block program unit that show the vendors ( VENDOR_NAME, VENDOR_ID, VENDOR_STATE) for those vendors who live in a user-input state. (submit the code & screenshot of : input prompt, and result set) Try two test cases: vendor_State : AZ vendor_State : PA
Task 2: The Driver Relationship team wants to arrange workshops and education materials to the drivers. However, the team wants to create clusters of the drivers based on their experience in InstantStay. To collect these detail, you will need to create a SQL function called DRIVER_STATUS to determine the level of the driver as follows: MASTER: more than 4 travels PRO: more than 2 travels ROOKIE: 2 or less travels In addition, run the function to verify it works as expected and send them back the driver levels. SQL Database Test: SELECT DRIVER_ID, DRIVER_STATUS(DRIVER_ID) FROM DRIVERS Create the DRIVER_STATUS function Expected Results: DRIVER_ID DRIVER_STATUS(DRIVER_ID) 2001 MASTER 2002 ROOKIE 2003 PRO 2004 ROOKIE 2005 ROOKIE