A petrol pump company started their card services like ATM so that users do not need to carry cash and used card services like, ATM users’ data in a database table where records are sorted based on ATM Numbers as below:   Account # ATM Card # PIN Name Balance (Rs.) Zc321 11122254 123 Zain 5,000 ZC431 11122255 654 Muneeb 3,000 ZC453 11122232 968 Saad 8,000 ZC534 11122233 565 Fahad 9,000 ZC535 11122230 999 Basit 10,000 ZC536 11122231 787 Bilal 5,000 ZC537 11122255 556 Maryam 45,000 ZC538 11122256 442 Fatima 8,000   when Fatimah 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 her profile data.   So, From the given array of ATM Card numbers i.e.   to find Fatimah’s ATM Card #   a)      Which searching technique is suitable (linear search, binary search), Justify Your answer b)      Any change suggested for how the records are arranged?       c)      Write the code for your chosen search technique

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
icon
Related questions
Question

A petrol pump company started their card services like ATM so that users do not need to carry cash and used card services like, ATM users’ data in a database table where records are sorted based on ATM Numbers as below:

 

Account #

ATM Card #

PIN

Name

Balance (Rs.)

Zc321

11122254

123

Zain

5,000

ZC431

11122255

654

Muneeb

3,000

ZC453

11122232

968

Saad

8,000

ZC534

11122233

565

Fahad

9,000

ZC535

11122230

999

Basit

10,000

ZC536

11122231

787

Bilal

5,000

ZC537

11122255

556

Maryam

45,000

ZC538

11122256

442

Fatima

8,000

 

when Fatimah 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 her profile data.

 

So, From the given array of ATM Card numbers i.e.

 

to find Fatimah’s ATM Card #

 

a)      Which searching technique is suitable (linear search, binary search), Justify Your answer

b)      Any change suggested for how the records are arranged?

 

 

 

c)      Write the code for your chosen search technique

 

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Transaction Processing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education