Database serach using Java
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
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.
Education
- BCom, SGTB Khalsa College, University of Delhi
- MBA, Rochester Institute of Technology
Recent Feedback
- "Thank you. "
- "Thank you"
- "Thank you. I got 20/20 last week for my discussion you help me out with."
- "Thank you. Great Job. "
- "Thank you. Great Job. "
Purchase this Solution
Free BrainMass Quizzes
C# variables and classes
This quiz contains questions about C# classes and variables.
Javscript Basics
Quiz on basics of javascript programming language.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Basic Networking Questions
This quiz consists of some basic networking questions.