Recently, customer service representatives at your company have been complaining that retrieving a customer record takes too long.
The database was developed in house, and the amount of data has grown tremendously over the years. However, management does not want to use a commercial database because they believe the software and maintenance costs are too high. The old database used customer ID as an index field. Customer ID is an incremental number the system gives to each record when it initially creates the record. Also, the old database did not enforce data integrity, so data may not be consistent across all records.
Customer service representatives want to be able to retrieve records based on Last Name + First Name, Product Number, or State fields.
(A) What steps are involved in your analysis of this problem?
(B) Write code to process the 3 possible searches. Sample data is included for testing.
Attachment:- database.txt