Program to retrieve records based on last name-first name

Assignment Help Programming Languages

Reference no: EM1370162

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 (Java) to process the 3 possible searches. You have been given a data sample to use for testing.

Reference no: EM1370162

Questions Cloud

Strategic decision of productivity-wages and benefits : Prepare a 700-1,400-word paper explaining a company that has made the strategic decision based upon productivity, wages and benefits, and other fixed and variable costs. Examine the decision and its expected outcomes.

Calculating maximum profit : Campbell's sells used trailers, U, and new trailers, N. Its profits are given through Õ = 100N + 68U - 5N2 - 5U2 - 2NU. Determine Campbell's maximum profit is

Effect of length of new patents extension : Do you think the overall level of R&D would increase or reduce over the next 20 to 30 years if lengths of new patents were extended from 20 years to, say "forever"?

Explain the economic impacts of a tariff : Using graphs, describe the economic impacts of a tariff on a nation welfare, and show how a tariff would affect the current equilibrium value and quantity and import levels within a market.

Program to retrieve records based on last name-first name : Customer service representatives wish to be able to retrieve records based on Last Name + First Name, Product Number, or State fields. Write down steps involved in your analysis of this problem?

Explain the press got a hold of this change in plan : Explain the press got a hold of this change in plan before senior management had communicated the change to the rest of the employees throughout the country

Determining dollar amount of opportunity cost : When Burton Denson graduated with honors from the American Trucking Academy, his father gave him a $350,000 tractor-trailer rig. Recently, Burton was boasting to some fellow truckers that his revenues were typically $25,000 per month

Determine total profit functions : Philips Industries produces a certain product that can be sold directly to retail outlets or to the Superior firm for further processing and eventual sale as a completely different product.

Write a program to enter any number of integers in array : Write a program which permits a user to enter any number of integers, which are then stored in the array. After user enters integers, perform the following operations on array.

User Account

All Pages