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?

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter3: Creating Tables

Section: Chapter Questions

Problem 13RQ

See similar textbooks

Similar questions

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 CUSTOMERS (plural). Each CustomerID should be a 3-digit number. Names should be strings of up to thirty characters. The sample data should be: 101, John Doe 102, [Rachel Araya] Order The table name should be ORDERS (plural). Each OrderID should be a 4-digit number. Product names should be strings of up to thirty characters. The sample data should be: 1001, 01-JAN-22, Apple, 101 1002, [a date of your choice], [a product of your choice], 102 PLEASE FOLLOW BELOW The SQL script to (i) drop the two tables, (ii) create the two tables, (iii) insert the sample data, and (iv) show the full contents of the two tables. The header of your script should be something like:/*Your NameIS451 HW5*/ Make sure to start your script file with DROP TABLE commands for the two tables in order to avoid…
question from database managment system (sql query) Exercise 1:Given an array of numbers as follows: x = [1 0 9 10 5 8 10 0 5 4 7 7 3 7], compute the following: 1) mode(x); 2) mean(x); 3) median(x). Exercise 2: For the same array x from Exercise 1, compute the 1) range (x); 2) standard deviation SD(x).
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.…
ou are working with a database table that contains customer data. The table includes columns about customer location such as city, state, country, and postal_code. The state names are abbreviated. You want to check for state names that are greater than 2 characters long. You write the SQL query below. Add a LENGTH function that will return any state names that are greater than 2 characters long. 1 2 3 4 5 SELECT * FROM customer WHERE ВыполнитьСбросить What country appears in row 1 of your query result? 1 балл Ireland France Chile India
What are all the different normalizations?
You are working with a database table that contains customer data. The table includes columns about customer location such as city, state, country, and postal_code. You want to check for postal codes that are greater than 7 characters long. You write the SQL query below. Add a LENGTH function that will return any postal codes that are greater than 7 characters long.
write MySQL functions to accomplish the following tasks: A:Delete the order whose number is stored in I_ORDER_NUM. B: Change the date of the order whose number is stored in I_ORDER_NUM to the date currently found in I_ORDER_DATE. C: Retrieve and output the item number, description, storehouse number, and unit price of every item in the category stored in I_CATEGORY.
You are working with a database table that contains customer data. The table includes columns about customer location such as city, state, country, and postal_code. You want to check for postal codes that are greater than 7 characters long. You write the SQL query below. Add a LENGTH function that will return any postal codes that are greater than 7 characters long. 1 SELECT 2 * 3 FROM 4 customer 5 WHERE What is the last name of the customer that appears in row 10 of your query result?
Using SQL answer the following or how would I answer something similar. Create a temporary table T for diagnoses_icd, such that only the first three characters of the diagnosis code are preserved. Subsequently, count the number of unique diagnoses in T count the number of unique diagnoses for each animal patient in T Repeat 1 entirely, except the first three digits in every diagnosis should be preserved (in addition to any letters) and saved in a temporary table T1. E.g., for code ‘S4001’ preserve ‘S400’; for ‘0456’ preserve ‘045’. Use T1 created in 2. Count animal patients diagnosed for each ICD code* and list the top 10 most common diagnoses. *Do not count a animal patient more than once for each ICD
Find a SQL query that computes a set difference and returns false positive(s) over a database with null values. You may show the correctness of your answer using an example.
Consider you have the following 2 tables. Employee_Table Employee_ID Employee_Name Address Salary in (Rs) Department_id 01 Arshad Karachi 20,000 01 02 Sanaullah Peshawar 30,000 02 03 Imran Peshawar 110,000 02 04 Asfahan Peshawar 95,000 01 05 Ayesha Peshawar 95,000 01 Dept_Table Dept_ID Dept_Name 01 Finance 02 IT 03 HR1. Write SQL Query for finding/displaying names and ids of employees whose salary is greater than 50,000 RS in ascending order of their salary 2. Create a View showing Employee names, their department name and salary of Employees from Peshawar only. Salary column should be displayed as ‘Total Salary’ 3. Delete employees’ data who are from Karachi. 4. Write SQL Right Outer Join query and its output on the given two tables.
i wants to insert sucha csv in a table into a sql developer table . population.csv Quebec (Que.),791.9,46.8273212, -71.2349247 Sherbrooke (Que.),210,45.4009928, -71.8824288 Trois Rivieres Quebec,155,46.3432397, -72.5432834 Montreal (Que.),"3981.80",45.491577, -73.64106699999999 ---- so i create a table like this Error starting at line : 2 in command -CREATE TABLE populationtest ( place int AUTO_INCREMENT, Population int DEFAULT 0, lat decimal(6,2) default 0.00, ion decimal(6,2) default 0.00)Error report -ORA-00907: missing right parenthesis00907. 00000 - "missing right parenthesis"*Cause: *Action: whats this error and how could i fix it correct ?