You are interested in analyzing some hard-to-obtain data from two separate databases. Each database contains n numerical values—so there are 2n values total—and you may assume that no two values are the same. You'd like to determine the median of this set of 2n values, which we will define here to be the nth smallest value. However, the only way you can access these values is through queries to the databases. In a single query, you can specify a value k to one of the two databases, and the chosen database will return the kth smallest value that it contains. Since queries are expensive, you would like to compute the median using as few queries as possible. Give a recursive algorithm that finds the median value using at most O(logn) queries. Explain why your algorithm only requires at most O(log(n)) queries to locate the median?

You are interested in analyzing some hard-to-obtain data from two separate databases. Each database contains n numerical values—so there are 2n values total—and you may assume that no two values are the same. You'd like to determine the median of this set of 2n values, which we will define here to be the nth smallest value. However, the only way you can access these values is through queries to the databases. In a single query, you can specify a value k to one of the two databases, and the chosen database will return the kth smallest value that it contains. Since queries are expensive, you would like to compute the median using as few queries as possible. Give a recursive algorithm that finds the median value using at most O(logn) queries. Explain why your algorithm only requires at most O(log(n)) queries to locate the median?

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section: Chapter Questions

Problem 11RA

See similar textbooks

Similar questions

What happens if you try to decrease the scale or precision of a NUMBER column to a value less than the data already stored in the field?
Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle database account. You will submit a SQL script file and its entire outputs. The table name should be STUDENTS (plural). Each StudentID should be a five-digit number. LastName and FirstName must be entered. 12341, Doe, Jane 12342, [last name of your choice], [first name of your choice] 12343, [last name of your choice], [first name of your choice] Enrollment The table name should be ENROLLMENTS (plural). Quarters should be something like 2021Fall, 2022Winter, 2022Spring, 2022Summer1, 2022Summer2, 2022Summer10, and so forth. Grades in future quarters are entered as null. 2021Fall, 12341, IS411, A 2022Winter, 12342, IS421, null 2022Summer10, 12343, [course number of your choice], null Course The table name should be COURSES (plural). CourseNumbers should be strings of up to seven characters (e.g., IS411, DSC411, CSEC440). The course and instructor names should be strings of characters.…
using php We run a dog grooming shop, there are new 4 breeds that are being registered to our system. Please add their names, breeds, and ages to the database, also display the new inputs with non-prepared statements Requirement 1: Require the programmer to insert rows Requirement 2: Require the programmer to display the rows after they have been changed Requirement 3: Require use of a non-prepared statement
A manager has a list of items that have been sorted according to an item ID. Some of them are duplicates. She wants to add a code to the database that assigns a 1 to the item if it is unique, and if there are duplicates, assigns the number of the duplicate. An example is shown below. The first two items are unique, so the repeat code is 1. However, Item ID 37695 is listed six times, so the codes are assigned from 1 to 6, and so on. Explain how to assign the correct code using an IF statement Item ID Repeat Code35080 135222 137695 137695 237695 337695 437695 537695 637712 137722 137757 137757 2 In cell B2 enter 1, and then type a formula into cell B3, followed by dragging the formula down column B until it aligns with the last row in the Item ID column. Which of the following is the correct formula to type into cell B3?
What are all the different normalizations?
In Oracle database, if we have any field such as Job_Title field in any of our table then we can use DECODE function to sort the result based on our own numerical value. This can be done by including the following in ORDER BY clause: 1: ORDER BY DECODE(job-title,'Manager',3,Assistant',2,'Sales Rep', 1) DESC II: ORDER BY DECODE(job-title,'Manager', 3,'Assistant',2, Sales Rep', 1) ASC III I and II are correct IV I and II are incorrect ||| IV || 1
Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each…
Answer the questions using the database below. Tables and data contained in the database of a company that sells stationery products are given below. 1. Write the query listing the number and name of the customer who ordered the maximum quantity of the product named "Pen". When answering the questions, assume that each order will contain one type of product. PK: Primary Key FK: Foreign Key The queries should be prepared in MAMP program to run in MySQL. Trigger will be created by typing SQL command, not interface
If every student at a school is assigned a 4-digit person ID number, but 0 and 1 are not used in ID numbers and the numbers 8 and 9 are reserved for faculty, how many potential student ID numbers are there?
I cannot figure out this problem/question. Can someone help me solve this? I must use use postgreSQL to answer the question. For this problem create a table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the instructor_course_nums table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table, then the procedure makes sure the total number of courses taught in the instructor_course_nums table is up-to-date. You must name your procedure:<LastName>_<DOB_DayOfMonth>_insCourseNumsProcWhere <LastName> is your last name and <DOB_DayOfMonth> is the day of the monthyou were born. Below is an example of how I named my procedure:Morabito_05__insCourseNumsProc
I1. In a Database Company, there are two tables given below : Table : SALES Table : LOCATION SALESMANID NAME SALES LOCATIONID LOCATIONID LOCATIONNAME ANITA SINGH ARORA 250000 102 101 Delhi S2 Y.P. SINGH 1300000 101 102 Mumbai S3 TINA JAISWAL 1400000 103 103 Kolkata S4 GURDEEP SINGH 1250000 102 104 Chennai S5 SIMI FAIZAL 1450000 103 Write SQL queries for the following : () To display SalesmanlID, names of salesmen, LocationID with corresponding location names. (1) To display names of salesmen, sales and corresponding location names who have achieved Sales more than 1300000. (m) To display names of those salesmen who have "SINGH in their names. ) Identify Primary key in the table SALES. Give reason for your choice. () Write SQL command to change the LocationID to 104 of the Salesman with ID as S3 in the table ICBSE OD 151 "SALES'.
How many queries remain before you can determine whether database as a service is the optimal solution for your library's needs?