PLEASE HELP SIR, USE BINARY SEARCH, THX. USING C LANGUAGE. +(D Page view A Read aloud V DrawF HighlightO Erase4of 17B. Record Finder[EN]You are given N customer data where each data contains AccNumber, name, age, and ballance. Thegiven data is sorted lexicographically ascending based on the AccNumber. Then, there are M queries.For each query, given a variable x. You are asked to tel whether a customer whose AccNumber is xexists. If so, output the customer's data. If the customer does not exist, output"-1".Input FormatThe first line consists of an integer N.The next N lines contain the given data. Each data consists of AccNumber, name, age, and balance,respectively, separated by commas.The next line consists of an integer M.The next M lines consist of an integer x, which representeach query.Output FormatFor each query, if the customer exists, then print the data with the following format: " ".Ifthere is no data to display, output "-1".Constraints1SN,M S5 x 10All given AccNumber and x in each query are a string consists of exactly 4 upper case Latinalphabet characters. It is guaranteed that there are no 2 data with the same AccNumber.• Length of the name is between 1 and 20 (inclusive). Names consist of Latin alphabets andwhitespaces. It is guaranteed that the first and last character are not whitespaces.• Ages are between 10 and 100 (inclusive)Balances are between 0 and 10.It is guaranteed that the balances are givenin 2 decimal places.Subtask 1 (80 points):• 1 SN,M S 103Subtasks 2 (20 points):No additional constraintSample InputSample Output D Page view A Read aloud V DrawF HighlightO Erase5of 17Frankie 16 999999999.99ANGE ,Andrew Garfield,18,110933. 25HAIS,Spectra Vgeist,18,2500e.eeNERA, Frankie, 16, 999999999.99TION,Dorot hy White, 22,0.eeww,Michael 1,17,100008.eeMichael J 17 1e0eee.eeNERAJOLYwwNotesIn this problem, there are subtasks. If your solution can only solve subtask 1, then you will get 80points. For example, yourprogram is not efficient enough such that it can solve the problem with theconstraint program 1

Create a structure named as Customer which will hold data of one customer. Start :- Read N Create…

You are given N customer data whereeach data contains AccNumber, name, age, and ballance. The givendatais sortedlexicographically ascending based on the AccNumber. Then, there are M queries For each query. gven a variable x. You are asked to tel whether a customer whose AccNumber isx exists. If so, output the customer'sdata.if the customer doesnot exist, output"-1".

You are given N customer data whereeach data contains AccNumber, name, age, and ballance. The givendatais sortedlexicographically ascending based on the AccNumber. Then, there are M queries For each query. gven a variable x. You are asked to tel whether a customer whose AccNumber isx exists. If so, output the customer'sdata.if the customer doesnot exist, output"-1".

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

How would you sum up all of the information that is included in a data dictionary?
Explain the data dictionary. When and where does the data dictionary monitor its objects?Is there a data dictionary?
What is meant by free formatting explain
How would you characterize a data dictionary's contents?
Using C not C++
help with part iv) please
Hi, I am looking for some help to solve this question. I cannot figure out how to solve it and the code below is all I have. The application being used: PostgreSQL edition 12 or 13. I must use LANGUAGE PLPGSLQ as that is what the professor is looking for. Thank you for your help. Tables in the DB:instructor (id, name, dept_name, salary)teaches (id, course_id, sec_id, semester, year) CREATE TEMPORARY TABLE instructor_course_nums (ID VARCHAR(5),name VARCHAR(20),tot_courses INTEGER); CREATE OR REPLACE PROCEDURE Moreno_03_insCourseNumsProc(INOUT i_ID VARCHAR(5))LANGUAGE PLPGSQLAS$$BEGINSELECT name INTO instructor.name FROM instructor WHERE instructor.id = i_id;SELECT COUNT(*) INTO course FROM teaches WHERE teaches.id = i_id;SELECT COUNT(*) INTO l_Exist_count FROM instructor_course_nums WHERE instructor_id= i_id;END;$$;
Do you know how to explain a data dictionary's contents?
Which sorting routine do you think is best to use when sorting the information in a phone book for a large city? Why?
Hi, I am looking for some help to solve this question. I cannot figure out how to solve it and the code below is all I have. Please be advised I am using PostgreSQL. Thus, I must use LANGUAGE PLPGSLQ as that is what the professor is looking for. Thank you for your help. Code CREATE TABLE instructor_course_nums (ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25)); CREATE TEMPORARY TABLE instructor_course_nums (ID VARCHAR(5),name VARCHAR(20),tot_courses INTEGER); CREATE OR REPLACE PROCEDURE Moreno_03_insCourseNumsProc(INOUT i_ID VARCHAR(5))LANGUAGE PLPGSQLAS$$
TRUE OR FALSE // C PROGRAMMING LANGUAGE When a file opened for writing already exist its contents would be over written
Define the following formatting tags, Block quotations Need example also